Printable View
I have one stored procedure in MS SQL Server.
sp_DeleteEmployee @id INT
I can call this stored procedure by two way.
One is:
The other used Command Objcet and Parameter, then execute the Command Object.VB Code:
Which one is better? why?
This was just discussed yesterday in this thread...
http://www.vbforums.com/showthread.php?t=369262
And please don't name your stored procedures with an sp_ prefix.
Why shouldn't I name your stored procedures with an sp_ prefix?
SQL Server assumes a stored procedure with a sp_ prefix is a system stored procedure. The Master database is checked first and if the procedure exists there it will be executed. If not then the procedure in the current database is executed.
You can name my SPs whatever you want, I was just giving you some advice. :afrog:Quote:
Originally Posted by ychhuong