SQL

Search any/all SQL Server tables for a string...

Search any/all SQL Server tables for a string… Grabbed this off the Internet, tried it, and it works very well. Also well documented.

 

SQL 2012 Easy Transaction Example

Seekers, Transactions are one of those things you learn about in databases last. You never think about using or needing them until a more advanced scenario exists. But we’ve all […]

With 260+ tables that I created in VB.NET code via SMO to delete, I did it by first creating a DROP TABLE statement using:

You create a tidy DROP […]