Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

2 queries on the same row? Expand / Collapse
Author
Message
Posted Tuesday, December 4, 2012 4:21 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Friday, September 19, 2014 1:57 AM
Points: 32, Visits: 197
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
Posted Tuesday, December 4, 2012 4:27 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Tuesday, September 16, 2014 8:38 AM
Points: 223, Visits: 1,725
select @@SERVERNAME ,value from master.sys.configurations where name = 'max server memory (MB)'

Post #1392362
Posted Tuesday, December 4, 2012 4:30 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Thursday, July 24, 2014 11:46 PM
Points: 42, Visits: 290
select @@SERVERNAME as "Server_Name" , value from master.sys.configurations where name = 'max server memory (MB)'
Post #1392365
Posted Tuesday, December 4, 2012 4:36 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Friday, September 19, 2014 1:57 AM
Points: 32, Visits: 197
thanks alot!

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

/J
Post #1392367
Posted Tuesday, December 4, 2012 5:21 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Thursday, September 11, 2014 3:38 AM
Points: 251, Visits: 613
MSDN and some books like
SQL Server for dummies are good for the initial start.
Post #1392391
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse