Go4Expert

Go4Expert (http://www.go4expert.com/)
-   SQL Server (http://www.go4expert.com/forums/sql-server-forum/)
-   -   commands (http://www.go4expert.com/forums/commands-t6063/)

sivaprasadnkv 27Aug2007 13:19

commands
 
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 27Aug2007 14:59

Re: commands
 
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 27Aug2007 15:49

Re: commands
 
Quote:

Originally Posted by sivaprasadnkv
what is the command for displaying date

Code:

SELECT Today=GETDATE()

jwshepherd 27Aug2007 16:51

Re: commands
 
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...


All times are GMT +5.5. The time now is 03:38.