UC知道SQL server 2005 values子句问题
来源：百度知道 编辑：UC知道 时间：2024/05/25 06:56:18
SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
GO
ALTER PROCEDURE [dbo].[Procedure_addtchmsg]
(
@tch_sex nchar(10),
@tch_photo image,
@tch_race nvarchar(50),
@tch_native nvarchar(50),
@tch_face nvarchar(50),
@tch_idcard nvarchar(50),
@tch_edu nvarchar(50),
@tch_worktime smalldatetime,
@tch_post nvarchar(50),
@tch_course nvarchar(50),
@tch_duty nvarchar(50),
@tch_address nvarchar(MAX),
@tch_famphone nvarchar(50),
@tch_mobilephone nvarchar(50),
@tch_remark nvarchar(MAX)
)
AS
Insert into tb_tchmsg(tch_name,tch_sex,tch_photo,tch_race,tch_native,tch_face,tch_idcard,tch_edu,tch_worktime,tch_post,tch_course,tch_duty,tch_address,tch_famphone,tch_mobilephone,tch_remark)
values(@tch_name,@tch_sex,@tch_photo,@tch_race,@tch_native,@tch_face,@tch_idcard,@tch_edu,@tch_worktime,@tch_post,@tch_co
SET QUOTED_IDENTIFIER ON
GO
ALTER PROCEDURE [dbo].[Procedure_addtchmsg]
(
@tch_sex nchar(10),
@tch_photo image,
@tch_race nvarchar(50),
@tch_native nvarchar(50),
@tch_face nvarchar(50),
@tch_idcard nvarchar(50),
@tch_edu nvarchar(50),
@tch_worktime smalldatetime,
@tch_post nvarchar(50),
@tch_course nvarchar(50),
@tch_duty nvarchar(50),
@tch_address nvarchar(MAX),
@tch_famphone nvarchar(50),
@tch_mobilephone nvarchar(50),
@tch_remark nvarchar(MAX)
)
AS
Insert into tb_tchmsg(tch_name,tch_sex,tch_photo,tch_race,tch_native,tch_face,tch_idcard,tch_edu,tch_worktime,tch_post,tch_course,tch_duty,tch_address,tch_famphone,tch_mobilephone,tch_remark)
values(@tch_name,@tch_sex,@tch_photo,@tch_race,@tch_native,@tch_face,@tch_idcard,@tch_edu,@tch_worktime,@tch_post,@tch_co
你的@tch_name没定义啊
@tch_name没定义
ALTER PROCEDURE [dbo].[Procedure_addtchmsg]
(
@tch_sex nchar(10),
===>
ALTER PROCEDURE [dbo].[Procedure_addtchmsg]
(
@tch_name varchar(50)
@tch_sex nchar(10),
有道理，没定义……
还好字段不是很多……
记得有一次一个表里有将近100个字段，插死人了，用了n个换行符……
还得注意注意不能有关键字……有下划线最好了……