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,375
    Likes Received:
    388
    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,645
    Likes Received:
    87
    Trophy Points:
    0
    Occupation:
    Programmer
    Location:
    Kolkata, India
    Home Page:
    http://blog.pradeep.net.in
    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:
    http://www.officialhackers.com
    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

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice