一个超级菜鸟的困惑,请您伸伸温暖的双手!
小弟我毫无编程经验但很想学习ASP.NET和SQL SEVER
我已做了一个字段表但存储过程该怎么做呢?
字段表如下:
peixunID char(20)
shuihao char(18)
name char(10)
date datetime
chengji int
chengjileibie char(1)
yuanshuihao char(18)
beizhu text
请各位朋友多指教!!!1

你想用存储过程实现什么样的功能??

-- =============================================
-- Author: <Author,,Name>
-- Create date: <Create Date,,>
-- Description: <Description,,>
-- =============================================
ALTER PROCEDURE [dbo].[updatecjbasetable]
-- Add the parameters for the stored procedure here
@taxno char(15),
@quxian char(10),
@dymc char(50),
@address char(50),
@chbus char(50),
@fjyh char(50),
@dylxr char(10),
@dytel char(20),
@dysj char(11),
@pxr char(10),
@pxrsex char(10),
@pxrtel char(20),
@pxrsj char(11),
@userclass nchar(10),
@cjdate datetime,
@lxrsex char(10),
@userstate int,
@beizhu ntext
AS
BEGIN
-- SET NOCOUNT ON added to prevent extra result sets from
-- interfering with SELECT statements.
SET NOCOUNT ON;

update cjbasetable
set
taxno=@taxno,
quxian=@quxian,
dymc=@dymc,
address=@address,
chbus=@chbus,
fjyh=@fjyh,
dylxr=@dylxr,
dytel=@dytel,
dysj=@dysj,
pxr=@pxr,
pxrtel=@pxrtel,
pxrsj=@pxrsj,
userclass=@userclass,
cjdate=@cjdate,
lxrsex=@lxrsex,
pxrsex=@pxrsex,
userstate=@userstate,
beizhu=@beizhu
我想做一个向上面一样的输入存储.其实我一点也不会的
谢谢,请多指教

CREATE PROCEDURE updatecjbasetable
@taxno char(15),
@quxian char(10),
@dymc char(50),
@address char(50),
@chbus char(50),
@fjyh char(50),
@dylxr char(10),
@dytel char(20),
@dysj char(11),
@pxr char(10),
@pxrsex char(10),
@pxrtel char(20),
@pxrsj char(11),
@userclass nchar(10),
@cjdate datetime,
@lxrsex char(10),
@userstate int,
@beizhu ntext
AS
update cjbasetable
set
taxno=@taxno,
quxian=@quxian,
dymc=@dymc,
address=@address,
chbus=@chbus,
fjyh=@fjyh,
dylxr=@dylxr,
dytel=@dytel,
dysj=@dysj,
pxr=@pxr,
pxrtel=@pxrtel,
pxrsj=@pxrsj,
userclass=@userclass,
cjdate=@cjdate,
lxrsex=@lxrsex,
pxrsex=@pxrsex,
userstate=@userstate,
beizhu=@beizhu
WHERE 条件
GO