Viewing 5 posts - 1 through 5 (of 5 total)
It's also important to note that quite a bit of damage can be caused if this check is not done.
Imagine the following situation where we have dynamic sql:
'select count(*) from...
April 4, 2002 at 2:11 pm
#426644
Instead of using replace, you could use the function QUOTENAME() which does the same thing and is built into SQL Server.
select QUOTENAME('Frank''s Garage')
returns:
[Frank's Garage]
April 4, 2002 at 2:00 pm
#426640
quote: I have several production lines, and I want to use only 1 script. This generates temp tables, which are unique for each...
quote:
April 4, 2002 at 12:43 pm
#426626
quote: Merge replication requires that the tables must have a ROW GUID, see "How Merge Replication Works" in SQL Books Online for more...
April 4, 2002 at 12:24 pm
#426624
quote: I use the method of finding the job and then running it. Works pretty good. Drawback to using the exe's is that...
April 4, 2002 at 12:12 pm
#426623