InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comWed, 19 Jun 2013 13:22:46 GMT20http://www.sqlservercentral.com/Forums/Topic1422523-3077-1.aspxhi,yes it helps a lot !thank you very much. I ll try this tomorrow at workWed, 03 Apr 2013 16:58:39 GMTohpenothttp://www.sqlservercentral.com/Forums/Topic1422523-3077-1.aspxIt all has to do about strings ... And what is truely a string?First example does not have quotes in the string.-- Simple stringDECLARE @X VARCHAR(128);SET @X = 'A SIMPLE STRING';PRINT @X;Second example uses extra quote to denote usage as a literal, not a start of a string. -- Escaping the quotesDECLARE @Y VARCHAR(128);SET @Y = 'A STRING WITH ''' + CONVERT(CHAR(10), GETDATE(), 101) + ''' QUOTES AROUND THE DATE';PRINT @Y;Third example uses the ANSI character for quote.-- Using CHAR()DECLARE @Z VARCHAR(128);SET @Z = 'A STRING WITH ' + CHAR(39) + CONVERT(CHAR(10), GETDATE(), 101) + CHAR(39) + ' QUOTES AROUND THE DATE';PRINT @Z;You can use the system function QUOTENAME() to make quoted strings.http://msdn.microsoft.com/en-us/library/ms176114.aspxYou can even change the character used for escaping (ESCAPE) in a LIKE statement.http://msdn.microsoft.com/en-us/library/ms179859.aspxI hope this helps.SincerelyJohnTue, 02 Apr 2013 10:22:41 GMTj.minerhttp://www.sqlservercentral.com/Forums/Topic1422523-3077-1.aspxI t works using ''''SET @effacer = 'master.dbo.xp_cmdshell ''DEL '+ @chemin + @filename +''''but i don't understand why (tried everything)Thu, 21 Feb 2013 06:12:43 GMTohpenothttp://www.sqlservercentral.com/Forums/Topic1422523-3077-1.aspxHi everybody,I struggled with a bulk insert in procedure and i eventually found a working piece of code. Except that i did'nt understand the general rules to wrap variables.Exemple : N'BULK INSERT ' + QUOTENAME(@nomtable) + N'FROM ''' + @chemin + @filename + N''' WITH (FIELDTERMINATOR = '';'', ROWTERMINATOR = '''', FIRE_TRIGGERS)'This is working, but why are we using ''' ??Now something that's not working..SET @effacer = 'master.dbo.xp_cmdshell ''DEL '+ @chemin + @filenameEXECUTE (@effacer)Something wrong with quotes i guess....I'd like to understand the rule for this!Thu, 21 Feb 2013 06:09:25 GMTohpenot