I urgently need help on how to execute a stored procedure in SQL Express 2005. I have created a stored procedure with as follows:
Create Procedure upInsertCountry
@CountryName varchar(50)
INSERT INTO CountryTable (CountryName) VALUES (@CountryName)
When run the following code :
myCom.CommandTy pe.StoredProced ure
myCom.CommandTe xt = "upInsertCountr y @CountryName...
moforiappiah
Last Activity: Sep 8 '07, 04:53 PM
Joined: Sep 8 '07
Location:
-
Executing a Stored Procedure using Command Text
-
Incorrect Sytax Error
I have a script file that contains the name of a stored procedure, its parameters and values. When I run it in VB2005 code against SQL Express 2005 database, it gives me the error Incorrect Syntax near 'StoredProcedur eName'. But when i copy the script and run it in the Server Management Stuido, it works. Any help please!!!!
No activity results to display