T-SQL

SQL Script to list all the columns of a table with the Schema Information

If you are looking for a SQL Script which will display a list of all columns in a table and also the Schema Information, you can use the following Script.

Working with the DataTime datatype in SQL Server can be very frustrating at times Especially, when you use them in your where clause. For example If you want to list all records within a certain date range, you might end up retrieving incorrect rows.