Escape sequence in SQL Server

• Shadab Shah

  SSCarpal Tunnel

  Points: 4759

  More actions

  January 17, 2013 at 6:03 am

  #287976

  Consider the following code

  CREATE TABLE EMP3(EMPNO INT IDENTITY,NAME NVARCHAR(50))

  INSERT INTO emp3 VALUES('ABC')

  INSERT INTO EMP3 VALUES('DEF')

  INSERT INTO EMP3 VALUES('GHI')

  INSERT INTO EMP3 VALUES('JKL')

  INSERT INTO EMP3 VALUES('MNO')

  CREATE TABLE #TEMP(NUM INT,NAME NVARCHAR(50))

  INSERT INTO #TEMP

  SELECT EMPNO,NAME FROM emp3

  In the above code the value getting inserted in #temp table is ABC, i want it as 'ABC'. I tried finding the escape sequences in SQL Server but could not find anything usefull in this case.

• mister.magoo

  SSC-Forever

  Points: 47174

  More actions

  January 17, 2013 at 6:05 am

  #1578269

  two single quotes are used inside the string, so 'ab''c' equals ab'c

  you want '''ABC'''

  MM
  

  ---

  
  select geometry::STGeomFromWKB(0x0106000000020000000103000000010000000B0000001000000000000840000000000000003DD8CCCCCCCCCC0840000000000000003DD8CCCCCCCCCC08408014AE47E17AFC3F040000000000104000CDCCCCCCCCEC3F9C999999999913408014AE47E17AFC3F9C99999999991340000000000000003D0000000000001440000000000000003D000000000000144000000000000000400400000000001040000000000000F03F100000000000084000000000000000401000000000000840000000000000003D0103000000010000000B000000000000000000143D000000000000003D009E99999999B93F000000000000003D009E99999999B93F8014AE47E17AFC3F400000000000F03F00CDCCCCCCCCEC3FA06666666666FE3F8014AE47E17AFC3FA06666666666FE3F000000000000003D1800000000000040000000000000003D18000000000000400000000000000040400000000000F03F000000000000F03F000000000000143D0000000000000040000000000000143D000000000000003D, 0);

• Forum Etiquette: How to post Reporting Services problems
[/url]
• Forum Etiquette: How to post data/code on a forum to get the best help - by Jeff Moden
[/url]
• How to Post Performance Problems - by Gail Shaw
[/url]