To get the column names of a table in MSSQL
SELECT * FROM INFORMATION_SCHEMA.Columns WHERE TABLE_NAME = ‘TableName’
This is basically the MSSQL equivalent for The MySQL Command DESCRIBE TableName which displays the table details
For getting only the column names you can use following one
SELECT Column_Name + ‘,’ FROM INFORMATION_SCHEMA.Columns WHERE TABLE_NAME = ‘TreeDataTable’
Google has once again stepped up and is now offering another free service to make our lives more efficient. The search giant announced today that they will now be offering DNS servers for the public at no cost. This comes in addition to the multitude of services already offered by Google, such as Gmail, Google Voice and Google Sites.
You can set up your computer to use Google’s DNS servers by following their instructions here: Using Google Public DNS
While trying the MS Office 2010 beta version, I came across the strange problem. Send/ receive was not working after it imported the settings from Outlook 03.
It was very difficult to trace why it was not working, as it carries on processing and process never stops.
Then I started Googling for the same and got a hint from following link-
http://social.technet.microsoft.com/Forums/en-US/outlook/thread/d034e214-2df1-45f7-a8da-ef78647653fb
My problem got resolved when I killed OUTLOOK.EXE from task manager and exited those send a smile/frown from the tray.
And yuppie !!! problem was resolved.