CREATE TRIGGER tr_cA ON A FOR INSERT AS SET NOCOUNT ON; BEGIN DECLARE @Sql NVARCHAR(max) SET @Sql='' SELECT 'ALTER TABLE B ADD '+FName+' char(4);UPDATE B SET '+FName+'='''+FID+''';' FROM INSERTED EXEC(@Sql) END
少敲打了赋值 @Sql= CREATE TRIGGER tr_cA ON A FOR INSERT AS SET NOCOUNT ON; BEGIN DECLARE @Sql NVARCHAR(max) SET @Sql='' SELECT @Sql=@Sql+'ALTER TABLE B ADD '+FName+' char(4);UPDATE B SET '+FName+'='''+FID+''';' FROM INSERTED EXEC(@Sql) END
CREATE TRIGGER tr_cA ON A
FOR INSERT
AS
SET NOCOUNT ON;
BEGIN
DECLARE @Sql NVARCHAR(max)
SET @Sql=''
SELECT 'ALTER TABLE B ADD '+FName+' char(4);UPDATE B SET '+FName+'='''+FID+''';' FROM INSERTED
EXEC(@Sql)
END
要显示不如前台直接取A表,行列转换用程序处理更方便。
CREATE TRIGGER tr_cA ON A
FOR INSERT
AS
SET NOCOUNT ON;
BEGIN
DECLARE @Sql NVARCHAR(max)
SET @Sql=''
SELECT @Sql=@Sql+'ALTER TABLE B ADD '+FName+' char(4);UPDATE B SET '+FName+'='''+FID+''';' FROM INSERTED
EXEC(@Sql)
END