|
Posted by David Portas on 10/21/82 11:31
Don't ever create or alter procs in Enterprise Manager. Use Query
Analyzer and specify SET QUOTED_IDENTIFIER and ANS_NULLS ON or OFF as
required. Prefereably always ON.
Your code fragment looks wrong anyway. Presumably it should be:
SELECT @SQL1 = 'SELECT @Total1 = Count(*) FROM dbo.Tbl_Report WHERE
Utilisateur = '''+@utilisateur+''''
Don't use double quotes for string delimiters.
--
David Portas
SQL Server MVP
--
Navigation:
[Reply to this message]
|