Viewing 15 posts - 34,276 through 34,290 (of 39,800 total)
If file recovery doesn't do it, call MS. They might get you to a stable state. Also, do a full backup of your db file (the .mdf) right now. That's...
January 10, 2005 at 9:56 am
I'll clarify that I misworded the question
The dependencies was supposed to be the correct one in my reading of BOL and the...
January 10, 2005 at 7:52 am
Short answer is I edited #2 to be correct and #4 to be incorrect. I didn't change the flagging since its a slightly bigger pain in my arse and someone's...
January 6, 2005 at 6:08 pm
I did swap them around. Easier than changing the answer.
January 6, 2005 at 8:04 am
grumble, grumble, html encoding junk.
Apologies, somehow my link got encoded into nonsense. I edited it and it should work now.
January 6, 2005 at 8:00 am
After rereading the question and BOL, I agree with a number of people that #2 is the correct answer. I have corrected that fact and awarded points back to those...
January 5, 2005 at 9:51 am
Add a ROUND()?
SELECT cast( round((CONVERT(varchar, CAST(SUM(val) AS money),1)),0) as int) AS [Offered]
from mytable
January 4, 2005 at 10:15 am
You have a few cases that you need to handle. An OR will do it, but there may be better ways (more efficient). So you need to handle
- people...
January 4, 2005 at 10:12 am
Beta 3 is not out. There are two post Beta 2 builds, called Community Technical Previews (CTPs) that are intermediate builds. You can get them from Beta.ms.com or MSDN. There...
January 4, 2005 at 10:07 am
I like the idea of MySQL. I think PostgreSQL is a better product, more mature, but advances occur rapidly in both products, so that might not be the case. I...
January 2, 2005 at 11:23 am
what do you mean it can see the SQL Server? You can log in? If you can log in, SP2 has nothing to do with it. It would be a...
January 2, 2005 at 11:17 am
I'd use the Apex tool or another as documentation is best done by a tool.
January 2, 2005 at 11:15 am
Just insert permissions
set identity_insert mytable on
insert mytable (myidentity, myvalue) select @myid, @myval
set identity_insert off
January 2, 2005 at 11:14 am
Viewing 15 posts - 34,276 through 34,290 (of 39,800 total)