我想将这个insert语句,做成1个储存过程,这个储存过程该怎样写?谢谢! create procedure 存储过程名asinsert into mytest(UserID, UserName, UserName1)values (1,N'张三',N'李四') 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 --通用一点的:create proc p_存储过程名@UserID int,@UserName nvarchar(10),@UserName1 nvarchar(10)asinsert into mytest(UserID, UserName, UserName1)values(@UserID,@UserName,@UserName1)go--调用exec p_存储过程名 1,N'张三',N'李四' 储存过程宏观上就等于多条单独运行的T_Sql语句的集合啊 create proc p_存储过程名@UserID int,@UserName nvarchar(10),@UserName1 nvarchar(10)asinsert into mytest(UserID, UserName, UserName1)select @UserID,@UserName,@UserName1go 自己练练手:Create procedure P_insert_Mytest@UserID int,@UserName nvarchar(10),@UserName1 nvarchar(10) asinsert into Mytest(UserID, UserName, UserName1)valuse (@UserID,@UserName,@UserName1)go或Create procedure P_insert_Mytest@UserID int,@UserName nvarchar(10),@UserName1 nvarchar(10) asinsert into Mytest select @UserID,@UserName,@UserName1go sql统计2个表中数据个数 并相加 如何根据行数触发打印 请 大家 看下这个 简单存储过程怪问题 ? SQL事务这样写是否能正常回滚? 怎么得到两天之间在各个月是多少天 求这样的一个sql语句,急 存储过程中使用分布式查询问题!!! Select 问题,在线等 为什么这条SQL语句会出错? 两个表查询 急,请问如何获取某个表的字段名称及类型?在线等,谢谢! 在tomcat下使用jdbc连接池访问其它机器的数据库连接速度慢是为什么??
@UserID int,
@UserName nvarchar(10),
@UserName1 nvarchar(10)
as
insert into mytest(UserID, UserName, UserName1)
values(@UserID,@UserName,@UserName1)
go--调用
exec p_存储过程名 1,N'张三',N'李四'
@UserID int,
@UserName nvarchar(10),
@UserName1 nvarchar(10)
as
insert into mytest(UserID, UserName, UserName1)
select @UserID,@UserName,@UserName1
go
Create procedure P_insert_Mytest
@UserID int,
@UserName nvarchar(10),
@UserName1 nvarchar(10)
as
insert into Mytest(UserID, UserName, UserName1)
valuse (@UserID,@UserName,@UserName1)
go或
Create procedure P_insert_Mytest
@UserID int,
@UserName nvarchar(10),
@UserName1 nvarchar(10)
as
insert into Mytest select @UserID,@UserName,@UserName1
go