因为不存在gp_WriteValdateNum_Pro;2的存储过程。你可以创建多个同名的存储过程,然后在名字后面用;n来区分,调用时也是这样。例如
1> create procedure p_test1;1 (@i integer) as print @i*10
2> go
1> create procedure p_test1;2 (@i integer) as print @i*100
2> go
1> exec p_test1;1 100
2> go
1000
1> exec p_test1;2 100
2> go
10000
1>
1> create procedure p_test1;1 (@i integer) as print @i*10
2> go
1> create procedure p_test1;2 (@i integer) as print @i*100
2> go
1> exec p_test1;1 100
2> go
1000
1> exec p_test1;2 100
2> go
10000
1>
create procedure p_test1;2么?我在我的企业管理器里面没有找到create procedure p_test1;1这样的存储过程
CREATE PROCEDURE sp_t
asselect 11
GOCREATE PROCEDURE sp_t;2
as
select getdate()
GO