DECLARE @a int
exec proc_cj_insert_gatherbuilding 'insert','T_WRMS_GatherBuildingPrimal','26231','ZZSQOV0JIUHUOSHICHANGXI1','H''''B703(46851)',@a output
exec proc_cj_insert_gatherbuilding 'insert','T_WRMS_GatherBuildingPrimal','26231','ZZSQOV0JIUHUOSHICHANGXI1','H''''B703(46851)',@a output
ALTER PROCEDURE [dbo].[proc_cj_Insert_GatherBuilding]
-- Add the parameters for the stored procedure here
@opeType varchar(10),
@tableName varchar(50),
@FCINumber varchar(20),
@FLACNumber varchar(20),
@FBuildingName varchar(30),
@ReturnValue int output
AS
BEGIN
Declare @sqltext varchar(5000)
-- SET NOCOUNT ON added to prevent extra result sets from
-- interfering with SELECT statements.
SET NOCOUNT ON;
-- Insert statements for procedure here
IF(@opeType='insert')
BEGIN
SET @sqltext='INSERT INTO ' + @tableName + '
(
ID,
FCINumber,
FLACNumber,
FBuildingName
)
VALUES
(
replace(newid(),''-'',''''),
''' + @FCINumber +''',''' +
@FLACNumber +''',''' +
replace(@FBuildingName,'''','"') +'''
)'
print @FCINumber;
print @FLACNumber;
print @FBuildingName;
END
--print(@sqltext)
EXEC(@sqltext);
SET @ReturnValue = @@RowCount;
END