Database

public class ConcatTest
{
   public static void Main(string[] args)
   {
      string x = args[0] + args[1] + args[2] + args[3];
   }
}

.method public hidebysig static void Main(string[] args) cil managed
{
      .entrypoint
      // Code Size: 19 byte(s)
      .maxstack 5
      .locals (
            string text1)
      L_0000: ldarg.0 
      L_0001: ldc.i4.0 
      L_0002: ldelem.ref 
      L_0003: ldarg.0 
      L_0004: ldc.i4.1 
      L_0005: ldelem.ref 
      L_0006: ldarg.0 
      L_0007: ldc.i4.2 
      L_0008: ldelem.ref 
      L_0009: ldarg.0 
      L_000a: ldc.i4.3 
      L_000b: ldelem.ref 
      L_000c: call string string::Concat(string, string, string, string)
      L_0011: stloc.0 
      L_0012: ret 
}

Do you want to know more?

SET IDENTITY INSERT <tablename> ON 
UPDATE <tablename>
SET id = id + 100
SET IDENTITY INSERT <tablename> OFF

set rst = conn.execute("select job_title, job_descr from jobs")
strTitle = rst.Fields("job_title").value & ""
vChunk = rst.Fields("job_descr").GetChunk(4000)
strDescr = vChunk
Do Until IsNull(vChunk) = true
  vChunk = rst.Fields("job_descr").GetChunk(4000)
  vDescr = vDescr & vChunk
Loop

<code>CREATE PROCEDURE dbo.GetGuestbookData
	(	
		@SortOrder varchar(64)
	)
AS
	IF @SortOrder='ASC'
		BEGIN
			SELECT *
			FROM Guestbook INNER JOIN Users
			ON Guestbook.AuthorID = Users.RecordID
			ORDER BY Guestbook.RecordID ASC
		END
	ELSE
		BEGIN    
			SELECT *
			FROM Guestbook INNER JOIN Users
			ON Guestbook.AuthorID = Users.RecordID
			ORDER BY Guestbook.RecordID DESC
		END
RETURN </code>