2 queries on the same row?

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2008 » SQL Server Newbies » 2 queries on the same row?

2 queries on the same row?

Rate Topic

Display Mode

Topic Options

Author

Message

joackim.breien

Posted Tuesday, December 04, 2012 4:21 AM

Grasshopper

Group: General Forum Members
Last Login: Today @ 4:53 AM
Points: 19, Visits: 93

i just know this must be a breeze if you have any type of experiance in t-sql, but i im a newbie im struggling with this...

all i want to do is have the results of:

select value from master.sys.configurations where name = 'max server memory (MB)'

and this query

select @@SERVERNAME

on the same row in the results...

Post #1392358

e4d4

Posted Tuesday, December 04, 2012 4:27 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Today @ 2:23 PM
Points: 160, Visits: 1,142

select @@SERVERNAME ,value from master.sys.configurations where name = 'max server memory (MB)'

Post #1392362

arunyadav007

Posted Tuesday, December 04, 2012 4:30 AM

SSC Rookie

Group: General Forum Members
Last Login: Friday, May 03, 2013 3:06 AM
Points: 42, Visits: 285

select @@SERVERNAME as "Server_Name" , value from master.sys.configurations where name = 'max server memory (MB)'

Post #1392365

joackim.breien

Posted Tuesday, December 04, 2012 4:36 AM

Grasshopper

Group: General Forum Members
Last Login: Today @ 4:53 AM
Points: 19, Visits: 93

thanks alot!

any tips on where i might learn the basics in t-sql?

/J

Post #1392367

jeetsingh.cs

Posted Tuesday, December 04, 2012 5:21 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Today @ 6:36 AM
Points: 192, Visits: 406

MSDN and some books like
SQL Server for dummies are good for the initial start Cool

Post #1392391

« Prev Topic | Next Topic »

Permissions