Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
skillile
Posting Yak Master
208 Posts |
 Posted - 2002-09-24 : 09:58:20
|
| Is there a way to insert a chr(13) + chr(10) into dynamic sql. ie SET @sql = 'DELETE FROM dbo.tbl ' SET @sql = @sql + '[LINE FEED]' SET @sql = @sql + 'GO' ....slow down to move faster... |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2002-09-24 : 09:59:58
|
| Uhhhhh...SET @sql = 'DELETE FROM dbo.tbl ' SET @sql = @sql + chr(13) + chr(10)SET @sql = @sql + 'GO' |
 |
|
|
skillile
Posting Yak Master
208 Posts |
Posted - 2002-09-24 : 10:08:16
|
| I keep getting this error:'chr' is not a recognized function name.slow down to move faster... |
|
|
|
skillile
Posting Yak Master
208 Posts |
Posted - 2002-09-24 : 10:10:27
|
| charsorryslow down to move faster... |
|
|
|
|
|
|
Line Feed Return