Hi

MSDN, BooksOnline are the gurus for SQL server 2000.

Just search in Google & study.

Also look for books on SQL Server

Hi

Go for the Inner Join instead of IN clause, certainly the performance will benefit.

Hi,

Just try this way

Select @CDate = Select substring(DateOfPayBill,3,5) AS Date from Tvarizi

Select @VDate = Select substring(Recievedate,3,5) AS Date from Tvarizi

Hi

Pls refer this link for a solution

http://www.codeproject.com/KB/reporting-services/Rank_Query.aspx

Hi

The ranking functions in SQL like Row_Number, Dense_rank, Rank are not supported in the 2000 version. It was introduced in 2005 version.

Try this one:

SELECT CustomerID , AddressID

FROM SampleData

FOR XML RAW('Customers'), ELEMENTS, ROOT('Customers')

I'm not quite sure abt the result.

Hi

Just search in Books online or MSDN

That will help you.

The types of DML triggers are

1)AFTER Triggers

2)INSTEAD OF Triggers

3)CLR Triggers

Links:

http://msdn.microsoft.com/en-us/library/ms189799.aspx

http://msdn.microsoft.com/en-us/library/ms178134.aspx

Else, go through these links

http://www.codeproject.com/KB/database/SQL_LIKE_Operator.aspx

http://www.codeproject.com/KB/database/SqlRegularExpressions.aspx

Hi

Just try '%@building%'

Detailed tutorials are here:

http://beyondrelational.com/blogs/jacob/archive/2009/06/12/for-xml-tutorials.aspx

Hi

I recommend straight upgrade from 2000 to 2008, since Denali, SQL Server 2011 knocking on the door, to be released next year.

I think you got carried away with Intellisense.

There are...

Hi

Pls go through the link,

http://www.sql-programmers.com/Blog/tabid/153/EntryId/10/XML-Data-Type-in-SQL-Server-2005.aspx

Hi

Pls move this question to SQL Server 2005 section...

You will get a better response.

In SQL Server 2000, Dense_Rank is not supported.

Good Luck Boss..!!

Hi..

Please refer this link also

http://beyondrelational.com/blogs/jacob/archive/2010/11/17/tsql-error-handling-enhancements-in-sql11-using-the-throw-command.aspx