CREATE PROCEDURE developer.LoginProc
(
@ID numeric(18,0),
@Names varchar(8) output
)
AS
SET NOCOUNT OFF
select @Names=name from table1 where @ID=1
Go
(
@ID numeric(18,0),
@Names varchar(8) output
)
AS
SET NOCOUNT OFF
select @Names=name from table1 where @ID=1
Go
(
@ID numeric(18,0),
@Names varchar(8) output
)
AS
SET NOCOUNT OFF
select @Names = [name] from table1 where @ID=1
Go
(
@ID numeric(18,0),
@Names varchar(8) output
)
AS
SET NOCOUNT ON
begin
select @names=name from table1 where id=@ID
end
Go