Hire my services

If you would like to hire my services, you can now do so by visiting the following link:

Website Design Darlington

Article Statistics

ArticlesLatest Entry
2121-May-2008

Code Bank Statistics

CategoryTipsLatest Entry
Applications420-Feb-2008
Cache118-Apr-2007
Controls926-Jul-2007
CSS107-Sep-2007
Database428-Aug-2007
Dates128-Aug-2007
Email105-Mar-2007
Files123-Apr-2007
HTML101-Mar-2007
Images226-Mar-2007
Pages115-Oct-2007
Sessions122-Nov-2007
SQL Server1518-Mar-2008
Strings309-May-2007
Skip Navigation LinksHome > Code Bank (SQL Server)

Code Bank Categories: View RSS Feed for Code Bank

Change owner for all tables

Summary: An example of how to change the owner for all tables

Read More...

Sort a varchar column with embedded numbers

Summary: An example of how you can sort a varchar column which contains numbers.

Read More...

While Loops

Summary: An example of how to create a simple While Loop

Read More...

Dynamic Group By

Summary: An example of how you can dynamically group by certain fields.

Read More...

Optional Parameters

Summary: An example of how you can use an optional parameter in a WHERE clause

Read More...

Retrieve a list of all data types in a database

Summary: An example of how you can get a list of data types that exist in your database.

Read More...

Random Sort Order

Summary: An example of how data can be sorted randomly

Read More...

Sort a stored procedure via a parameter

Summary: An example of how a SQL statement in a Stored Procedure can be sorted via a parameter value.

Read More...

List your tables and columns

Summary: Get a list of each table in your database along with information on each column it contains.

Read More...

Bring a database back online

Summary: An example statement showing how to bring a database back online

Read More...

Take a database offline

Summary: An example statement showing how to take a database offline

Read More...

Using the INSERTED table in SQL Server 2000

Summary: An example trigger that shows how to get the values from an update statement and write them out to an audit table

Read More...

SQL Server 2005 Output Method

Summary: An example of how an inserted ID can be returned using the OUTPUT method in SQL Server 2005

Read More...