Page 3 - Execute SQL on Multiple Tables/Columns - New Feature in SQL Server 2000

SQL SERVER

Execute SQL on Multiple Tables/Columns - New Feature in SQL Server 2000

In this latest article, Raghavendra introduces us to a feature available to us in SQL Server, allowing us to execute SQL statements on multiple tables and columns.

Author Info:

By: Raghavendra Narayana

Poor Best

Rating:

/ 48

September 25, 2003

TABLE OF CONTENTS:

· Execute SQL on Multiple Tables/Columns - New Feature in SQL Server 2000
· Script
· Parameters
· Examples
· Expansion
· Conclusion

See Also:

print this article

SEARCH DEVARTICLES

TOOLS YOU CAN USE

advertisement

Execute SQL on Multiple Tables/Columns - New Feature in SQL Server 2000 - Parameters
(Page 3 of 6 )

Parameter Name	Description
@TABLENAME	Table Name filter. Delimit with comma for multiple table names.
@COLUMNNAME	Column Name filter. Delimit with comma for multiple column names.
@SQL	A SQL Statement or set of SQL statements
@INCLUDE_NTI	Whether to include NText, Text, Image data type columns or not.

Returns

Returns 0 on successful execution
Returns –1 on unsuccessful execution

Next: Examples >>

blog comments powered by Disqus

SQL SERVER ARTICLES

- Executing SQL Server Stored Procedure from P...
- How to Search for Date and Time Values Using...
- Replication: SQL Server 2000 - Part 2
- Replication: SQL Server 2000 - Part 1
- SQL Sever: Storing Code in Binary or Text Fi...
- Execute SQL on Multiple Tables/Columns - New...
- How to Connect to a SQL Server from Visual F...
- SQL Server Hardware Tuning and Performance M...
- Primary Key on Multiple Tables – New RDBMS C...
- Migrating from Sybase to SQL Server
- What's Best for DBAs? GUI or T-SQL Comma...
- How to Perform a SQL Server Performance Audit
- An Introduction To The Bulk Copy Utility
- SQL Server Stored Procedures 101
- Building Your First SQL Server 2000 Database

Find More SQL Server Tutorials

Dev Articles Forums

Weekly Newsletter
Developer Updates
Free Website Content

Privacy Policy
Support

© 2003-2012 by Developer Shed. All rights reserved. DS Cluster 8 - Follow our Sitemap

Popular Web Development Topics

All Web Development Tutorials

.Net CASE tools to speed up your development. FREE trial & contest entry w/ activation.