Some times we need to know all database columns names and data types and length for any activity, without this script you must check each database table for its columns names, data types and length but with this simple script you will able to get all these data with the minimum effort :)

SELECT SysObjects.[Name] as TableName,
SysColumns.[Name] as ColumnName,
SysTypes.[Name] AS [Name],
SysColumns.[Length] AS [Length]
FROM
SysObjects INNER JOIN SysColumns
ON SysObjects.[Id] = SysColumns.[Id]
INNER JOIN SysTypes
ON SysTypes.[xtype] = SysColumns.[xtype]
WHERE SysObjects.[type] = 'U'
AND SysTypes.[Name] <> 'sysname'
ORDER BY SysObjects.[Name]

This function was written according to my needs , please modify to suit your requirements.

Input : VARCHAR(8000)

Output : VARCHAR(8000) [Formatted Phone Number]

Ex :

'8601234567' returns '(860)123-4567'

Tested on : SQL 2000,2005,2008

In our table we have a list of runners, the time the course was completed in and the runner's age. Our task is to retrieve the fastest X runners in each age range.

CREATE TABLE #Runners
(
Runner integer NOT NULL,
Time integer NOT NULL,
Age integer NOT NULL
)
INSERT INTO #Runners
SELECT 1 , 10 , 20 UNION ALL
SELECT 2 , 15 , 20 UNION ALL
SELECT 3 , 11 , 20 UNION ALL
SELECT 4 , 12 , 30 UNION ALL
SELECT 5 , 18 , 30 UNION ALL
SELECT 6 , 9 , 40 UNION ALL
SELECT 7 , 16 , 40 UNION ALL
SELECT 8 , 13 , 30

There are 3 reasons for doing it this way:

• Distro updates sometimes work, sometimes fail and at other times they “sort of” work leaving you with a system that is not as snappy as it should be or has some other trouble which was not there before the upgrade.

This doesn’t mean you’ll experience it that way if you’ve used Windows for a long time: at a certain your habits begin to feel like conventional wisdom, and any system that doesn’t match your current habits will seem difficult.