In part 2 of a series, On VB columnist Joe Kunk provides a Visual Basic program to generate a SQL script that clears all the data from a SQL Server database.

I need a command to delete all rows in a table whose columns are NULL (or 0 for int columns). I'm hoping there's a quick command to do this -- I don't want to have to check each column ...

I have need to re-create a database once in a while, only complete without data. Script generation usually gets me dependency errors, is there any better way to do this?Thanks!