How to ADD a SQL SERVER name in every row of a table.

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » Development » How to ADD a SQL SERVER name in every row of...

How to ADD a SQL SERVER name in every row of a table.

Rate Topic

Display Mode

Topic Options

Author

Message

qur7

Posted Tuesday, January 29, 2013 1:07 PM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Yesterday @ 12:00 PM
Points: 144, Visits: 630

Hi Development Guys,

I need to add a column in a SQL server database table ( which i have done). Now i have to add SQL SERVER name on every row of the table in this new column ( same entry on every row).

Can some please help me how to accomplish that?

Thanks in advance.

Post #1413282

Evil Kraig F

Posted Tuesday, January 29, 2013 1:08 PM

SSCertifiable

Group: General Forum Members
Last Login: Today @ 12:05 AM
Points: 5,688, Visits: 6,142

UPDATE table SET newcol = @@SERVERNAME

Unless I'm really not understanding the question?

- Craig Farrell

Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.

For better assistance in answering your questions | Forum Netiquette
For index/tuning help, follow these directions. |Tally Tables
Twitter: @AnyWayDBA

Post #1413285

qur7

Posted Tuesday, January 29, 2013 6:30 PM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Yesterday @ 12:00 PM
Points: 144, Visits: 630

Thanks a lot, i already found the update statement and it solved my problem.... Thanks again.

Post #1413409

« Prev Topic | Next Topic »

Permissions