Obvious! In the daily work you do not need a special syntax. But, sometime my clients ask me for something special. And thanks to the delimiter I can extract...

Same behavior for previous versions of sqlserver.

I...

tommyh.

Running the code under 2000 all i get is

(1 row(s) affected)

under 2005 and 2008 i get

Server: Msg 3609, Level 16, State 1, Line 1

The transaction ended in the trigger....

Here the script that states "No column reference pulls data from multiple rows"

create function aaaa() returns int

as

begin

return (select SUM(a) from aza )

end

GO

create table aza(a int,b as...

Some operations have no sense inside a transaction. I surprise to see so many wrong answers.

nisan.al (8/29/2010)

---

I can't say i completely understand this issue.

The while statement dont not stop because @i will never be equal to 1

So how come the following select return 1 ?

DECLARE...

Steve Eckhart (8/26/2010)

---

Very good question. I discovered that whether or not 0.9 + 0.1 <> 1 is not consistent I guess depending on sequence. If you execute the following in...

To compare two floating point I use this syntax:

IF ABS(varFloat1 - varFloat2) < 0.01 -- place here the precision you want

print 'varFloat1 = varFloat2'

ELSE

print...

da-zero (8/24/2010)

---

Carlo Romagnano (8/24/2010)

---

One way to avoid worrying about NULLs is never to use them, always declaring columns as not allowing NULLs and designating default values for "empty" or "unknown"....

SQL2008???

What's the difference from the other versions of sqlserver or ANSI...

One way to avoid worrying about NULLs is never to use them, always declaring columns as not allowing NULLs and designating default values for "empty" or "unknown". This will save...

That's false: COUNT(*) returns the number of ROWS regardless of values of columns. :w00t:

Answer is very easy: SELECT DISTINCT does not have parameters.

It's the same, but many people get it wrong again.:-D:-D:-D