欢迎转载,转载请标明出处:https://blog.csdn.net/kuguhuan/article/details/98655255
操作步骤:
1.先创建一个存储过程,搭一个框架
create procedure ProTest --ProTest是存储名称
AS
Go
2.将数据从A表快速插入到B表
insert into UserFF(NAME, PWD)
select name, pwd from [User] where name = '10001'
这里的insert into不需要写values了
所以如下所示,实现一个存储过程,将数据从A表快速插入到B表
create procedure dbo.ProTest
AS
insert into UserFF(NAME, PWD)
select name, pwd from [User] where name = '10001'
Go