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...

These queries demonstrate the two different connection:

select @@SPID

SELECT * FROM OPENQUERY(MyServer,'select @@SPID')

timwell (3/17/2014)

---

I have a question.

I got crossed up because the documentation says that sp_serveroption and openquery are for connecting to remote or linked servers. I was thinking the delete was...