Post reply

2 queries on the same row?

  • December 4, 2012 at 4:21 am

    #393734

    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...

  • December 4, 2012 at 4:27 am

    #1565217

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

  • December 4, 2012 at 4:30 am

    #1565219

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

  • December 4, 2012 at 4:36 am

    #1565220

    thanks alot!

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

    /J

  • December 4, 2012 at 5:21 am

    #1565240

    MSDN and some books like

    SQL Server for dummies are good for the initial start:cool:.

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply