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.

SQL Server 2005 or later script to generate TRUNCATE statements for all tables. Anyone that has tried this on anything but the most simplistic database has found, as I did, that this won't work.

Using MS SQL Server, is there a way to query all of the tables in a database for a specific column name?Thanks,Pete ...

Joey on SQL Server Hands-On with Copilot for Azure SQL Database I've been playing around with the new Microsoft service, currently in preview and it's time to show off what it can do. By Joey D ...