CREATE PROC add(
@username varchar(100)
)
AS
BEGIN
set @username=SELECT username FROM atable
END
GO这样写不对呀,要怎样写呢?
SELECT username FROM atable条件限制之后只返回一个值
@username varchar(100)
)
AS
BEGIN
set @username=SELECT username FROM atable
END
GO这样写不对呀,要怎样写呢?
SELECT username FROM atable条件限制之后只返回一个值
@username varchar(100)
)
AS
BEGIN
set @username= isnull((SELECT Top 1 username FROM atable),'')
END
GO
(
@username varchar(100)
)
AS
BEGIN
select @username=username FROM atable
END
GO
@username=stuff(@username,1,1,'')
(
@username varchar(100)
)
AS
BEGIN
select @username=username FROM atable
END
GO
@username varchar(100)
)
AS
BEGIN
set @username=SELECT username FROM atable
END
GO
---???
你这是什么意思阿!??应该这样吧 CREATE PROC add1(@username varchar(100) output)
AS
SELECT @username= username FROM atable
厉害!!