Viewing 15 posts - 7,846 through 7,860 (of 26,490 total)
david.ostrander (4/24/2013)
I have a column in my View script that I convert to varchar(10) and want to convert it back to a date for the output to be...
April 24, 2013 at 10:27 am
apat (4/24/2013)
Lynn Pettis (4/24/2013)
apat (4/24/2013)
I...
April 24, 2013 at 10:00 am
Phil Parkin (4/24/2013)
A better-performing solution may...
April 24, 2013 at 9:53 am
apat (4/24/2013)
I do not have...
April 24, 2013 at 9:49 am
Can you post your code that actually builds and runs these queries? Also, you may not need two dynamic queries, one to get the count and a second to...
April 24, 2013 at 9:45 am
Please remember that ISNUMERIC(somevalue) = 1 means that the value in somevalue can be converted to one of the numeric datatypes, but that it may still fail depending on the...
April 24, 2013 at 9:37 am
I really hope you are not testing failover in your production environment. This is something that should first be done in a development then QA environment incase you encounter...
April 24, 2013 at 9:18 am
dwain.c (4/24/2013)
Lynn Pettis (4/23/2013)
L' Eomot Inversé (4/23/2013)
Jeff Moden (4/23/2013)
April 24, 2013 at 7:05 am
L' Eomot Inversé (4/23/2013)
Jeff Moden (4/23/2013)
Heh... to complicated. Just take Jason.A to work and let him entertain the kids with stories of GPO's as if they were dragons. 😛
That's...
April 23, 2013 at 7:44 pm
fadewumi (4/23/2013)
why is differntial backup is so important
Please post new questions to a new thread. This question has nothing to do with this thread.
And, fyi, a differential...
April 23, 2013 at 5:04 pm
ScottPletcher (4/23/2013)
SQL Server does not have an equivalent to that function or functionality :-(.
No, but it is easy to create:
set ansi_padding on;
go
create function dbo.SubstringIndex(
@SourceString varchar(8000),
...
April 23, 2013 at 5:00 pm
edward_hall76 (4/23/2013)
I get this error Operand data type text is invalid for add operatorthe PhoneNumber is in the Names table and the sms is in the Carriers table
Okay, now we...
April 23, 2013 at 3:29 pm
edward_hall76 (4/23/2013)
I have phonenumber and sms set as Text. The PhoneNumber is in the Names table and SMS is in the Carriers table.
Still haven't answered the question, what is the...
April 23, 2013 at 3:26 pm
Eugene Davydov (4/23/2013)
GilaMonster (4/23/2013)
when you have a lot of fine-grained locks in transaction you'll get a problem with accessing data? 🙂
No. If there are too many locks, SQL will just...
April 23, 2013 at 3:18 pm
Here is the problem, we can't see what you see. This means with as little information as you provided, all we can do is take shots in the dark...
April 23, 2013 at 2:45 pm
Viewing 15 posts - 7,846 through 7,860 (of 26,490 total)