View Single Post
Old September 11th, 2006, 08:09 AM
mike_remember mike_remember is offline
Friend of Wrox
Points: 1,935, Level: 17
Points: 1,935, Level: 17 Points: 1,935, Level: 17 Points: 1,935, Level: 17
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
Join Date: Aug 2004
Location: United Kingdom
Posts: 550
Thanks: 0
Thanked 1 Time in 1 Post

quote:Originally posted by dparsons

Thats an incorrect statement, you can pass SQL commands such as scripts is describing without creating a Stored Procedure. The problem here is the ('), that is a reserved character in TSQL as it defines the bounds for data that is being placed in X column (where strings are concerned).

The Answer here is to replace the (') with a special character (e.g. the ASCII equivelant) and that will correct the problem.

"The one language all programmers understand is profanity."
Come on

How can you say that it is possible to insert an apostrophe using text command........ In any scenario, you won't be able to insert that single quote to the database except procedure.

The only alternate is to replace the single quote with space or something other character.