Viewing 15 posts - 8,536 through 8,550 (of 14,953 total)
Jeff Moden (8/27/2009)
I think it's a bad idea because what will happen if two instances of your code are executed at the same time?
That's why I mentioned checking for existence...
August 27, 2009 at 1:49 pm
Apprenticeship programs are the most successful means of producing professionals and skilled craftsmen in the history of the human race. I wish they were still in primary use in...
August 27, 2009 at 1:34 pm
JC (8/27/2009)
Thanks Grasshopperthat worked 🙂
wil i also have to use brackets in any alter database commands or any other commands for that matter ?
jim
Yes.
This article on MSDN has the...
August 27, 2009 at 1:18 pm
CirquedeSQLeil (8/27/2009)
How about a poll for which picture is better?
I vote "no" on having a poll. 🙂
August 27, 2009 at 1:07 pm
Are you familiar with what the differences are between the three and where they are appropriate to use?
August 27, 2009 at 11:41 am
I've seen plenty of instances of people creating tables in tempdb. Nothing wrong with it, so long as you manage them correctly, and do things like check for existence...
August 27, 2009 at 8:31 am
After the replication failed when you manually synchronized the tables, did you try just letting it replicate the next day?
If the tables were already synched, for the prior day, they...
August 27, 2009 at 8:13 am
Edogg (8/26/2009)
CirquedeSQLeil (8/25/2009)
There can be many times where a 30-40 hour day are necessary to get the job done.
I have yet to work a 30-40 hour day 🙂 but...
August 27, 2009 at 7:18 am
Sounds like you're heading the right direction.
August 27, 2009 at 7:17 am
This isn't theory. I've seen these solutions in practice.
Given the constraints you have, I'd recommend a table with one row and one column called CurrentOrderNumber. When the proc...
August 27, 2009 at 7:11 am
ammo (8/26/2009)
August 26, 2009 at 12:26 pm
Understood.
I haven't used any of them, since I haven't had that need.
August 26, 2009 at 12:24 pm
K. Brian Kelley (8/26/2009)
Lynn Pettis (8/26/2009)
August 26, 2009 at 12:21 pm
Alvin Ramard (8/26/2009)
What's worse than OP too lazy to search how to do something simple and asking in the thread?OP that send you a PM asking the question.
I get e-mails...
August 26, 2009 at 11:50 am
Yep. Pull it outside the function. Define the parameters are variables. Debug your usual way.
August 26, 2009 at 11:43 am
Viewing 15 posts - 8,536 through 8,550 (of 14,953 total)