Common Objects in SQL Server 2005

23 Nov 2006 11:34 AM

Dio

Hi, please tell me where I can find Common Objects in SQL Server
2005.....that who appear in Query Analizer (SQL Server 2000)

Common Objects: Configuration Functions, Cursor Functions, Date and Time
Functions etc

Thanks a lot

23 Nov 2006 6:11 PM

Arnie Rowland

Look up 'Functions' in Books Online.

--
Arnie Rowland, Ph.D.
Westwood Consulting, Inc

Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous

You can't help someone get up a hill without getting a little closer to the
top yourself.
- H. Norman Schwarzkopf

Show quote

"Dio" <D**@discussions.microsoft.com> wrote in message
news:EC56348F-6637-4015-BFE1-17DE37A44B4D@microsoft.com...
> Hi, please tell me where I can find Common Objects in SQL Server
> 2005.....that who appear in Query Analizer (SQL Server 2000)
>
> Common Objects: Configuration Functions, Cursor Functions, Date and Time
> Functions etc
>
>
> Thanks a lot
>

25 Nov 2006 5:24 PM

Erland Sommarskog

Dio (D**@discussions.microsoft.com) writes:

> Hi, please tell me where I can find Common Objects in SQL Server
> 2005.....that who appear in Query Analizer (SQL Server 2000)
>
> Common Objects: Configuration Functions, Cursor Functions, Date and Time
> Functions etc

Most of them are under Programmability->Functions->System functions.

Obviously things that are not system functions are not there.

--
Erland Sommarskog, SQL Server MVP, esq***@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

26 Nov 2006 10:35 AM

Dio

thx a lot ;)

Show quote

"Erland Sommarskog" wrote:

> Dio (D**@discussions.microsoft.com) writes:
> > Hi, please tell me where I can find Common Objects in SQL Server
> > 2005.....that who appear in Query Analizer (SQL Server 2000)
> >
> > Common Objects: Configuration Functions, Cursor Functions, Date and Time
> > Functions etc
>
> Most of them are under Programmability->Functions->System functions.
>
> Obviously things that are not system functions are not there.
>
>
>
> --
> Erland Sommarskog, SQL Server MVP, esq***@sommarskog.se
>
> Books Online for SQL Server 2005 at
> http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
> Books Online for SQL Server 2000 at
> http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
>