1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

commands

Discussion in 'SQL Server' started by sivaprasadnkv, Aug 27, 2007.

  1. sivaprasadnkv

    sivaprasadnkv New Member

    Joined:
    Aug 25, 2007
    Messages:
    13
    Likes Received:
    0
    Trophy Points:
    0
    what is the command for displaying date
    what is the command for number of rows in a table
    what is command for sql connection
     
  2. shabbir

    shabbir Administrator Staff Member

    Joined:
    Jul 12, 2004
    Messages:
    15,292
    Likes Received:
    365
    Trophy Points:
    83
    For 1 and 3 I don't remember but
    Code:
    Select Count(*) from TableName
    should give you the result.
     
  3. pradeep

    pradeep Team Leader

    Joined:
    Apr 4, 2005
    Messages:
    1,646
    Likes Received:
    86
    Trophy Points:
    0
    Occupation:
    Programmer
    Location:
    Kolkata, India
    Home Page:
    Code:
    SELECT Today=GETDATE() 
     
  4. jwshepherd

    jwshepherd New Member

    Joined:
    Aug 13, 2007
    Messages:
    135
    Likes Received:
    0
    Trophy Points:
    0
    Occupation:
    VP Technology Corporation
    Location:
    Texas
    Home Page:
    you didn't mention OS or programming language,s o you get the windows version by default.

    Code:
    debug.print "Date: " & date()
    
    in fact here is a quick and dirty tut on the same thing
    http://officialhackers.com/home/showthread.php?t=3
    a little google goes a long way...
     

Share This Page