sqlserver中存储过程的问题 小弟承认自己是个彩笔

Question

insert into client values('@userId','@conName','@conStartdate','@conEnddate','@clientName','@clientTitle','@clientMobilPhone','@clientPhone','@clientEmail','@clientAddress','@clientQq')去掉所有的'就ok了insert into client values(@userId,@conName,@conStartdate,@conEnddate,@clientName,@clientTitle,@clientMobilPhone,@clientPhone,@clientEmail,@clientAddress,@clientQq)

Answer 1

create proc proc_addClient
(
@userId varchar(50),
@conName varchar(50),
@conStartdate datetime,
@conEnddate datetime,
@clientName varchar(50),
@clientTitle varchar(20),
@clientMobilPhone char(11),
@clientPhone varchar(15),
@clientEmail varchar(50),
@clientAddress varchar(50),
@clientQq varchar(11)
)
as
insert into client values(@userId,@conName,@conStartdate,@conEnddate,@clientName,@clientTitle,@clientMobilPhone,@clientPhone,@clientEmail,@clientAddress,@clientQq)
go

Answer 2

不需要加引号吧，插入的时候判断你提交的日期格式
isdate(@conStartdate)

Answer 3

values后面是变量  不需要加''号