Ok, now I understand. Thanks

Thank you again for your advice.

The only thing I do not understand is "FOR XML PATH('')". What is use for?

It works great! Thank you.

Sorry, it is in SSMS. (SQL server management studio)

I want to print out line number with content in a store procedure.

Thank you for help. I used code below. It works fine.

select column_name

into NewTable

FROM INFORMATION_SCHEMA.COLUMNS

WHERE TABLE_NAME = 'myTable'

Thank you for help. I am learning and will try...

case #TUploadTo.WCFComplete

when 1 then 'WC'

else 'WI'

end as result

I got multi-part idendifier "#TUploadTo.WCFComplete" could not be bound error

I got it.

http://www.microsoft.com/sqlserver/2008/en/us/editions.aspx

I need to drop and restore a database in about 20 user's pc once a week but I do not want to open Studio Management in each pc.

I posted some questions but can not find out them.