CREATE PROC dbo.search @id int AS select * from b where num=@id goexec search 1
CREATE PROC dbo.search @id int AS select * from educh_News where Member=@id GO
未发现你的代码有什么错误. CREATE PROC dbo.search @id int AS select * from educh_News where Member=@id GO
你的代码是复制来的,含有不可见非法字符。 CREATE PROC dbo.search --把以下几行最前面的空格(这几个空格实际是非法字符)去掉即可: @id int AS select * from educh_News where Member=@id GO ------------ 如下: CREATE PROC dbo.search --把以下几行最前面的空格(这几个空格实际是非法字符)去掉即可: @id int AS select * from educh_News where Member=@id
@id int
AS
select * from b where num=@id
goexec search 1
CREATE PROC dbo.search
@id int
AS
select * from educh_News where Member=@id
GO
CREATE PROC dbo.search @id int
AS
select * from educh_News where Member=@id
GO
你的代码是复制来的,含有不可见非法字符。
CREATE PROC dbo.search
--把以下几行最前面的空格(这几个空格实际是非法字符)去掉即可:
@id int
AS
select * from educh_News where Member=@id
GO
------------ 如下:
CREATE PROC dbo.search
--把以下几行最前面的空格(这几个空格实际是非法字符)去掉即可:
@id int
AS
select * from educh_News where Member=@id