All SQL Server built-in functions

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)

All SQL Server built-in functions

Author

Topic

sql_er
Constraint Violating Yak Guru

267 Posts

Posted - 2006-12-18 : 12:06:45

Different SQL Server functions could be useful at different times. I know and use a bunch of them. However, I am curious to see all of them, with their description, inputs and output.

Would anyone know where I can find a place listing all the sql server built-in/predefined functions?

Thank you very much

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2006-12-18 : 12:09:28

Books Online! By far the best place for information about SQL Server functions.
Second one is GOOGLE.

Peter Larsson
Helsingborg, Sweden

sql_er
Constraint Violating Yak Guru

267 Posts

Posted - 2006-12-18 : 12:30:41

Hmm ... I googled, but could not find anything.

I thought there should be a comprehensive guide somewhere, but cannot locate it ... which is why I am here.

DonAtWork
Master Smack Fu Yak Hacker

2167 Posts

Posted - 2006-12-18 : 12:35:16

comprehensive guide = Books Online = SQL Help

Fire up Enterprise Manager or Query Analyzer, and push F1

Bingo, books online!

or here http://msdn.microsoft.com/library/default.asp?url=/library/en-us/startsql/portal_7ap1.asp

[Signature]For fast help, follow this link:
http://weblogs.sqlteam.com/brettk/archive/2005/05/25.aspx
Learn SQL
http://www.sql-tutorial.net/
http://www.firstsql.com/tutor.htm
http://www.w3schools.com/sql/default.asp

sql_er
Constraint Violating Yak Guru

267 Posts

Posted - 2006-12-18 : 12:55:40

I meant comprehensive in terms of containing Functions only.

BOL does contain everything ... but not what I was looking for. It is good to use when you need to look up to understand a certain function, but I wanted to see all functions, separately (not intermixed with other stuff)

Thanks for the help

robvolk
Most Valuable Yak

15732 Posts

Posted - 2006-12-18 : 13:50:47

Query Analyzer has an object browser that displays built-in/system functions.

TG
Master Smack Fu Yak Hacker

6065 Posts

Posted - 2006-12-18 : 14:09:19

>>but I wanted to see all functions, separately (not intermixed with other stuff)

Books Online has a topic called "functions". That topic has a link to 10 different categories of functions (ie: string, system, math, etc).

The Index tab in Books Online has the same topic "Functions" that has sub-listings of all functions listed together.

There is really no better sql reference the BOL...IMO

Be One with the Optimizer
TG

sql_er
Constraint Violating Yak Guru

267 Posts

Posted - 2006-12-18 : 14:15:27

Got it.

Thanks for the help!

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources