If you would like to hire my services, you can now do so by visiting the following link:
Website Design Darlington
Article Statistics
Code Bank Statistics
Summary: An example of how to change the owner for all tables
Read More...
Posted on 18/03/2008 05:58:16
Summary: An example of how you can sort a varchar column which contains numbers.
Posted on 18/12/2007 06:32:57
Summary: An example of how to create a simple While Loop
Posted on 06/09/2007 07:56:07
Summary: An example of how you can dynamically group by certain fields.
Posted on 06/09/2007 02:31:03
Summary: An example of how you can use an optional parameter in a WHERE clause
Posted on 06/09/2007 02:29:38
Summary: An example of how you can get a list of data types that exist in your database.
Posted on 28/08/2007 04:02:25
Summary: An example of how data can be sorted randomly
Posted on 26/07/2007 00:39:16
Summary: An example of how a SQL statement in a Stored Procedure can be sorted via a parameter value.
Posted on 04/07/2007 14:15:04
Summary: Get a list of each table in your database along with information on each column it contains.
Posted on 19/06/2007 01:12:45
Summary: An example statement showing how to bring a database back online
Posted on 14/06/2007 05:39:25
Summary: An example statement showing how to take a database offline
Posted on 14/06/2007 05:38:35
Summary: An example trigger that shows how to get the values from an update statement and write them out to an audit table
Posted on 12/06/2007 08:20:22
Summary: An example of how an inserted ID can be returned using the OUTPUT method in SQL Server 2005
Posted on 12/06/2007 08:15:43