Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 Functions on SQL Server

Author  Topic 

alex23
Starting Member

1 Post

Posted - 2002-02-12 : 04:16:00
Hi,

I'm looking for a list/manual which can tell me which functions i can use within a sql query on my Microsoft sql server.

I know there are functions like sum, count, max, avg but there must be a lot more functions may'be something like substr(), hour(), minute(), etc.

I hope to hear soon something!!

gr,

Alexander

jemm
Starting Member

6 Posts

Posted - 2002-02-12 : 04:33:53
Hi, alex!

SQL Server comes with the Books Online -documentation (look from Start -menu) which contains (among other things) list of all the functions supported by the T-SQL.

Try looking from Contents|Transact-SQL Reference|Functions.
There they are listed by categories.

If you use the MSDE, I'm not sure if it comes with the documentation...

HTH,

--
-Jemm
Go to Top of Page

Arnold Fribble
Yak-finder General

1961 Posts

Posted - 2002-02-12 : 06:05:20
If you don't have a local copy (though I'm not sure why you wouldn't), it's all in Microsoft's MSDN library as HTML or downloadable HTML help:

http://www.microsoft.com/sql/techinfo/productdoc/2000/


Go to Top of Page
   

- Advertisement -