Execute SQL on Multiple Tables/Columns - New Feature in SQL Server 2000 - Expansion
(Page 5 of 6 )
SP_execSQLonDB can be expanded like so:
- Include Data type filter by introducing one more Input parameter, include it in the Cursor declaration part using SYSCOLUMNS table XTYPE COLUMN.
- Change the SP to perform SQL execution only on finding of Table names, avoid execution on every column.
Usage
Due to Technical standards and ethics you may not choose this option to Edit/Add data in this fashion on a “Live” version, but you can always use this for statistical/analytical purposes. In Development versions you can try many new things/approaches, even adding/editing/deleting can be attempted.
Next: Conclusion >>
More SQL Server Articles
More By Raghavendra Narayana
/ 43 
