Not 100% sure what you're after here. I presume it's something a bit more complex than just

select fld1, fld2, fld3, fld4

from tbl1

where fld1 = 123 and fld2 = 'abc'...

Hi Mitch

Sounds like you are trying to insert an explicit value into a field that has been designed to assign its own values automatically on insert (possibly an auto-incrementing primary...

In what format do you want the results presented? Random order of numbers 1-52 in a table?

Regards

Phil

This looks deliberate on the part of Microsoft.

This link looks relevant

Regards

Phil

Yes, this can be done. Check out OBJECTPROPERTY in BOL, specifically the CnstIsDisabled property name.

Phil

Strange. 8152 = "String or binary data would be truncated," which suggests some sort of update failure to me (eg if you are trying to update a 20 character...

This doesn't sound good. I tried doing a Google search on

"hang module hungapp" mmc

and still not getting very far. The evidence seems to implicate hardware and/or some...

For MDAC version, check out this link:

http://www.microsoft.com/downloads/details.aspx?familyid=8f0a8df6-4a21-4b43-bf53-14332ef092c9&displaylang=en

This should help. Not the most elegant, but neither is the format. You will have to amend the letters in the @negs string to correspond properly with your...

Wow, bizarre format.

So is the legacy field always 7 characters long, with an implied decimal point between characters 5 and 6? If so, you should store this data in...

Thanks Bill. What an ace surname!

It does help - thanks.

I had to get the job done yesterday, so I ended up mapping all of the strings to integers to get the import to work, then...

I'm not an MSDE expert, but I would have thought that to gain full access to the MSDE instance from EM, you would need admin username (sa) and password for...

Your problem is obviously as a result of b.response_size sometimes being zero.

Not sure what you want to do about this, but if you wanted to replace it with a '1'...

If you use round(float,0,1), it truncates float to integer (ie 0.5 and above are not rounded up), so the given example actually works OK. Eg

select round(1.999999,0,1) as IntPart

returns 1.000000