stored procedures problem in SQL Server 2000
-
I was creating the stored procedure in SQL Server and durind that I stuck into an error The Query is Create Procedure Procedurename @names varchar; @roll int; as Insert into tablename values(@names , @roll) pankaj garg
-
I was creating the stored procedure in SQL Server and durind that I stuck into an error The Query is Create Procedure Procedurename @names varchar; @roll int; as Insert into tablename values(@names , @roll) pankaj garg
You should post your actual code because this may not be representative. The error in your example code is that you need to use commas when separating parameters into the stored procedure
"On two occasions, I have been asked [by members of Parliament], 'Pray, Mr. Babbage, if you put into the machine wrong figures, will the right answers come out?' I am not able to rightly apprehend the kind of confusion of ideas that could provoke such a question." --Charles Babbage (1791-1871) My: Website | Blog
-
I was creating the stored procedure in SQL Server and durind that I stuck into an error The Query is Create Procedure Procedurename @names varchar; @roll int; as Insert into tablename values(@names , @roll) pankaj garg