存储过程
CREATE PROCEDURE insert1
(@ID int,@leixing char)
AS
DECLARE @Level int
BEGIN
select @level =prents from leixing where id = @id
end
insert into leixing (leixing,prents) values(@leixing,@Level)
GOsql语句
exec insert1 @id=40,@leixing=学习学习结果
那个[学习学习]在表中是一行空白 怎么回事传值传不过去?
CREATE PROCEDURE insert1
(@ID int,@leixing char)
AS
DECLARE @Level int
BEGIN
select @level =prents from leixing where id = @id
end
insert into leixing (leixing,prents) values(@leixing,@Level)
GOsql语句
exec insert1 @id=40,@leixing=学习学习结果
那个[学习学习]在表中是一行空白 怎么回事传值传不过去?
exec insert1 40,'学习学习'
insert into 表(字段1,字段2) values('值1','值2');
create proc insert1
@ID int,
@leixing nvarchar(50)
AS
DECLARE @Level intselect @level = prents from leixing where id = @idinsert into leixing (leixing,prents) values(@leixing,@Level)GO
@ID int,
@leixing nvarchar(200)
AS
select @level =prents from leixing where id = @id
insert into leixing(leixing,prents) values(@leixing,@Level)
@ID int,
@leixing nvarchar(50)
AS
DECLARE @Level intselect @level = prents from leixing where id = @idinsert into leixing (leixing,prents) values(@leixing,@Level)GOexec insert1 40,'学习学习'
你的插入语句根本不在存储过程中,存储过程到 end 标记的时候就结束了 !
CREATE PROCEDURE insert1
@ID INT,
@leixing NVARCHAR(32)
AS
DECLARE @Level int
BEGIN
select @level =prents from leixing where id = @id
end
insert into leixing (leixing,prents) values(@leixing,@Level)
GO--sql语句
EXEC insert1 @id=40,@leixing='学习学习'
exec insert1 @id=40,@leixing=学习学习改为
exec insert1 @id=40,@leixing='学习学习'
exec insert1 @id=40,@leixing=学习学习改为
exec insert1 @id=40,@leixing='学习学习'
CREATE PROCEDURE insert1
@ID INT,
@leixing NVARCHAR(32)
AS
DECLARE @Level int
BEGIN
select @level =prents from leixing where id = @id
insert into leixing (leixing,prents) values(@leixing,@Level)
GO--sql语句
EXEC insert1 @id=40,@leixing='学习学习'