Jeez... doesn't anyone know how to use "Get External Data" on a simple view anymore? 😉

Ummm.... if you make a "sandbox" database, it won't get overwritten. The key is having access to the production data via a "reporting" database... if you create synonyms or...

Heh... no... writing smart code isn't difficult. You simply have to make the choice not to write bad code. 😛

Heh... it's customary to test your own test code before you post it to make sure it works. Anyway, since there seems to be a pattern to things...

--===== If...

I agree... it depends. If it's CRUD, it should probably be done in separate procs. If it's to merge data from a staging table into a final table,...

vidhyasudha (9/12/2007)

---

Hi There,

Im having the problem when i tried to update the value in the column.

My table has following columns,

ID Degree

C111 BSC

C111 MSC

ID acts as a Primary Key

I need to...

By the way, Ainsley... SQL Server doesn't support multi column updates using a list of targets vs a list of sources separated by a single "=" sign. You have...

Actually, there is a direct replacement for RowNum=1 in SQL Server... it's called TOP 1. 🙂

Cross post... please don't answer on this thread... go to the following instead...

http://www.sqlservercentral.com/Forums/Topic580370-1291-1.aspx

Still, the deed is done and the OP is gonna whack the internal documentation in someone's DB. Questions like this should simply go unanswered. 😉

Franco_1 (10/3/2008)

---

I have to concatenate fields from a table into on huge column in another table. Problem is some of the data from some of the columns are varchar, float...

And, yet, we so no testing nor references to Microsoft articles on the subject... does anyone have proof one way or the other? 😉

jlp3630 (10/3/2008)

---

Are there any disadvantages to using t-sql user defined functions? From a coding/maintainability perspective, I prefer to use them. However, I wasn't sure if I was taking a performance...

With the exception of RegExReplace, many of us have been...

Use with great caution! If you hit the wrong SPID, you can tank the server or some critical poorly written...