create trigger SYM_ON_I_FOR_BGTBL_CRP on DBA.bigtable for insert as begin declare @DataRow varchar(16384) declare @newpk0 bigint if(1 = 1) begin declare DataCursor dynamic scroll cursor for select case when inserted.id is null then '' else('"'+convert(varchar,inserted.id)+'"') end+',' +case when inserted.description is null then '' else '"'+replace(replace(inserted.description,'\\','\\\\'),'"','\\"')+'"' end+',' +case when inserted.column1 is null then '' else '"'+replace(replace(inserted.column1,'\\','\\\\'),'"','\\"')+'"' end+',' +case when inserted.column2 is null then '' else '"'+replace(replace(inserted.column2,'\\','\\\\'),'"','\\"')+'"' end+',' +case when inserted.column3 is null then '' else '"'+replace(replace(inserted.column3,'\\','\\\\'),'"','\\"')+'"' end+',' +case when inserted.column4 is null then '' else '"'+replace(replace(inserted.column4,'\\','\\\\'),'"','\\"')+'"' end+',' +case when inserted.column5 is null then '' else '"'+replace(replace(inserted.column5,'\\','\\\\'),'"','\\"')+'"' end+',' +case when inserted.column6 is null then '' else '"'+replace(replace(inserted.column6,'\\','\\\\'),'"','\\"')+'"' end+',' +case when inserted.column7 is null then '' else '"'+replace(replace(inserted.column7,'\\','\\\\'),'"','\\"')+'"' end+',' +case when inserted.column8 is null then '' else '"'+replace(replace(inserted.column8,'\\','\\\\'),'"','\\"')+'"' end+',' +case when inserted.column9 is null then '' else '"'+replace(replace(inserted.column9,'\\','\\\\'),'"','\\"')+'"' end+',' +case when inserted.column10 is null then '' else '"'+replace(replace(inserted.column10,'\\','\\\\'),'"','\\"')+'"' end+',' +case when inserted.column11 is null then '' else '"'+replace(replace(inserted.column11,'\\','\\\\'),'"','\\"')+'"' end+',' +case when inserted.column12 is null then '' else '"'+replace(replace(inserted.column12,'\\','\\\\'),'"','\\"')+'"' end+',' +case when inserted.column13 is null then '' else '"'+replace(replace(inserted.column13,'\\','\\\\'),'"','\\"')+'"' end+',' +case when inserted.column14 is null then '' else '"'+replace(replace(inserted.column14,'\\','\\\\'),'"','\\"')+'"' end+',' +case when inserted.column15 is null then '' else '"'+replace(replace(inserted.column15,'\\','\\\\'),'"','\\"')+'"' end+',' +case when inserted.column16 is null then '' else '"'+replace(replace(inserted.column16,'\\','\\\\'),'"','\\"')+'"' end+',' +case when inserted.column17 is null then '' else '"'+replace(replace(inserted.column17,'\\','\\\\'),'"','\\"')+'"' end+',' +case when inserted.column18 is null then '' else '"'+replace(replace(inserted.column18,'\\','\\\\'),'"','\\"')+'"' end+',' +case when inserted.column19 is null then '' else '"'+replace(replace(inserted.column19,'\\','\\\\'),'"','\\"')+'"' end+',' +case when inserted.column20 is null then '' else '"'+replace(replace(inserted.column20,'\\','\\\\'),'"','\\"')+'"' end+',' +case when inserted.column21 is null then '' else '"'+replace(replace(inserted.column21,'\\','\\\\'),'"','\\"')+'"' end+',' +case when inserted.column22 is null then '' else '"'+replace(replace(inserted.column22,'\\','\\\\'),'"','\\"')+'"' end+',' +case when inserted.column23 is null then '' else '"'+replace(replace(inserted.column23,'\\','\\\\'),'"','\\"')+'"' end+',' +case when inserted.column24 is null then '' else '"'+replace(replace(inserted.column24,'\\','\\\\'),'"','\\"')+'"' end+',' +case when inserted.column25 is null then '' else '"'+replace(replace(inserted.column25,'\\','\\\\'),'"','\\"')+'"' end+',' +case when inserted.column26 is null then '' else '"'+replace(replace(inserted.column26,'\\','\\\\'),'"','\\"')+'"' end+',' +case when inserted.column27 is null then '' else '"'+replace(replace(inserted.column27,'\\','\\\\'),'"','\\"')+'"' end+',' +case when inserted.column28 is null then '' else '"'+replace(replace(inserted.column28,'\\','\\\\'),'"','\\"')+'"' end+',' +case when inserted.column29 is null then '' else '"'+replace(replace(inserted.column29,'\\','\\\\'),'"','\\"')+'"' end+',' +case when inserted.column30 is null then '' else '"'+replace(replace(inserted.column30,'\\','\\\\'),'"','\\"')+'"' end+',' +case when inserted.column31 is null then '' else '"'+replace(replace(inserted.column31,'\\','\\\\'),'"','\\"')+'"' end+',' +case when inserted.column32 is null then '' else '"'+replace(replace(inserted.column32,'\\','\\\\'),'"','\\"')+'"' end+',' +case when inserted.column33 is null then '' else '"'+replace(replace(inserted.column33,'\\','\\\\'),'"','\\"')+'"' end+',' +case when inserted.column34 is null then '' else '"'+replace(replace(inserted.column34,'\\','\\\\'),'"','\\"')+'"' end+',' +case when inserted.column35 is null then '' else '"'+replace(replace(inserted.column35,'\\','\\\\'),'"','\\"')+'"' end+',' +case when inserted.column36 is null then '' else '"'+replace(replace(inserted.column36,'\\','\\\\'),'"','\\"')+'"' end+',' +case when inserted.column37 is null then '' else '"'+replace(replace(inserted.column37,'\\','\\\\'),'"','\\"')+'"' end+',' +case when inserted.column38 is null then '' else '"'+replace(replace(inserted.column38,'\\','\\\\'),'"','\\"')+'"' end+',' +case when inserted.column39 is null then '' else '"'+replace(replace(inserted.column39,'\\','\\\\'),'"','\\"')+'"' end+',' +case when inserted.column40 is null then '' else '"'+replace(replace(inserted.column40,'\\','\\\\'),'"','\\"')+'"' end+',' +case when inserted.column41 is null then '' else '"'+replace(replace(inserted.column41,'\\','\\\\'),'"','\\"')+'"' end+',' +case when inserted.column42 is null then '' else '"'+replace(replace(inserted.column42,'\\','\\\\'),'"','\\"')+'"' end+',' +case when inserted.column43 is null then '' else '"'+replace(replace(inserted.column43,'\\','\\\\'),'"','\\"')+'"' end+',' +case when inserted.column44 is null then '' else '"'+replace(replace(inserted.column44,'\\','\\\\'),'"','\\"')+'"' end+',' +case when inserted.column45 is null then '' else '"'+replace(replace(inserted.column45,'\\','\\\\'),'"','\\"')+'"' end+',' +case when inserted.column46 is null then '' else '"'+replace(replace(inserted.column46,'\\','\\\\'),'"','\\"')+'"' end+',' +case when inserted.column47 is null then '' else '"'+replace(replace(inserted.column47,'\\','\\\\'),'"','\\"')+'"' end+',' +case when inserted.column48 is null then '' else '"'+replace(replace(inserted.column48,'\\','\\\\'),'"','\\"')+'"' end+',' +case when inserted.column49 is null then '' else '"'+replace(replace(inserted.column49,'\\','\\\\'),'"','\\"')+'"' end+',' +case when inserted.column50 is null then '' else '"'+replace(replace(inserted.column50,'\\','\\\\'),'"','\\"')+'"' end+',' +case when inserted.column51 is null then '' else '"'+replace(replace(inserted.column51,'\\','\\\\'),'"','\\"')+'"' end+',' +case when inserted.column52 is null then '' else '"'+replace(replace(inserted.column52,'\\','\\\\'),'"','\\"')+'"' end+',' +case when inserted.column53 is null then '' else '"'+replace(replace(inserted.column53,'\\','\\\\'),'"','\\"')+'"' end+',' +case when inserted.column54 is null then '' else '"'+replace(replace(inserted.column54,'\\','\\\\'),'"','\\"')+'"' end+',' +case when inserted.column55 is null then '' else '"'+replace(replace(inserted.column55,'\\','\\\\'),'"','\\"')+'"' end+',' +case when inserted.column56 is null then '' else '"'+replace(replace(inserted.column56,'\\','\\\\'),'"','\\"')+'"' end+',' +case when inserted.column57 is null then '' else '"'+replace(replace(inserted.column57,'\\','\\\\'),'"','\\"')+'"' end+',' +case when inserted.column58 is null then '' else '"'+replace(replace(inserted.column58,'\\','\\\\'),'"','\\"')+'"' end+',' +case when inserted.column59 is null then '' else '"'+replace(replace(inserted.column59,'\\','\\\\'),'"','\\"')+'"' end+',' +case when inserted.column60 is null then '' else '"'+replace(replace(inserted.column60,'\\','\\\\'),'"','\\"')+'"' end+',' +case when inserted.column61 is null then '' else '"'+replace(replace(inserted.column61,'\\','\\\\'),'"','\\"')+'"' end+',' +case when inserted.column62 is null then '' else '"'+replace(replace(inserted.column62,'\\','\\\\'),'"','\\"')+'"' end+',' +case when inserted.column63 is null then '' else '"'+replace(replace(inserted.column63,'\\','\\\\'),'"','\\"')+'"' end+',' +case when inserted.column64 is null then '' else '"'+replace(replace(inserted.column64,'\\','\\\\'),'"','\\"')+'"' end+',' +case when inserted.column65 is null then '' else '"'+replace(replace(inserted.column65,'\\','\\\\'),'"','\\"')+'"' end+',' +case when inserted.column66 is null then '' else '"'+replace(replace(inserted.column66,'\\','\\\\'),'"','\\"')+'"' end+',' +case when inserted.column67 is null then '' else '"'+replace(replace(inserted.column67,'\\','\\\\'),'"','\\"')+'"' end+',' +case when inserted.column68 is null then '' else '"'+replace(replace(inserted.column68,'\\','\\\\'),'"','\\"')+'"' end+',' +case when inserted.column69 is null then '' else '"'+replace(replace(inserted.column69,'\\','\\\\'),'"','\\"')+'"' end+',' +case when inserted.column70 is null then '' else '"'+replace(replace(inserted.column70,'\\','\\\\'),'"','\\"')+'"' end+',' +case when inserted.column71 is null then '' else '"'+replace(replace(inserted.column71,'\\','\\\\'),'"','\\"')+'"' end+',' +case when inserted.column72 is null then '' else '"'+replace(replace(inserted.column72,'\\','\\\\'),'"','\\"')+'"' end+',' +case when inserted.column73 is null then '' else '"'+replace(replace(inserted.column73,'\\','\\\\'),'"','\\"')+'"' end+',' +case when inserted.column74 is null then '' else '"'+replace(replace(inserted.column74,'\\','\\\\'),'"','\\"')+'"' end+',' +case when inserted.column75 is null then '' else '"'+replace(replace(inserted.column75,'\\','\\\\'),'"','\\"')+'"' end+',' +case when inserted.column76 is null then '' else '"'+replace(replace(inserted.column76,'\\','\\\\'),'"','\\"')+'"' end+',' +case when inserted.column77 is null then '' else '"'+replace(replace(inserted.column77,'\\','\\\\'),'"','\\"')+'"' end+',' +case when inserted.column78 is null then '' else '"'+replace(replace(inserted.column78,'\\','\\\\'),'"','\\"')+'"' end+',' +case when inserted.column79 is null then '' else '"'+replace(replace(inserted.column79,'\\','\\\\'),'"','\\"')+'"' end+',' +case when inserted.column80 is null then '' else '"'+replace(replace(inserted.column80,'\\','\\\\'),'"','\\"')+'"' end+',' +case when inserted.column81 is null then '' else '"'+replace(replace(inserted.column81,'\\','\\\\'),'"','\\"')+'"' end+',' +case when inserted.column82 is null then '' else '"'+replace(replace(inserted.column82,'\\','\\\\'),'"','\\"')+'"' end+',' +case when inserted.column83 is null then '' else '"'+replace(replace(inserted.column83,'\\','\\\\'),'"','\\"')+'"' end+',' +case when inserted.column84 is null then '' else '"'+replace(replace(inserted.column84,'\\','\\\\'),'"','\\"')+'"' end+',' +case when inserted.column85 is null then '' else '"'+replace(replace(inserted.column85,'\\','\\\\'),'"','\\"')+'"' end+',' +case when inserted.column86 is null then '' else '"'+replace(replace(inserted.column86,'\\','\\\\'),'"','\\"')+'"' end+',' +case when inserted.column87 is null then '' else '"'+replace(replace(inserted.column87,'\\','\\\\'),'"','\\"')+'"' end+',' +case when inserted.column88 is null then '' else '"'+replace(replace(inserted.column88,'\\','\\\\'),'"','\\"')+'"' end+',' +case when inserted.column89 is null then '' else '"'+replace(replace(inserted.column89,'\\','\\\\'),'"','\\"')+'"' end+',' +case when inserted.column90 is null then '' else '"'+replace(replace(inserted.column90,'\\','\\\\'),'"','\\"')+'"' end+',' +case when inserted.column91 is null then '' else '"'+replace(replace(inserted.column91,'\\','\\\\'),'"','\\"')+'"' end+',' +case when inserted.column92 is null then '' else '"'+replace(replace(inserted.column92,'\\','\\\\'),'"','\\"')+'"' end+',' +case when inserted.column93 is null then '' else '"'+replace(replace(inserted.column93,'\\','\\\\'),'"','\\"')+'"' end+',' +case when inserted.column94 is null then '' else '"'+replace(replace(inserted.column94,'\\','\\\\'),'"','\\"')+'"' end+',' +case when inserted.column95 is null then '' else '"'+replace(replace(inserted.column95,'\\','\\\\'),'"','\\"')+'"' end+',' +case when inserted.column96 is null then '' else '"'+replace(replace(inserted.column96,'\\','\\\\'),'"','\\"')+'"' end+',' +case when inserted.column97 is null then '' else '"'+replace(replace(inserted.column97,'\\','\\\\'),'"','\\"')+'"' end+',' +case when inserted.column98 is null then '' else '"'+replace(replace(inserted.column98,'\\','\\\\'),'"','\\"')+'"' end+',' +case when inserted.column99 is null then '' else '"'+replace(replace(inserted.column99,'\\','\\\\'),'"','\\"')+'"' end+',' +case when inserted.column100 is null then '' else '"'+replace(replace(inserted.column100,'\\','\\\\'),'"','\\"')+'"' end+',' +case when inserted.column101 is null then '' else '"'+replace(replace(inserted.column101,'\\','\\\\'),'"','\\"')+'"' end+',' +case when inserted.column102 is null then '' else '"'+replace(replace(inserted.column102,'\\','\\\\'),'"','\\"')+'"' end+',' +case when inserted.column103 is null then '' else '"'+replace(replace(inserted.column103,'\\','\\\\'),'"','\\"')+'"' end+',' +case when inserted.column104 is null then '' else '"'+replace(replace(inserted.column104,'\\','\\\\'),'"','\\"')+'"' end+',' +case when inserted.column105 is null then '' else '"'+replace(replace(inserted.column105,'\\','\\\\'),'"','\\"')+'"' end+',' +case when inserted.column106 is null then '' else '"'+replace(replace(inserted.column106,'\\','\\\\'),'"','\\"')+'"' end+',' +case when inserted.column107 is null then '' else '"'+replace(replace(inserted.column107,'\\','\\\\'),'"','\\"')+'"' end+',' +case when inserted.column108 is null then '' else '"'+replace(replace(inserted.column108,'\\','\\\\'),'"','\\"')+'"' end+',' +case when inserted.column109 is null then '' else '"'+replace(replace(inserted.column109,'\\','\\\\'),'"','\\"')+'"' end+',' +case when inserted.column110 is null then '' else '"'+replace(replace(inserted.column110,'\\','\\\\'),'"','\\"')+'"' end+',' +case when inserted.column111 is null then '' else '"'+replace(replace(inserted.column111,'\\','\\\\'),'"','\\"')+'"' end+',' +case when inserted.column112 is null then '' else '"'+replace(replace(inserted.column112,'\\','\\\\'),'"','\\"')+'"' end+',' +case when inserted.column113 is null then '' else '"'+replace(replace(inserted.column113,'\\','\\\\'),'"','\\"')+'"' end+',' +case when inserted.column114 is null then '' else '"'+replace(replace(inserted.column114,'\\','\\\\'),'"','\\"')+'"' end+',' +case when inserted.column115 is null then '' else '"'+replace(replace(inserted.column115,'\\','\\\\'),'"','\\"')+'"' end+',' +case when inserted.column116 is null then '' else '"'+replace(replace(inserted.column116,'\\','\\\\'),'"','\\"')+'"' end+',' +case when inserted.column117 is null then '' else '"'+replace(replace(inserted.column117,'\\','\\\\'),'"','\\"')+'"' end+',' +case when inserted.column118 is null then '' else '"'+replace(replace(inserted.column118,'\\','\\\\'),'"','\\"')+'"' end+',' +case when inserted.column119 is null then '' else '"'+replace(replace(inserted.column119,'\\','\\\\'),'"','\\"')+'"' end+',' +case when inserted.column120 is null then '' else '"'+replace(replace(inserted.column120,'\\','\\\\'),'"','\\"')+'"' end+',' +case when inserted.column121 is null then '' else '"'+replace(replace(inserted.column121,'\\','\\\\'),'"','\\"')+'"' end+',' +case when inserted.column122 is null then '' else '"'+replace(replace(inserted.column122,'\\','\\\\'),'"','\\"')+'"' end+',' +case when inserted.column123 is null then '' else '"'+replace(replace(inserted.column123,'\\','\\\\'),'"','\\"')+'"' end+',' +case when inserted.column124 is null then '' else '"'+replace(replace(inserted.column124,'\\','\\\\'),'"','\\"')+'"' end+',' +case when inserted.column125 is null then '' else '"'+replace(replace(inserted.column125,'\\','\\\\'),'"','\\"')+'"' end+',' +case when inserted.column126 is null then '' else '"'+replace(replace(inserted.column126,'\\','\\\\'),'"','\\"')+'"' end+',' +case when inserted.column127 is null then '' else '"'+replace(replace(inserted.column127,'\\','\\\\'),'"','\\"')+'"' end+',' +case when inserted.column128 is null then '' else '"'+replace(replace(inserted.column128,'\\','\\\\'),'"','\\"')+'"' end+',' +case when inserted.column129 is null then '' else '"'+replace(replace(inserted.column129,'\\','\\\\'),'"','\\"')+'"' end+',' +case when inserted.column130 is null then '' else '"'+replace(replace(inserted.column130,'\\','\\\\'),'"','\\"')+'"' end+',' +case when inserted.column131 is null then '' else '"'+replace(replace(inserted.column131,'\\','\\\\'),'"','\\"')+'"' end+',' +case when inserted.column132 is null then '' else '"'+replace(replace(inserted.column132,'\\','\\\\'),'"','\\"')+'"' end+',' +case when inserted.column133 is null then '' else '"'+replace(replace(inserted.column133,'\\','\\\\'),'"','\\"')+'"' end+',' +case when inserted.column134 is null then '' else '"'+replace(replace(inserted.column134,'\\','\\\\'),'"','\\"')+'"' end+',' +case when inserted.column135 is null then '' else '"'+replace(replace(inserted.column135,'\\','\\\\'),'"','\\"')+'"' end+',' +case when inserted.column136 is null then '' else '"'+replace(replace(inserted.column136,'\\','\\\\'),'"','\\"')+'"' end+',' +case when inserted.column137 is null then '' else '"'+replace(replace(inserted.column137,'\\','\\\\'),'"','\\"')+'"' end+',' +case when inserted.column138 is null then '' else '"'+replace(replace(inserted.column138,'\\','\\\\'),'"','\\"')+'"' end+',' +case when inserted.column139 is null then '' else '"'+replace(replace(inserted.column139,'\\','\\\\'),'"','\\"')+'"' end+',' +case when inserted.column140 is null then '' else '"'+replace(replace(inserted.column140,'\\','\\\\'),'"','\\"')+'"' end+',' +case when inserted.column141 is null then '' else '"'+replace(replace(inserted.column141,'\\','\\\\'),'"','\\"')+'"' end+',' +case when inserted.column142 is null then '' else '"'+replace(replace(inserted.column142,'\\','\\\\'),'"','\\"')+'"' end+',' +case when inserted.column143 is null then '' else '"'+replace(replace(inserted.column143,'\\','\\\\'),'"','\\"')+'"' end+',' +case when inserted.column144 is null then '' else '"'+replace(replace(inserted.column144,'\\','\\\\'),'"','\\"')+'"' end+',' +case when inserted.column145 is null then '' else '"'+replace(replace(inserted.column145,'\\','\\\\'),'"','\\"')+'"' end+',' +case when inserted.column146 is null then '' else '"'+replace(replace(inserted.column146,'\\','\\\\'),'"','\\"')+'"' end+',' +case when inserted.column147 is null then '' else '"'+replace(replace(inserted.column147,'\\','\\\\'),'"','\\"')+'"' end+',' +case when inserted.column148 is null then '' else '"'+replace(replace(inserted.column148,'\\','\\\\'),'"','\\"')+'"' end+',' +case when inserted.column149 is null then '' else '"'+replace(replace(inserted.column149,'\\','\\\\'),'"','\\"')+'"' end+',' +case when inserted.column150 is null then '' else '"'+replace(replace(inserted.column150,'\\','\\\\'),'"','\\"')+'"' end+',' +case when inserted.column151 is null then '' else '"'+replace(replace(inserted.column151,'\\','\\\\'),'"','\\"')+'"' end+',' +case when inserted.column152 is null then '' else '"'+replace(replace(inserted.column152,'\\','\\\\'),'"','\\"')+'"' end+',' +case when inserted.column153 is null then '' else '"'+replace(replace(inserted.column153,'\\','\\\\'),'"','\\"')+'"' end+',' +case when inserted.column154 is null then '' else '"'+replace(replace(inserted.column154,'\\','\\\\'),'"','\\"')+'"' end+',' +case when inserted.column155 is null then '' else '"'+replace(replace(inserted.column155,'\\','\\\\'),'"','\\"')+'"' end+',' +case when inserted.column156 is null then '' else '"'+replace(replace(inserted.column156,'\\','\\\\'),'"','\\"')+'"' end+',' +case when inserted.column157 is null then '' else '"'+replace(replace(inserted.column157,'\\','\\\\'),'"','\\"')+'"' end+',' +case when inserted.column158 is null then '' else '"'+replace(replace(inserted.column158,'\\','\\\\'),'"','\\"')+'"' end+',' +case when inserted.column159 is null then '' else '"'+replace(replace(inserted.column159,'\\','\\\\'),'"','\\"')+'"' end+',' +case when inserted.column160 is null then '' else '"'+replace(replace(inserted.column160,'\\','\\\\'),'"','\\"')+'"' end+',' +case when inserted.column161 is null then '' else '"'+replace(replace(inserted.column161,'\\','\\\\'),'"','\\"')+'"' end+',' +case when inserted.column162 is null then '' else '"'+replace(replace(inserted.column162,'\\','\\\\'),'"','\\"')+'"' end+',' +case when inserted.column163 is null then '' else '"'+replace(replace(inserted.column163,'\\','\\\\'),'"','\\"')+'"' end+',' +case when inserted.column164 is null then '' else '"'+replace(replace(inserted.column164,'\\','\\\\'),'"','\\"')+'"' end+',' +case when inserted.column165 is null then '' else '"'+replace(replace(inserted.column165,'\\','\\\\'),'"','\\"')+'"' end+',' +case when inserted.column166 is null then '' else '"'+replace(replace(inserted.column166,'\\','\\\\'),'"','\\"')+'"' end+',' +case when inserted.column167 is null then '' else '"'+replace(replace(inserted.column167,'\\','\\\\'),'"','\\"')+'"' end+',' +case when inserted.column168 is null then '' else '"'+replace(replace(inserted.column168,'\\','\\\\'),'"','\\"')+'"' end+',' +case when inserted.column169 is null then '' else '"'+replace(replace(inserted.column169,'\\','\\\\'),'"','\\"')+'"' end+',' +case when inserted.column170 is null then '' else '"'+replace(replace(inserted.column170,'\\','\\\\'),'"','\\"')+'"' end+',' +case when inserted.column171 is null then '' else '"'+replace(replace(inserted.column171,'\\','\\\\'),'"','\\"')+'"' end+',' +case when inserted.column172 is null then '' else '"'+replace(replace(inserted.column172,'\\','\\\\'),'"','\\"')+'"' end+',' +case when inserted.column173 is null then '' else '"'+replace(replace(inserted.column173,'\\','\\\\'),'"','\\"')+'"' end+',' +case when inserted.column174 is null then '' else '"'+replace(replace(inserted.column174,'\\','\\\\'),'"','\\"')+'"' end+',' +case when inserted.column175 is null then '' else '"'+replace(replace(inserted.column175,'\\','\\\\'),'"','\\"')+'"' end+',' +case when inserted.column176 is null then '' else '"'+replace(replace(inserted.column176,'\\','\\\\'),'"','\\"')+'"' end+',' +case when inserted.column177 is null then '' else '"'+replace(replace(inserted.column177,'\\','\\\\'),'"','\\"')+'"' end+',' +case when inserted.column178 is null then '' else '"'+replace(replace(inserted.column178,'\\','\\\\'),'"','\\"')+'"' end+',' +case when inserted.column179 is null then '' else '"'+replace(replace(inserted.column179,'\\','\\\\'),'"','\\"')+'"' end+',' +case when inserted.column180 is null then '' else '"'+replace(replace(inserted.column180,'\\','\\\\'),'"','\\"')+'"' end+',' +case when inserted.column181 is null then '' else '"'+replace(replace(inserted.column181,'\\','\\\\'),'"','\\"')+'"' end+',' +case when inserted.column182 is null then '' else '"'+replace(replace(inserted.column182,'\\','\\\\'),'"','\\"')+'"' end+',' +case when inserted.column183 is null then '' else '"'+replace(replace(inserted.column183,'\\','\\\\'),'"','\\"')+'"' end+',' +case when inserted.column184 is null then '' else '"'+replace(replace(inserted.column184,'\\','\\\\'),'"','\\"')+'"' end+',' +case when inserted.column185 is null then '' else '"'+replace(replace(inserted.column185,'\\','\\\\'),'"','\\"')+'"' end+',' +case when inserted.column186 is null then '' else '"'+replace(replace(inserted.column186,'\\','\\\\'),'"','\\"')+'"' end+',' +case when inserted.column187 is null then '' else '"'+replace(replace(inserted.column187,'\\','\\\\'),'"','\\"')+'"' end+',' +case when inserted.column188 is null then '' else '"'+replace(replace(inserted.column188,'\\','\\\\'),'"','\\"')+'"' end+',' +case when inserted.column189 is null then '' else '"'+replace(replace(inserted.column189,'\\','\\\\'),'"','\\"')+'"' end+',' +case when inserted.column190 is null then '' else('"'+convert(varchar,inserted.column190)+'"') end+',' +case when inserted.column191 is null then '' else('"'+convert(varchar,inserted.column191)+'"') end+',' +case when inserted.column192 is null then '' else('"'+convert(varchar,inserted.column192)+'"') end+',' +case when inserted.column193 is null then '' else('"'+convert(varchar,inserted.column193)+'"') end+',' +case when inserted.column194 is null then '' else('"'+convert(varchar,inserted.column194)+'"') end+',' +case when inserted.column195 is null then '' else('"'+convert(varchar,inserted.column195)+'"') end+',' +case when inserted.column196 is null then '' else('"'+convert(varchar,inserted.column196)+'"') end+',' +case when inserted.column197 is null then '' else('"'+convert(varchar,inserted.column197)+'"') end+',' +case when inserted.column198 is null then '' else('"'+convert(varchar,inserted.column198)+'"') end+',' +case when inserted.column199 is null then '' else('"'+convert(varchar,inserted.column199)+'"') end+',' +case when inserted.column200 is null then '' else('"'+convert(varchar,inserted.column200)+'"') end+',' +case when inserted.column201 is null then '' else('"'+convert(varchar,inserted.column201)+'"') end+',' +case when inserted.column202 is null then '' else('"'+convert(varchar,inserted.column202)+'"') end+',' +case when inserted.column203 is null then '' else('"'+convert(varchar,inserted.column203)+'"') end+',' +case when inserted.column204 is null then '' else('"'+convert(varchar,inserted.column204)+'"') end+',' +case when inserted.column205 is null then '' else('"'+convert(varchar,inserted.column205)+'"') end+',' +case when inserted.column206 is null then '' else('"'+convert(varchar,inserted.column206)+'"') end+',' +case when inserted.column207 is null then '' else('"'+convert(varchar,inserted.column207)+'"') end+',' +case when inserted.column208 is null then '' else('"'+convert(varchar,inserted.column208)+'"') end+',' +case when inserted.column209 is null then '' else('"'+convert(varchar,inserted.column209)+'"') end+',' +case when inserted.column210 is null then '' else('"'+convert(varchar,inserted.column210)+'"') end+',' +case when inserted.column211 is null then '' else('"'+convert(varchar,inserted.column211)+'"') end+',' +case when inserted.column212 is null then '' else('"'+convert(varchar,inserted.column212)+'"') end+',' +case when inserted.column213 is null then '' else('"'+convert(varchar,inserted.column213)+'"') end+',' +case when inserted.column214 is null then '' else('"'+convert(varchar,inserted.column214)+'"') end+',' +case when inserted.column215 is null then '' else('"'+convert(varchar,inserted.column215)+'"') end+',' +case when inserted.column216 is null then '' else('"'+convert(varchar,inserted.column216)+'"') end+',' +case when inserted.column217 is null then '' else('"'+convert(varchar,inserted.column217)+'"') end+',' +case when inserted.column218 is null then '' else('"'+convert(varchar,inserted.column218)+'"') end+',' +case when inserted.column219 is null then '' else('"'+convert(varchar,inserted.column219)+'"') end+',' +case when inserted.column220 is null then '' else('"'+convert(varchar,inserted.column220)+'"') end+',' +case when inserted.column221 is null then '' else('"'+convert(varchar,inserted.column221)+'"') end+',' +case when inserted.column222 is null then '' else('"'+convert(varchar,inserted.column222)+'"') end+',' +case when inserted.column223 is null then '' else('"'+convert(varchar,inserted.column223)+'"') end+',' +case when inserted.column224 is null then '' else('"'+convert(varchar,inserted.column224)+'"') end+',' +case when inserted.column225 is null then '' else('"'+convert(varchar,inserted.column225)+'"') end+',' +case when inserted.column226 is null then '' else('"'+convert(varchar,inserted.column226)+'"') end+',' +case when inserted.column227 is null then '' else('"'+convert(varchar,inserted.column227)+'"') end+',' +case when inserted.column228 is null then '' else('"'+convert(varchar,inserted.column228)+'"') end+',' +case when inserted.column229 is null then '' else('"'+convert(varchar,inserted.column229)+'"') end+',' +case when inserted.column230 is null then '' else('"'+convert(varchar,inserted.column230)+'"') end+',' +case when inserted.column231 is null then '' else('"'+convert(varchar,inserted.column231)+'"') end+',' +case when inserted.column232 is null then '' else('"'+convert(varchar,inserted.column232)+'"') end+',' +case when inserted.column233 is null then '' else('"'+convert(varchar,inserted.column233)+'"') end+',' +case when inserted.column234 is null then '' else('"'+convert(varchar,inserted.column234)+'"') end+',' +case when inserted.column235 is null then '' else('"'+convert(varchar,inserted.column235)+'"') end+',' +case when inserted.column236 is null then '' else('"'+convert(varchar,inserted.column236)+'"') end+',' +case when inserted.column237 is null then '' else('"'+convert(varchar,inserted.column237)+'"') end+',' +case when inserted.column238 is null then '' else('"'+convert(varchar,inserted.column238)+'"') end+',' +case when inserted.column239 is null then '' else('"'+convert(varchar,inserted.column239)+'"') end+',' +case when inserted.column240 is null then '' else('"'+convert(varchar,inserted.column240)+'"') end+',' +case when inserted.column241 is null then '' else('"'+convert(varchar,inserted.column241)+'"') end+',' +case when inserted.column242 is null then '' else('"'+convert(varchar,inserted.column242)+'"') end+',' +case when inserted.column243 is null then '' else('"'+convert(varchar,inserted.column243)+'"') end+',' +case when inserted.column244 is null then '' else('"'+convert(varchar,inserted.column244)+'"') end+',' +case when inserted.column245 is null then '' else('"'+convert(varchar,inserted.column245)+'"') end+',' +case when inserted.column246 is null then '' else('"'+convert(varchar,inserted.column246)+'"') end+',' +case when inserted.column247 is null then '' else('"'+convert(varchar,inserted.column247)+'"') end+',' +case when inserted.column248 is null then '' else('"'+convert(varchar,inserted.column248)+'"') end+',' +case when inserted.column249 is null then '' else('"'+convert(varchar,inserted.column249)+'"') end,inserted.id from inserted where 1 = 1 open DataCursor fetch next DataCursor into @DataRow,@newpk0 while @@FETCH_STATUS = 0 begin insert into demo.DBA.sym_data( table_name,event_type,trigger_hist_id,row_data,channel_id,transaction_id,source_node_id,external_data,create_time ) values( 'bigtable','I',24,@DataRow,'bigtable',demo.DBA.sym_txid(0),demo.DBA.sym_node_disabled(0),null,getdate() ) fetch next DataCursor into @DataRow,@newpk0 end close DataCursor deallocate cursor DataCursor end end