Sql server select column names in a table

Top sites by search query "sql server select column names in a table"

  http://sqlandme.com/2013/03/04/sql-server-how-to-rename-tablecolumn-in-sql-server/
Related Categories: Management Studio, SQLServer, SQLServer 2005, SQLServer 2008, SQLServer 2008 R2, SQLServer 2012, Working With Data Comments (1) Trackbacks (0) Leave a comment Trackback Suyog Swami March 26, 2015 at 7:44 am Reply Hello, Is there a query to rename a column in SQL Server 2008 rather than using a stored procedure ? I have been using the following alter queries but those does not work for me. When renaming a column you need to specify table name.column name optionally you can also prefix schema name @newname New name for the specified object @objtype Type of the object

  http://blog.sqlauthority.com/2008/08/26/sql-server-how-to-rename-a-column-name-or-table-name/
Imagine we have the same case as explained above( 20 tables with same columns ), so we want to change the name of each tables to the same name which is in first row of Third column of each table. just post here because:- 1) it will be have more visibility and more quick chance to reply 2) I have configured this blog in my office mail so I will get it in my office mail box automatically whenever there is new item added

  http://blog.sqlauthority.com/2008/06/04/sql-server-create-a-comma-delimited-list-using-select-clause-from-table-column/
My doubt is: How to set environment variables using stored procedures.i did not know how to get those env var values ti t-sql.So,please give me an example to do this.It may be useful for beginners like me.. when I select the data I get is like this 1 2232 eq233 1000 12-12-2011 11:11 39 9.2 text text I want this output to have comma instead of space like 1, 2232, eq233, 1000, 12-12-2011 11:11, 39, 9.2, text text, can some please help