Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]
Groups > comp.databases.ms-sqlserver > #1386
| Path | csiph.com!usenet.pasdenom.info!gegeweb.org!eternal-september.org!feeder.eternal-september.org!mx05.eternal-september.org!.POSTED!not-for-mail |
|---|---|
| From | Erland Sommarskog <esquel@sommarskog.se> |
| Newsgroups | comp.databases.ms-sqlserver |
| Subject | Re: Purge Utility |
| Date | Wed, 13 Feb 2013 22:25:31 +0100 |
| Organization | Erland Sommarskog |
| Lines | 21 |
| Message-ID | <XnsA166E41F444F0Yazorman@127.0.0.1> (permalink) |
| References | <695679d9-3eb9-44c8-a7fb-2e60ef2b8373@googlegroups.com> |
| Mime-Version | 1.0 |
| Content-Type | text/plain; charset=windows-1252 |
| Content-Transfer-Encoding | 8bit |
| Injection-Info | mx05.eternal-september.org; posting-host="e87282ec96c371b8272e2d14c79930f2"; logging-data="22265"; mail-complaints-to="abuse@eternal-september.org"; posting-account="U2FsdGVkX1+2q5QYU8sFhJl7BTw9rorM" |
| User-Agent | Xnews/2006.08.24 Mime-proxy/2.1.c.0 (Win32) |
| Cancel-Lock | sha1:b0a9NM4N1/wD2JewNy6SN9bjeQk= |
| Xref | csiph.com comp.databases.ms-sqlserver:1386 |
Show key headers only | View raw
JAW (jwilliam@aglresources.com) writes: > When I run code with the apostrophes like the above I get an error > saying that a syntax error exists. When I supplemented the code you posted with variable declarations and a CATCH block, the code executed successfully. Is your dynamically generated SQL producing an error? Did you look at the actual code? You seem to have a PRINT there? -- Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se Links for SQL Server Books Online: SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
Back to comp.databases.ms-sqlserver | Previous | Next — Previous in thread | Next in thread | Find similar
Purge Utility JAW <jwilliam@aglresources.com> - 2013-02-13 12:44 -0800
Re: Purge Utility Erland Sommarskog <esquel@sommarskog.se> - 2013-02-13 22:25 +0100
Re: Purge Utility JAW <jwilliam@aglresources.com> - 2013-02-14 08:10 -0800
Re: Purge Utility Erland Sommarskog <esquel@sommarskog.se> - 2013-02-14 21:00 +0100
Re: Purge Utility JAW <jwilliam@aglresources.com> - 2013-02-14 08:22 -0800
Re: Purge Utility JAW <willjamu@gmail.com> - 2013-02-21 17:38 -0800
Re: Purge Utility rja.carnegie@gmail.com - 2013-02-21 18:04 -0800
csiph-web