/****** Object: StoredProcedure [dbo].[SP_AddXSLACTIVE] Script Date: 03/08/2012 16:29:39 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- =============================================
-- Author: <Author,,Name>
-- Create date: <Create Date,,>
-- Description: <Description,,>
-- =============================================
CREATE PROCEDURE [dbo].[SP_AddXSLACTIVE]
@allpass varchar(10),
@anti varchar(10),
@deploydevice_id varchar(10),
@doorallpass varchar(10),
@doorholidayoff varchar(10),
@doorserial varchar(10),
@keylock varchar(10),
@mdcard varchar(10),
@pin varchar(10),
@pkey varchar(20),
@pkeyname varchar(100),
@xsl_id varchar(10)
AS
BEGIN
-- SET NOCOUNT ON added to prevent extra result sets from
-- interfering with SELECT statements.
SET NOCOUNT ON;
-- Insert statements for procedure here
--SELECT <@Param1, sysname, @p1>, <@Param2, sysname, @p2>
declare @sql varchar(8000)
select @sql = 'insert into XSLACTIVE (ALLPASS,Anti,DeployDevice_Id,DoorALLPASS,DoorHolidayOff,DoorSerial,KEYLOCK,MDCARD,PIN,PKey,PKeyName,XSL_ID) values('
+''''+@allpass+''','''+@anti+''','''+@deploydevice_id+''','''+@doorallpass+''','''+@doorholidayoff+''','''+@doorserial+''','''+@keylock+''','''+@mdcard+''','''+@pin+''','''+@pkey+''','''+@pkeyname+''','''+@xsl_id+''')'
--exec @sql 會造成 【不是有效的識別碼。】的錯誤
exec(@sql) --改成這個就是正確了
END