SQL中四条基本的语名:
select [选取字段名] from [表名] where [条件]
insert into [表名] [字段(也可不填)]values ([对应的字段值])
update [表名] set [修改字段和对应的值] where [条件]
delete from [表名] where [条件]
存储过程的基本结构:(不区分大小写)
create procedure dbo.[名称]
@Sql varchar(200)...[传入的参数]
AS
declare @Sql varchar(200)..[字义变量]
begin
...
end
exec([执行的SQL语句])
print([执行的SQL语句])
select [选取字段名] from [表名] where [条件]
insert into [表名] [字段(也可不填)]values ([对应的字段值])
update [表名] set [修改字段和对应的值] where [条件]
delete from [表名] where [条件]
存储过程的基本结构:(不区分大小写)
create procedure dbo.[名称]
@Sql varchar(200)...[传入的参数]
AS
declare @Sql varchar(200)..[字义变量]
begin
...
end
exec([执行的SQL语句])
print([执行的SQL语句])