stephen.long 56048 (5/5/2014)

---

The list shown here includes bit in the list of "exact numeric types".

http://msdn.microsoft.com/en-us/library/ms187752.aspx (Data Types (Transact-SQL))

The definition of bit, shown here, calls it "An integer data type that...

In SSMS 2008 r2, results could be copied only in grid mode or if the amount of the text is less than 2MB. If text is more than 2MB you...

When results come out in text, you can search for a string (ctrl+f), instead, in grid mode you can not search in the results.

Good!

kupy (4/7/2014)

---

Carlo Romagnano (4/7/2014)

---

happycat59 (4/7/2014)

---

SET NOEXEC might find syntax errors but it doesn't find all errors. I copied a piece of code that included a "RANK... PARTITION BY [invalid...

happycat59 (4/7/2014)

---

SET NOEXEC might find syntax errors but it doesn't find all errors. I copied a piece of code that included a "RANK... PARTITION BY [invalid column]" -...

free_mascot (4/2/2014)

---

I have executed in SQL 2012 and got...

I do not like question too long. I have just few minute to answer.

A lot of useless words and none of the main one.

In sqlserver 2008 r2 the update doesn't return any resultset and no error message.

(2 row(s) affected)

(2 row(s) affected)

What I'm missing?

Hugo Kornelis (3/30/2014)

---

And even then, they are often not used...

The lack of a semi-colon causes or would cause...

Remember that "Filtered indexes" are used only if the WHERE clause matches or is compatible with the filter.

View http://www.sqlservercentral.com/questions/T-SQL/105826/

marcia.j.wilson (3/18/2014)

---

I'm not sure I completely understand this.

Is this what's going on?

-The query initially adds a single row with a value of 1.

- The open query returns the deleted set...

About?

Hany Helmy (3/18/2014)

---

-1...