.net 中如何写简单的存储过程

1.简单的查询存储过程

create procedure SP_GetAllUsers

as

begin

select * from T_User(tableName(表名称))

end

Go

-----------------------

2.根据用户Id来查询用户

create procedure SP_GetUserById

@Id int

as

begin

select * from T_User (tableName) where autoId=@Id;

end

Go

----------------------------------------------------------

3.简单的增加一个用户

create procedure SP_InsertTUser

@Id int,

@UName nvarchar(50),//参数的类型，大小一定要与数据库相对应的字段类型相同

@UAge int,

@UGender char(2)='男'//给定一个默认值

as

begin

insert into T_User(tableName) values(@id,@UName,@UAge,@Gender)

end

Go

注意：procedure 可以简写 proc 只写前四位就OK

转载于:https://www.cnblogs.com/88myself/archive/2011/06/07/2074678.html