这是表的创建SQL语句if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[it]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[it]
GOCREATE TABLE [dbo].[it] (
[itID] [int] IDENTITY (1, 1) NOT NULL ,
[itname] [varchar] (10) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[itdep] [varchar] (20) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[itlianxi] [varchar] (20) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[itwenti] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL
) ON [PRIMARY]
GO我存储过程这样写,老报错错误170;第6行;'@uitwenti'附近语法错误,必须声明变量'@uitlianxi'.郁闷ING
不知和什么有关系??create proc inset
@uitID int(4),
@uitname varchar(50),
@uitdep varchar(50),
@uitlianxi varchar(50)
@uitwenti varchar(50),
as
insert into login ([itID],itname,itdep,itlianxi,itwenti) values (@uitID,@uitname,@uitdep,@uitlianxi,@uitwenti)
drop table [dbo].[it]
GOCREATE TABLE [dbo].[it] (
[itID] [int] IDENTITY (1, 1) NOT NULL ,
[itname] [varchar] (10) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[itdep] [varchar] (20) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[itlianxi] [varchar] (20) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[itwenti] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL
) ON [PRIMARY]
GO我存储过程这样写,老报错错误170;第6行;'@uitwenti'附近语法错误,必须声明变量'@uitlianxi'.郁闷ING
不知和什么有关系??create proc inset
@uitID int(4),
@uitname varchar(50),
@uitdep varchar(50),
@uitlianxi varchar(50)
@uitwenti varchar(50),
as
insert into login ([itID],itname,itdep,itlianxi,itwenti) values (@uitID,@uitname,@uitdep,@uitlianxi,@uitwenti)
解决方案 »
- Asp.net登录控件的问题 紧急程度:高
- repeater怎么同时绑定两张表中不同的数据
- 如何实现图片的不间断循环滚动?
- asp.net调用sybase存储过程,参数问题
- Asp.net ajax(Altas) 的最新版本是什么?有相关文档下载吗?
- 关于用xxxx.aspx?name=XX传中文字的问题
- ajax & page_load & Response.Write & Sys.WebForms.PageRequestManagerParserErrorException
- 急需解决的问题,现在在线上等待!!
- 请问这个页面怎么没有按钮显示出来?是不是哪里配置错了。
- 请问一定要手工通过WSDL创建代理类吗?
- 如何在后台用代码定位到前台的内部链接?
- 求一个编译asp.net 工程的 Nant 的 build文件。尽量简单点的,初学。
@uitID int(4),
@uitname varchar(50),
@uitdep varchar(50),
@uitlianxi varchar(50) <== 少了 ,
@uitwenti varchar(50),
as
insert into login ([itID],itname,itdep,itlianxi,itwenti) values (@uitID,@uitname,@uitdep,@uitlianxi,@uitwenti)
@uitID int(4),
@uitname varchar(50),
@uitdep varchar(50),
@uitlianxi varchar(50),
@uitwenti varchar(50),
as
insert into login ([itID],itname,itdep,itlianxi,itwenti) values (@uitID,@uitname,@uitdep,@uitlianxi,@uitwenti)马虎
@uitname varchar(50),
@uitdep varchar(50),
@uitlianxi varchar(50),
@uitwenti varchar(50),
as
insert into login ([itID],itname,itdep,itlianxi,itwenti) values (@uitID,@uitname,@uitdep,@uitlianxi,@uitwenti)加了逗号还是不行,说as附近有错误啊
错误2716,第1个列或参数;不能对数据型int指定列宽度参数'@uitid'的数据类型无效.
@uitID int,
@uitname varchar(50),
@uitdep varchar(50),
@uitlianxi varchar(50),
@uitwenti varchar(50)
as
insert into login ([itID],itname,itdep,itlianxi,itwenti) values (@uitID,@uitname,@uitdep,@uitlianxi,@uitwenti)
@uitID int(4),-->@uitID int
[itID] [int] IDENTITY (1, 1) NOT NULL 这个itID是IDENTITY 类型的,你不能对它进行值的指定,去掉它就可以了.这个字段会自动生成一个数值的.
记得给分哈.
@uitname varchar(50),
@uitdep varchar(50),
@uitlianxi varchar(50),
@uitwenti varchar(50)
)as
insert login (itname,itdep,itlianxi,itwenti) values (@uitname,@uitdep,@uitlianxi,@uitwenti)