You might want to check out this whitepaper:

http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/ss2kidbp.mspx

http://sqljunkies.com/WebLog/amachanic/archive/2004/11/10/5065.aspx?Pending=true

FWIW, check this out:

http://www.sommarskog.se/error-handling-II.html

http://www.sommarskog.se/error-handling-I.html

See if this helps

USE Northwind

SELECT t1.CustomerID , t1.OrderDate

  FROM Orders t1

WHERE

  (SELECT COUNT(*)

     FROM Orders

    WHERE OrderDate<=t1.OrderDate AND CustomerID = t1.CustomerID) <=2

ORDER BY...

When you reread my first reply closely, you'll noticed that I didn't say "I need it". Actually I don't need it, but you made this bold statement, so I thought...

I asked first

Ooh, and as for "How to SELECT", have a look at LIKE.

Take a look at REPLACE in BOL.

P.S. And there is still one "never" - you never need GETDATE() inside UDF.

Just curious, can you expand on this?

Check this out: http://www.microsoft.com/resources/documentation/sql/2000/all/reskit/en-us/part3/c1161.mspx

Usually you would use the IMAGE datatype, however, when you start this new database directly on SQL Server 2005 use VARBINARY(MAX), since IMAGE will deprecate in...

Since indexes are physical implementations, creating an index on a computed column means, that you materialize that column. It is *NOT* virtual anymore.

Another...

You can also change it via script, but you need a workaround for it

IF OBJECT_ID('showme') > 0

 DROP TABLE showme

CREATE TABLE showme (c1 TEXT)

GO

INSERT INTO showme SELECT 'Hello World'

ALTER TABLE...

A well known trick is this: http://www.sqlteam.com/item.asp?ItemID=765

The major drawback here is that you can't control the order in which the rows are updated. There is no guarantee that they are updated...

Ignore my posting and go with Phil's suggestion. Misread your question. I thought you were wondering why the conversion from FLOAT to VARCHAR cuts off significant decimal places.

should i use cast?

Why don't you try it out?

To explain a bit. This behaviour is "by design". What happens is that the conversion...