Hi,
Is there any RDBMS concept ,If i do any DML operations in any of table i need to know how many rows are inserted/updated/deleted in particular table. I dont want write any trigger to get those information.
because the table count nearly 142.
Moving to Transact-SQL from SSIS.|||Nope. Triggers are the only current method in 2005 and earlier.
You could pretty easily write a code generator using the system tables (sys.tables, sys.columns) once you determine how to do one of them, then just follow a common pattern.
|||Yes..My last question. i have done work around solution.
just loading data into table using bulk insert concept. after that used substring function to fixed the problem.
Thanks - Phil Brammer.
