Viewing 15 posts - 811 through 825 (of 3,348 total)
Igor Micev (2/17/2016)
I run your query on sql server 2014 and it works.What is the error message you have when you run it on sql 2012 ?
It works fine on...
February 17, 2016 at 2:25 am
Whether you "like" a design or not is actually irrelevant. The only question that matters is if it's correct.
If you have existing data that violates the primary key, then either...
February 17, 2016 at 2:21 am
Next time please post a valid XML fragment so that I don't need to guess how the XMML looks.
I think the below does what you need. You might have to...
February 17, 2016 at 2:13 am
SQL!$@w$0ME (2/16/2016)
For VARCHAR field, non-clustered index or full-text index recommended.
WRT nonclustered index: it depends. As Alan says: long varchar columns almost never. Shorter ones sometimes.
Do you often join on the...
February 17, 2016 at 2:03 am
Well, if the names change as well it become more cumbersome and a simple manual replace no longer cuts it.
Options I would look into would be a text editor with...
February 16, 2016 at 1:42 pm
ScottPletcher (2/16/2016)
Hugo Kornelis (2/16/2016)
ScottPletcher (2/16/2016)
Get rid of the dashes (-) in the date, they introduce errors (ambiguity).Use format 'YYYYMMDD [hh:mm:ss]', which is always interpreted correctly, regardless of language/date settings.
Sorry, but...
February 16, 2016 at 1:35 pm
If you create a view, it is legal syntax to make that view the target of an insert, update, or delete statement. By default, SQL Server will attempt to reverse...
February 16, 2016 at 1:25 pm
Almost certainly, the data has been removed from the buffer pool overnight, so it has to be read in from disk again. Then it is accessed frequently enough that it...
February 16, 2016 at 1:17 pm
ScottPletcher (2/16/2016)
Get rid of the dashes (-) in the date, they introduce errors (ambiguity).Use format 'YYYYMMDD [hh:mm:ss]', which is always interpreted correctly, regardless of language/date settings.
Sorry, but that is not...
February 16, 2016 at 1:10 pm
In most cases I would advocate the "new design with views that mimic the old mess" approach.
It may be more work, but you really reduce the risk significantly. And you...
February 16, 2016 at 1:00 pm
So the assumption made previously that you need to change the domain name for all logins while keeping the rest intact was indeed correct?
SQL Server is a great tool, but...
February 16, 2016 at 12:56 pm
Djj is right. The entire batch is checked before execution starts, and the insert into at the end does not match the Q2 table that exists when the batch starts.
If...
February 16, 2016 at 12:54 pm
Kazmerelda (2/16/2016)
I am getting a The conversion of a nvarchar data type to a datetime data type resulted in an out-of-range value error each time I try now, I...
February 16, 2016 at 12:48 pm
I must say that I do not fully comprehend what your problem was and how you solved it. But you did solve it, and that is in the end all...
February 16, 2016 at 12:40 pm
GilaMonster (2/16/2016)
Hugo Kornelis (2/16/2016)
Oh, I am not laughing. Not at all. I am concerned and bewildered. Mostly concerned.
Likewise. With a side of terrified that one of the buffoons might actually...
February 16, 2016 at 3:30 am
Viewing 15 posts - 811 through 825 (of 3,348 total)