Viewing 15 posts - 3,121 through 3,135 (of 14,953 total)
Password protect? As in save it as a file so it can be deployed somewhere and encrypt the file? Or as in protect privileged data within the package...
October 13, 2011 at 11:26 am
Generally, you're better off doing that kind of thing in the presentation layer, not in the query or the database.
That allows different users/applications/services to consume the data the way they...
October 13, 2011 at 11:23 am
daveriya (10/13/2011)
IS THIS correctset @Account_date = convert(datetime,@Account_date,126)
That probably won't do anything useful for you.
Storing the data in a particular format is only useful if you're converting to a string...
October 13, 2011 at 11:15 am
Roy Ernest (10/13/2011)
I am at the Presentation of Steve jones for the sql pass. MS supported event and guess what laptop Steve is using? An Apple.. 😀
I like it!
Even...
October 13, 2011 at 11:11 am
Lynn Pettis (10/13/2011)
OMGReally??
Yup.
October 13, 2011 at 11:09 am
daveriya (10/13/2011)
i am getting this error : [Microsoft][SQL Native Client][SQL Server]Conversion failed when converting datetime from character string.i place 'set @Account_date = convert(datetime,'yyyy-mm-ddThh:mm:ss.mmm',126)'
When was yyyy-mm-ddThh:mm:ss.mmm?
That's a format, not a...
October 13, 2011 at 11:07 am
It's a single equality comparison. It's going to be faster than a range comparison.
It will force the scales to be integer values. You won't be able to extend...
October 13, 2011 at 10:05 am
Is the remote server SQL Server, or something else?
October 13, 2011 at 9:28 am
Jeff Moden (10/13/2011)
L' Eomot Inversé (10/13/2011)
SQLRNNR (10/13/2011)
GSquared (10/13/2011)
Ninja's_RGR'us (10/13/2011)
BrainDonor (10/13/2011)
I know a few users I'd like to send into space.
Yup but the thing is they'll come back. Not really...
October 13, 2011 at 9:25 am
Ninja's_RGR'us (10/13/2011)
GSquared (10/13/2011)
Ninja's_RGR'us (10/13/2011)
GSquared (10/13/2011)
October 13, 2011 at 9:24 am
Ceiling won't get the same results as the other queries. Floor will. Try it with that.
Ceiling is dropping any that are higher than the highest scale value. ...
October 13, 2011 at 9:22 am
Ninja's_RGR'us (10/13/2011)
GSquared (10/13/2011)
You might...
October 13, 2011 at 9:19 am
That'll work. Might end up with problems in terms of cached execution plans being good for one or the other but not both, and so on.
You might want to...
October 13, 2011 at 9:06 am
Another thing to keep in mind is that varchar storage takes more bytes than char storage, since it has to also store the length. Plus, because of the way...
October 13, 2011 at 8:59 am
Viewing 15 posts - 3,121 through 3,135 (of 14,953 total)