解决方案 »
- 怎么查看数据库服务器是什么时间启动和关闭的,有办法吗
- 判断字符串中是否有子串
- 条件中加"主键 is not null"对效率有多大的影响?
- 求一复杂的SQl语句,请大侠指点一下,谢谢!!
- 获取本周周一、周末的时间
- "北京"个人求职: 本人正在北京找软件开发方面的工作!求助大家!
- 用sql server数据库时,在IIS里要配置什么吗?
- SQL Server 阿拉伯语言问题
- vb能不能实时地检测到往表里(sql server)写入了数据?
- 最近的项目,数据库中设计了92个用户表,头都大了。请问各位高手,你们现在用的数据库中有多少个表
- 查询条件非空为‘0’,空且不为“无”或“不是”则为‘1’怎么写
- sql语句查询日期用哪个更好呢?
多谢回复! 请问重新覆盖一次是指什么? 那个数据库我创建了一个app data文件夹,然后放到里面,webconfig里面是attachDBFile那种方式,我重新建一个网站,重新这么做还是一样。如果你说的覆盖是把数据库再往里面拷一下的话, 我觉得还是没什么变化吧。
存储过程会延迟解析,就算你没这个表还是可以创建成功
有student表, 我已经把表列在帖子上面了
ALTER PROCEDURE updateStudentInfo
(
@studentID int,
@columnName nvarchar(50),
@columnValue nvarchar(50)
)
AS
begin
if(@columnName = 'studentname')
update student set studentname = @columnValue where studentID = @studentID
if(@columnName = 'studentsex')
update student set studentsex = @columnValue where studentID = @studentID
if(@columnName = 'studentage')
update student set studentage = @columnValue where studentID = @studentID
if(@columnName = 'studentphone')
update student set studentphone = @columnValue where studentID = @studentID
if(@columnName = 'studentemail')
update student set studentemail = @columnValue where studentID = @studentID
if(@columnName = 'studentaddress')
update student set studentaddress = @columnValue where studentID = @studentID
if(@columnName = 'studentinfo')
update student set studentinfo = @columnValue where studentID = @studentID
end或者删除存储过程updateStudentInfo,然后用如下:
create PROCEDURE updateStudentInfo
(
@studentID int,
@columnName nvarchar(50),
@columnValue nvarchar(50)
)
AS
begin
if(@columnName = 'studentname')
update student set studentname = @columnValue where studentID = @studentID
if(@columnName = 'studentsex')
update student set studentsex = @columnValue where studentID = @studentID
if(@columnName = 'studentage')
update student set studentage = @columnValue where studentID = @studentID
if(@columnName = 'studentphone')
update student set studentphone = @columnValue where studentID = @studentID
if(@columnName = 'studentemail')
update student set studentemail = @columnValue where studentID = @studentID
if(@columnName = 'studentaddress')
update student set studentaddress = @columnValue where studentID = @studentID
if(@columnName = 'studentinfo')
update student set studentinfo = @columnValue where studentID = @studentID
end