Viewing 15 posts - 4,606 through 4,620 (of 26,490 total)
Best thing, store date and datetime values using the proper date or date/time data type, then you don't have the conversion issues.
September 1, 2015 at 10:28 am
Munabhai (9/1/2015)
If I use, as following, it won't throw error, but it will display 0 instead of blank.WHEN ISNULL(date1, '1900-01-01') = '1900-01-01' THEN ''
Please learn to be consistent in...
September 1, 2015 at 10:20 am
Looks like I'll miss the draft. I'll be on the road coming back home from Prescott, AZ.
September 1, 2015 at 10:06 am
bsmith 63193 (9/1/2015)
Same error message.
You are going to have to provide the complete error message. Also, are any of these tables actually views?
September 1, 2015 at 8:53 am
Barcelona10 (8/31/2015)
If i create same sp on master and myDB (sp_XYZ with dbo schema) and run exec sp_XYZ which sp_XYZ will execute ,the on master or myDB?
And...
August 31, 2015 at 5:05 pm
bsmith 63193 (8/31/2015)
Lynn Pettis (8/31/2015)
update n SET
[INTERNET-ADDRESS] = 'bsmith@acme.com'
from
SKYWARD.PUB.NAME n
INNER JOIN SKYWARD.PUB.QUDDAT-DATA qd
...
August 31, 2015 at 3:48 pm
The following should work:
update n SET
[INTERNET-ADDRESS] = 'bsmith@acme.com'
from
SKYWARD.PUB.NAME n
INNER JOIN SKYWARD.PUB.QUDDAT-DATA qd
...
August 31, 2015 at 3:30 pm
bsmith 63193 (8/31/2015)
August 31, 2015 at 3:08 pm
Sean Lange (8/31/2015)
Grant Fritchey (8/31/2015)
August 31, 2015 at 9:00 am
Help us help you. Provide what is asked in the articles you reference in your own signature block.
August 28, 2015 at 11:02 am
mar.ko (8/28/2015)
Lynn Pettis (8/28/2015)
My biggest pet peeve! The semicolon is a terminator, not a begininator. It belongs at the end of statements not the beginning.
Exactly, another dumb rule.
I...
August 28, 2015 at 10:57 am
Lowell (8/28/2015)
must be terminated with a semicolon. that's probably where the issue likes.
that issue makes a lot of people precede their [WITH] to...
August 28, 2015 at 10:13 am
liamdemasi (8/27/2015)
Database default collation is SQL_Latin1_General_CP1_CI_AI
There is your answer. You need to cast the column to a new collation that is case sensitive and accent sensitive to achieve the...
August 27, 2015 at 2:13 pm
Silver spoon, you post a question and then remove it? Why?
Reported the "post" deleted by OP, suggested removing the post entirely. Why leave a non question around.
August 27, 2015 at 1:54 pm
What collation are you using?
August 27, 2015 at 1:49 pm
Viewing 15 posts - 4,606 through 4,620 (of 26,490 total)