ASP.NET学习社区

首页 » ASP.NET学习区 » 自由问答 » 问题待解决!!
风华乐舞 - 2008-5-4 17:40:00
create procedure[update_student_1]
(@student_id[varchar](50),
@student_name[varchar](50),
@student_sex[char](5),
@student_nation[char](5),
@Student_birthday[datetime],
@Student_time[datetime],
@Student_classid[varchar](50),
@Student_home[varchar](50),
@Student_else[varchar](50))
AS update [sms].[dbo].[student]
SET
student_name=@student_name,
student_sex=@student_sex,
student_nation=@student_nation,
Student_birthday=@Student_birthday,
Student_time=@Student_time,
Student_classid=@Student_classid,
Student_home=@Student_home,
Student_else=@Student_else
where student_id=@student_id;
  我存储过程
怎么解决 啊
风华乐舞 - 2008-5-4 17:46:00
create procedure[update_student1]
(@student_id[varchar](50),
@student_name[varchar](50),
@student_sex[char](5),
@student_nation[char](5),
@Student_birthday[datetime],
@Student_time[datetime],
@Student_classid[varchar](50),
@Student_home[varchar](50),
@Student_else[varchar](50))
AS update [sms].[dbo].[student]
SET
student_name=@student_name,
student_sex=@student_sex,
student_nation=@student_nation,
Student_birthday=@Student_birthday,
Student_time=@Student_time,
Student_classid=@Student_classid,
Student_home=@Student_home,
Student_else=@Student_else
where student_id=@student_id;
风华乐舞 - 2008-5-4 17:47:00
有个问题等待解决
create procedure[update_student1]
(@student_id[varchar](50),
@student_name[varchar](50),
@student_sex[char](5),
@student_nation[char](5),
@Student_birthday[datetime],
@Student_time[datetime],
@Student_classid[varchar](50),
@Student_home[varchar](50),
@Student_else[varchar](50))
AS update [sms].[dbo].[student]
SET
student_name=@student_name,
student_sex=@student_sex,
student_nation=@student_nation,
Student_birthday=@Student_birthday,
Student_time=@Student_time,
Student_classid=@Student_classid,
Student_home=@Student_home,
Student_else=@Student_else
where student_id=@student_id;
本文来自: ASP.NET学习门户(http://www.aspx1.com) 详细出处参考:http://i.aspx1.com/showtopic-719.aspx
aspx1 - 2008-5-4 17:57:00
存储过程怎么了?
另:别一个主题发多个帖子。你的心情可以理解,可如果大家都这样,这里就成垃圾区了
suresy - 2008-5-4 22:45:00
晕,看不懂楼主的问题,前3楼是什么关系?
1
查看完整版本: 问题待解决!!