Viewing 15 posts - 51,541 through 51,555 (of 59,072 total)
Nice short to-the-point article on some very useful information... thanks!
March 24, 2008 at 5:56 am
There are several system functions to help you in the area of user names...
USER
USER_ID()
USER_NAME() -- Same as CURRENT_USER
SESSION_USER
SYSTEM_USER -- Probably the one you're looking for.
Using the @@SPID system...
March 24, 2008 at 5:50 am
Great description, Pcplayer... that one is a bit out of scope for things I've done, but between the description and the error messages you've shown, someone is bound to help......
March 24, 2008 at 5:39 am
molecule_kaab (3/23/2008)
I wonder that if I use TRIGGER, can it tell which field is modified.
I want to...
March 23, 2008 at 2:59 pm
A better question would be... what is it that you're actually trying to do using OLE Automation?
March 23, 2008 at 2:42 pm
I agree with Matt and Barry... a permanent date table would be much faster than any other method. Lot's more convenient, too, because all the dates are always available....
March 23, 2008 at 2:27 pm
ace (3/22/2008)
I appreciate...
March 23, 2008 at 2:01 pm
Thanks... lots of folks don't know when I'm joking or not...
On the serious side, the really neat thing about the Developer's edition is that every developer can have it on...
March 22, 2008 at 12:07 pm
If you're gonna use a compare tool to promote from Dev to Prod, you might as well just give the developers full access to Prod... unless you do a code...
March 22, 2008 at 11:08 am
If you would take the data you originally posted and put it and a simple table definition into the form that Lynn asked you to, that would be great 😉
March 22, 2008 at 10:20 am
ksullivan (3/22/2008)
There is no need to include upper() in the where clause. TSQL is not case sensitive.
Not quite true... the default is to setup SQL Server so that it...
March 22, 2008 at 10:14 am
With the information provided, all I can say is did you remember to hit the "Run SQL Faster"? 😀
Seriously, though... we need a bit more information. First, 30,000 rows...
March 22, 2008 at 9:36 am
Yan Gao (1/9/2008)
Jeff Moden (1/4/2008)
How did it help? What was the problem?I had the file open. Once I closed it, it imported fine...:)
Heh... I had the same problem...
March 21, 2008 at 5:54 pm
Ah... I see... No big difference there... Use IF on SQL Server... just like you can in Oracle in this "case" 😀
It sounds like you're worried a bit about...
March 21, 2008 at 9:46 am
Regardless of what the cause of the deadlock is, I guarantee it's going to be code that has a BEGIN TRAN/COMMIT in it... unless someone went nuts using that everywhere,...
March 21, 2008 at 9:41 am
Viewing 15 posts - 51,541 through 51,555 (of 59,072 total)