Tip Discussion: Automatic Generation of Single Table SQL Statements

If you have any questions or comments about this tip please post them here.

This forum post relates to this article

You can create .SQL files to create the database objects - but you need VB.NET or SQL Server 2000.

In VB.NET, to create the .SQL files, open the Server Explorer and create a data connection. After it's created, right-click the object (tables, sp, etc.) that you'd like to make a script file for and click generate SQL script. You can then run the .SQL file with a util like osql which comes with MSDE.

You can also create the database objects programmatically in VB.NET. This makes the schema of your database project safer from people just opening your .SQL files and looking at them, since they are just text files. Take a look at this article:

URL

SQL2000 permits an XML file to be passed as the argument of a stored procedure. Could you add to this article showing an example using XML instead of individual fields?