commands

sivaprasadnkv's Avatar
Go4Expert Member
what is the command for displaying date
what is the command for number of rows in a table
what is command for sql connection
shabbir's Avatar, Join Date: Jul 2004
Go4Expert Founder
For 1 and 3 I don't remember but
Quote:
Originally Posted by sivaprasadnkv
what is the command for number of rows in a table
Code:
Select Count(*) from TableName
should give you the result.
pradeep's Avatar, Join Date: Apr 2005
Team Leader
Quote:
Originally Posted by sivaprasadnkv
what is the command for displaying date
Code:
SELECT Today=GETDATE()
jwshepherd's Avatar, Join Date: Aug 2007
Team Leader
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...