|
Posted by SQL on 03/09/06 15:05
True,
I should have been more specific and should have said that you have to
put them at the end if you want to call the proc with the parameters by
position instead of by name
CREATE PROCEDURE some_sp @x int = NULL, @u INT AS
select getdate()
go
EXEC some_sp @u = 123 --fine
EXEC some_sp 123 --will fail
http://sqlservercode.blogspot.com/
Navigation:
[Reply to this message]
|