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.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 Pob regarding Stored Procs

Author  Topic 

chandrashekar
Starting Member

3 Posts

Posted - 2004-08-18 : 01:54:49
Hi All,

I am facing problem of sending a Parameter with single quotes into a stored procedure

eg:
exec somestrproc 23,23,23,'ajsdasd'asdas'

because it's throwing an error. Please try to give the solution. I have also tried the two single quotes trick

Thanks in Advance,
chandrashekar

timmy
Master Smack Fu Yak Hacker

1242 Posts

Posted - 2004-08-18 : 01:57:23
How are you calling the stored procedure? Is it through ADO?
Please post the SP code and the code you're using to call it.
Go to Top of Page
   

- Advertisement -