I agree with Steve. I have picked my copy of "inside TSQL programming" and "Inside TSQL querying" a few months back.

You can use the same CASE expression (that you used for select) inside the WHERE clause. For example:

-- create a table variable

DECLARE @numbers TABLE (Number INT)

-- fill the table

INSERT INTO...

I guess you have posted the question in the wrong forum. You should have posted it in SQL Server 2000 forums.

SQL server 2000 does not have the view sys.triggers. Read...

We do that too!

Another option is to use a VIEW. Create a view from the original table and select the columns in the required order and forget about the table. Use the VIEW...

DECLARE

@FirstOfThisMonth DATETIME,

@LastOfThisMonth DATETIME,

@FirstOfLastMonth DATETIME,

@LastOfLastMonth DATETIME,

@FirstOfNextMonth DATETIME,

@LastOfNextMonth DATETIME

SELECT

@FirstOfThisMonth =

CAST (

CAST ( YEAR (GETDATE()) AS VARCHAR ) + '-' +

CAST ( MONTH (GETDATE()) AS VARCHAR ) + '-' +...

There are dozens of schema editing tools available on internet. I have not tried any of them. I mostly work with the schema/xml editing tools of Visual Studio 2005 and...

Vasudev Tantry (12/18/2007)

---

Jacob,

Tell me.. how to take the reference of last record updated in my destiny, an Oracle Datbase Table and copy the next record from my...

There is nothing wrong with package variables and xml configuration files. I think this article sent a wrong message to many of the readers. I agree that a better way...

The scope of a server alias is limited to the local computer. Hence if two different computers have the same alias defined, there will be no conflict. Each computer will...

I am not aware of any such setting. XML is a built-in data type like INT or VARCHAR. So there should not be a special setting to enable it.

try SELECT...

SQL Server 2000 does not support the XML data type. If you want to work with parameters in XML format, you can still pass them as TEXT and use OPENXML()...

Manish Sinha (12/10/2007)

---

I am having a dot net application.Suppose I have to insert 5 rows in particular table.wat i do is that I call the sp once for each row.Which...

I...

WriteXml() does not work that way. It does not return a string. You need to create a stream object first and pass it to the method. The content of the...