Viewing 15 posts - 25,936 through 25,950 (of 39,800 total)
Why do you have the "go"s in there?
Why not:
select * from tbl
if not exists(select * from othertbl)
insert into tbl1(fld1)
values(val1)
else
select 'done'
December 12, 2008 at 11:47 am
Sorry to hear that. Maybe you shouldn't have made that previous post :w00t:
December 12, 2008 at 10:53 am
old, but it works
http://www.sqlservercentral.com/articles/Administering/pushftp/473/
December 12, 2008 at 10:51 am
December 12, 2008 at 10:48 am
Where did you get the errors? From a client? It might be an issue there.
SQL doesn't report space issues, unless you add enough data that you run out of space...
December 12, 2008 at 10:24 am
There is no best idea. There are ideas that make sense at times and in situations.
December 12, 2008 at 10:18 am
Grab a calendar, muti year
Grab a dart
Send b) into a)
December 12, 2008 at 10:16 am
Boy if I lost this job I hope I could get an IT job. I guess you never know.
I would probably struggle along in another IT job for another 10...
December 12, 2008 at 10:08 am
Usually you enclose stuff in the tag. So for code, you'd highlight the code, then click the "code" item to the left and it brackets what you've highlighted with [...
December 12, 2008 at 10:06 am
Tab settings can be inconsistent, and so if you try to line things up, or open someone else's code, 2 tab stops could result in things being unreadable. Plus everyone...
December 12, 2008 at 9:30 am
It's not so much that they give different advice, that if you decide to go and restore pages or work through the corruption, the $250 is a cheap few hours...
December 12, 2008 at 9:18 am
I'm not sure you need to change ladders. Making big saves, however, does make you look good, it's remembered, and it might mean that at review time you stand out...
December 12, 2008 at 8:59 am
Great editorial and interesting responses. Thanks for the break, Phil, I had run snowboarding yesterday 🙂
I wonder if we'll start to change the way we write procedures in the future?...
December 12, 2008 at 8:37 am
Why did this thread start?
I feel old until I read some of these posts.
Been driving on four wheels for 26 years, 25 cars in that time, if you include the...
December 12, 2008 at 8:27 am
Ha, I rarely drink at home. It's all you guys at TechEd and Pass that get me into trouble!
December 12, 2008 at 7:56 am
Viewing 15 posts - 25,936 through 25,950 (of 39,800 total)