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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2004-02-19 : 08:41:45
|
| Rob writes "My question is whether or not a stored procedure will eleviate my error caused when trying to insert text that contains single or double quotation marks. I would expect that if the database table is set up correctly, i.e. column type is correct, that the stored procedure would store the information "as is". I would assume that because it is compiled yes?ThanksRob" |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2004-02-19 : 09:25:16
|
| Not sure what the question is.The stored procedure will execute a query and if that query is correct it will work.You presumably wan to pass parameters to an SP to do an insert. insert tblselect @p1, @p2, @p3Will work as long as you can get the data into the parameters - it doesn't matter if there are embedded quotes in them.You just have to get the values into the parameters correctly.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
|
|
|
Stored Procs and raw text with escape characters