RBarryYoung (3/25/2009)

---

usarian (3/25/2009)

---

Point taken on the float bit. In your example one does get the correct result, HOWEVER:

DECLARE @a AS FLOAT

SET @a = 1

SELECT @a

--VS

DECLARE @a AS DECIMAL

SET @a...

Sergiy (1/15/2009)

---

DECLARE @One decimal, @Three decimal

SET @One = 1

SET @Three = 3

SELECT @One/@Three + @One/@Three +...

Point taken on the float bit. In your example one does get the correct result, HOWEVER:

DECLARE @a AS FLOAT

SET @a = 1

SELECT @a

--VS

DECLARE @a AS DECIMAL

SET @a = 1

SELECT...

Wow!

The tip about DDL and CLR triggers was great!

It's too bad we don't see more articles like this!

Short, Sweet, and useful!