Viewing 15 posts - 47,926 through 47,940 (of 59,064 total)
Jeez... doesn't anyone know how to use "Get External Data" on a simple view anymore? 😉
October 4, 2008 at 1:12 pm
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...
October 4, 2008 at 12:16 pm
Heh... no... writing smart code isn't difficult. You simply have to make the choice not to write bad code. 😛
October 4, 2008 at 11:31 am
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...
October 3, 2008 at 11:12 pm
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,...
October 3, 2008 at 8:55 pm
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...
October 3, 2008 at 8:34 pm
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...
October 3, 2008 at 8:30 pm
Actually, there is a direct replacement for RowNum=1 in SQL Server... it's called TOP 1. 🙂
October 3, 2008 at 8:25 pm
Cross post... please don't answer on this thread... go to the following instead...
http://www.sqlservercentral.com/Forums/Topic580370-1291-1.aspx
October 3, 2008 at 8:22 pm
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. 😉
October 3, 2008 at 8:14 pm
Franco_1 (10/3/2008)
October 3, 2008 at 8:05 pm
And, yet, we so no testing nor references to Microsoft articles on the subject... does anyone have proof one way or the other? 😉
October 3, 2008 at 8:01 pm
jlp3630 (10/3/2008)
October 3, 2008 at 7:51 pm
jeremiah.peschka (10/3/2008)
Likewise, CLR functions have an even larger performance advantage over T-SQL functions for complex computation, string manipulation, and business logic.
With the exception of RegExReplace, many of us have been...
October 3, 2008 at 7:48 pm
lcjohnson (10/3/2008)
I found the script to kill the users. Thanks.
Use with great caution! If you hit the wrong SPID, you can tank the server or some critical poorly written...
October 3, 2008 at 7:45 pm
Viewing 15 posts - 47,926 through 47,940 (of 59,064 total)