Thanks

Xarzu (10/13/2010)

---

I am new to writing stored procedures and this will be my first stored procedure written with Microsoft SQL Server Management Studio. I am familiar with working with...

Good question.

If computed columns are persisted in nature (e.g. QTot AS QF1 + QF2 PERSISTED,) then you receive the error after "Insert Zeroes" print statement and "SELECT * FROM @Quantities"...

Though I got it right, its nice to see difference between Access & SQL server in rounding the number. Thanks for the question, I remembered my old days when we...

Trick question but confused with explanation & query posted in the answer because it throws an error. Thanks Hugo for explanation. I learn usage of delimiters.

Nice question.

I think the reason for 'ANSI_NULLS will always be ON' for future version is to make the application behavior consistent.

Any other reason?

Andrew Novick (10/9/2010)

---

Yes, it's a problem. I submitted an item on Connect

https://connect.microsoft.com/SQLServer/feedback/details/398203/sp-rename-doesnt-change-the-text-of-udfs-or-procs-sp-helptext-then-returns-a-script-with-the-old-name

and it was classified as "Won't Fix"

It's something we're going to have to live with.

Regards,

Andy

Andrew Novick

SQL Server...

Thanks Tom Thomson for all backup types.

Nice question "Brandie Tarvin". Incremental is in Windows backup types & Differential is in SQL Backup types so its a googly ball 🙂

Congratulation to cross one million post 🙂

Whenever I want to learn something or face difficulty to solve the issue, my choice is to search in SSC - mostly I found...

nadersam (10/6/2010)

---

Hi David,

I am really sorry for my late reply but i was traveling away with limited internet access.

I attached the full scripts for recreating the scenario.

Pls note that there...

roelofsleroux (10/7/2010)

---

Nils thats becuase its not in there yet. Thats part of my version2 design...

rtelgenhoff (10/5/2010)

---

Ok Robert, you made me dig into this one deeper. We see the misconceptions about physical vs. logical ordering of pages in a clustered index, but there also...

Thanks 'UMG Developer' for reference links & Nakul for good question.

Nice question. Thanks.