Alan.B (10/15/2015)

---

Sean Lange (10/15/2015)

---

nguyenanhminhxd (10/15/2015)

---

I have a script contains multiple statements to update multiple tables. How can I make sure that either all statements get executed successfully or no changes...

nguyenanhminhxd (10/15/2015)

---

I have a script contains multiple statements to update multiple tables. How can I make sure that either all statements get executed successfully or no changes apply to the...

<snark>

Irritating data professionals.

A doorstop

</snark>

SQLPain (10/15/2015)

---

I am trying to make the following update: All the columns are fine except for the 'name' column. datatype for 'name' column in the target table is varchar(30) and...

One other suggestion. Not going to make a difference for performance but you should get out of the habit of ordering by ordinal position. You should always use the column...

maxlezious (10/13/2015)

---

I am in a situation that I cant make my mind up, I havent slept for 3 nights and would appreciate some advice by all the experienced people on...

Lynn Pettis (10/13/2015)

---

Sean Lange (10/13/2015)

---

WayneS (10/13/2015)

---

Sean Lange (10/13/2015)

---

Brandie Tarvin (10/13/2015)

---

My cats are always happy to see me. They just get irked when I ignore them to do MY thing instead...

WayneS (10/13/2015)

---

Sean Lange (10/13/2015)

---

Brandie Tarvin (10/13/2015)

---

My cats are always happy to see me. They just get irked when I ignore them to do MY thing instead of worshipping the ground...

Brandie Tarvin (10/13/2015)

---

My cats are always happy to see me. They just get irked when I ignore them to do MY thing instead of worshipping the ground they walk on.

"Dogs...

Grant Fritchey (10/13/2015)

---

Brandie Tarvin (10/13/2015)

---

Now she's hissing at me because I made the mistake of trying to move my other hand to...

trapnell (10/9/2015)

---

Fascinating! You do that just for fun?

There are several things in your code I've never seen before. For example, I don't understand why

SELECT n FROM (VALUES(0),(0),(0),(0),(0),(0),(0),(0),(0),(0))E(n)

works. ...

Here is another article which has all the information rolled into a nice tidy package. http://www.sqlservercentral.com/articles/comma+separated+list/71700/%5B/url%5D

GilaMonster (10/9/2015)

---

Sean Lange (10/9/2015)

---

It will generate an execution plan for this view if one is not already cached when a select statement is executed. If the execution plan already exists...

thebrewersinaz (10/9/2015)

---

Hi Gail thanks so much for the feedback. So when the first user calls the view the view and it physically gets created how long will that view stay...

Well maybe the OP will show back up and we can help them resolve this issue. It seems there a number of people willing to help but the OP is...