Viewing 15 posts - 436 through 450 (of 3,221 total)
Cliff Jones (5/31/2012)
EL Jerry (5/31/2012)
Thank you for the question, Ron.I also got the right answers by elimination of the first 2 false statements.
"El" Jerry.
+1 but like Tom I was wondering...
May 31, 2012 at 3:32 pm
L' Eomot Inversé (5/30/2012)
May 30, 2012 at 5:21 am
Like all SQL questions the answer is "It depends". I suggest you do a Google search on "sql server upgrade advisor". Download the available software, run it .......
May 28, 2012 at 8:05 am
Good question, help me re-affirm something I thought I knew and as it turned out I did know it.....
May 27, 2012 at 7:49 am
Without table definition(s), some sample data and the desired results when using the sample data, providing you with a tested answer is next to impossible.
Please, please post your table definition(s),...
May 20, 2012 at 6:00 pm
Here is some info with examples (sample code) of what I think you want to accomplish.
May 20, 2012 at 7:39 am
Thanks for a GREAT question .. glad I answered it after my 2nd cup of coffee .....
May 20, 2012 at 7:27 am
Now I did a little testing with the BIGINT value to deteremine the maximum BIGINT value that could be converted to DATETIME as follows:
DECLARE @b-2 BIGINT
SET @b-2 = 2958457 ...
May 18, 2012 at 2:57 pm
Had to reduce the value of you BIGINT (other wise - overflow error)
but here goes
DECLARE @B BIGINT
SET @B = 922337
SELECT convert(VARCHAR(20),CAST(@B AS DATETIME),101)
Result: 04/10/4425
May 18, 2012 at 1:37 pm
Here is a few to get you started.
DECLARE @d1 VARCHAR(20)
DECLARE @d2 NVARCHAR(20)
DECLARE @d3 VARCHAR(20)
DECLARE @d4 NVARCHAR(20)
DECLARE @d5 VARCHAR(20)
SET @d1 = '2004-06-23'
SET @d2 = '2004-06-23'
SET @d3 = '06/14/2011'
SET @d4 = '06/14/2011'
SET...
May 18, 2012 at 1:25 pm
Yup time to party .. just got email notification that my seventy-first (71st) accepted QOD is scheduled for mid June (of this year).
SO PARTY TIME ! ! !
May 18, 2012 at 12:16 pm
Hugo Kornelis (5/18/2012)
bitbucket-25253 (5/17/2012)
May 18, 2012 at 7:16 am
Well my answer was declared to be incorrect, so went to read the explanation, following the link given ..... nada / nothing / not a word to support what is...
May 17, 2012 at 8:39 pm
Use the Depreciated Feature Object in sQL 2008R2
Here is a link to describe its use and limitations
http://technet.microsoft.com/en-us/library/bb510662(v=sql.105).aspx
May 17, 2012 at 10:04 am
bitbucket-25253 (5/16/2012)
CREATE PROCEDURE [dbo].[FindWordsInaSP_5K]
@Watchword varchar(50)
AS
SELECT distinct
'type' = case type
when 'FN' then 'Scalar function'...
May 16, 2012 at 4:06 pm
Viewing 15 posts - 436 through 450 (of 3,221 total)