CREATE PROCEDURE CheckDisPlayID@InPutDisID varchar(32)as select count(*) as num from Department where DeDisplayID=@InPutDisID go
CREATE PROCEDURE dbo. CheckDisPlayID @InPutDisID varchar(32)AS begin select count(*) as num from Department where DeDisplayID=@InPutDisIDend================== 不要加括号了
也是可以执行的,没有像LZ所说的那些错误
select count(*) as num from Department where DeDisplayID=@InPutDisID
go
@InPutDisID varchar(32)AS
begin
select count(*) as num from Department where DeDisplayID=@InPutDisIDend==================
不要加括号了