Your assessment of cursors in a trigger being a bad idea is correct. Cursors can be really bad for performance and inside a trigger can be one of the worst...

Yeah there is no sure fire way to do that. One recommendation is to rename the objects instead of deleting them. For example if you have table called "Employees" that...

sturner (5/25/2012)

---

Sean Lange (5/25/2012)

---

I can remember on many occasions when it was windy we would fly backwards. Just pick a spot and point straight into the wind, slow down to...

I can remember on many occasions when it was windy we would fly backwards. Just pick a spot and point straight into the wind, slow down to just above stall...

Koen Verbeeck (5/24/2012)

---

Sean Lange (5/24/2012)

---

Koen Verbeeck (5/24/2012)

---

Sean Lange (5/24/2012)

---

Always keep in mind that the questions you find super easy today are a great chance for some less experienced folks to...

blampe (5/24/2012)

---

Thank you for your input!

SSCommitted,

There is no real correlation between the SSN and the new value ........ The purpose of this is to mask the SSN because it is...

Fly Girl (5/24/2012)

---

The Bücker is a load of fun. There is pretty much nothing practical you can do in it: it sucks for transportation (2 hrs of fuel max, little...

Koen Verbeeck (5/24/2012)

---

Sean Lange (5/24/2012)

---

Always keep in mind that the questions you find super easy today are a great chance for some less experienced folks to start answering. This helps...

SQL Kiwi (5/24/2012)

---

Yikes, no. You're thinking...

I suspect Paul will link to this article. One I keep close at hand myself.

http://www.sqlteam.com/article/datediff-function-demystified

CptCrusty1 (5/24/2012)

---

Lynn Pettis (5/24/2012)

---

Actually, you didn't eliminate the NOLOCKS hint, you just hide them in the view.

What is with the hint any way? You do know the issues with...

Lynn Pettis (5/24/2012)

---

CptCrusty1 (5/24/2012)

---

Lynn Pettis (5/24/2012)

---

Actually, you didn't eliminate the NOLOCKS hint, you just hide them in the view.

What is with the hint any way? You do know the...

tobinare (5/24/2012)

---

I'm very new to SQL Server and am programming a front end to a database using c++ and ADO. I've noticed that while submitting a SELECT query to...

You do not need a cursor to do this. Cursors are the bane of t-sql development.

If you can explain what you want for output I can help. Unfortunately so...

To understand this you first have to break it apart.

The second parameter inside...