先请各位帮我看看我这个插入的存储过程
我这样写是不是失去了用存储过程的意义?
CREATE PROCEDURE [dbo].[insertinfo]
@UU int,
@Nationality varchar(20),
@QQ varchar(20),
@Phone varchar(20),
@Birth smalldatetime,
@Constellation varchar(10),
@Characters varchar(20),
@Stature smallint,
@Body varchar(20),
@Marry bit,
@SchoolAge varchar(10),
@Vocation varchar(10),
@Joss varchar(20),
@Hobby varchar(20),
@Email varchar(20),
@Reason varchar(50),
@Nickname varchar(20),
@Gender bit,
@Age smallint,
@City varchar(20),
@Proclamation varchar(50),
@Profile image,
@PassWord varchar(50)
AS
INSERT INTO MakeFriends (UU,Nationality,QQ,Phone,Birth,Constellation,Characters,Stature,Body,Marry,SchoolAge,Vocation,Joss,Hobby,Email,Reason,Nickname,Gender,Age,City,Proclamation,Profile,Password) values(@UU,@Nationality,@QQ,@Phone,@Birth,@Constellation,@Characters,@Stature,@Body,@Marry,@SchoolAge,@Vocation,@Joss,@Hobby,@Email,@Reason,@Nickname,@Gender,@Age,@City,@Proclamation,@Profile,@Password)
RETURN
GO那些地方需要增加?或者修改
写个这个表的更新的存储过程应该怎么写 注意什么
我这样写是不是失去了用存储过程的意义?
CREATE PROCEDURE [dbo].[insertinfo]
@UU int,
@Nationality varchar(20),
@QQ varchar(20),
@Phone varchar(20),
@Birth smalldatetime,
@Constellation varchar(10),
@Characters varchar(20),
@Stature smallint,
@Body varchar(20),
@Marry bit,
@SchoolAge varchar(10),
@Vocation varchar(10),
@Joss varchar(20),
@Hobby varchar(20),
@Email varchar(20),
@Reason varchar(50),
@Nickname varchar(20),
@Gender bit,
@Age smallint,
@City varchar(20),
@Proclamation varchar(50),
@Profile image,
@PassWord varchar(50)
AS
INSERT INTO MakeFriends (UU,Nationality,QQ,Phone,Birth,Constellation,Characters,Stature,Body,Marry,SchoolAge,Vocation,Joss,Hobby,Email,Reason,Nickname,Gender,Age,City,Proclamation,Profile,Password) values(@UU,@Nationality,@QQ,@Phone,@Birth,@Constellation,@Characters,@Stature,@Body,@Marry,@SchoolAge,@Vocation,@Joss,@Hobby,@Email,@Reason,@Nickname,@Gender,@Age,@City,@Proclamation,@Profile,@Password)
RETURN
GO那些地方需要增加?或者修改
写个这个表的更新的存储过程应该怎么写 注意什么
解决方案 »
- 求sql语句
- SQL Server 2000如何把一张Excel表导进去啊 ?
- 求一条根据条件产生一条随机ID记录的select语句?
- 请问2005中如何设置默认值,2000恢复到2005,2000里面有一个默认值pp,
- sqlserver的日志文件有何用?
- select distinct top 10 percent qy_name,qy_add from biao order by newid()随机取记录,distinct无效,怎么解决?顶者有分!
- Companyname varchar(20) NOT NULL,請教!
- 如何判断汉字的前半部与后半部?
- 如何让系统自动控制从表改变状态的前提是对应的主表满足一定条件?
- 高分求一存储过程(分不够在加)
- 在此上下文中不能使用带有返回值的 RETURN 语句
- 如何学习sqlserver2000???
如果您知道怎么写insert的话,就知道怎么写update的了
写个这个表的更新的存储过程应该怎么写 注意什么
update MakeFriends
set Nationality=@Nationality,......這樣用
where
UU=@UU--主健
……
as
update MakFriends set 字段=@参数,……,where 条件
update tbname set col = '' where ....