[sivaprasadnkv]

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]

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

Select Count(*) from TableName

should give you the result.

[pradeep]

Quote:

Originally Posted by sivaprasadnkv

what is the command for displaying date

SELECT Today=GETDATE()

[jwshepherd]

you didn't mention OS or programming language,s o you get the windows version by default.

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