Viewing 15 posts - 2,401 through 2,415 (of 3,221 total)
Terry you might want to try this:
CREATE TABLE #T
(ID INT
,FirstName VARCHAR(10)
,LastName VARCHAR(10)
,Email VARCHAR(10))
GO
INSERT INTO #T
SELECT 1, 'aaa', 'bbb', 'aa@bb' union all
SELECT 2, 'aaa', 'bbb', 'aa@bb' union all
SELECT...
October 5, 2009 at 9:52 am
Rob Goddard
I now know something concrete that was quite vague an hour ago!
stewartc-708166
It has highlighted an area that most people only had a vague appreciation for. well done and...
October 5, 2009 at 8:37 am
Read these article by Jeff Moden and I believe you will find your answer plus a lot more:
Cross Tabs and Pivots, Part 1 – Converting Rows...
October 4, 2009 at 8:47 am
Look up the DATEDIFF function in Books On Line at:
ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/udb9/html/57e0601a-9d97-4437-9be1-7efa639b39fc.htm
The GETDATE function reference is:
ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/tsqlref9/html/bebe3b65-2b3e-4c73-bf80-ff1132c680a7.htm
The following will returrn a value of 3 as today is 10/04/09
.
SELECT DATEDIFF(day, '10/01/09', GETDATE())
Of course...
October 4, 2009 at 7:53 am
For a relatively complete discussion of when checkpoints are set read this:
http://technet.microsoft.com/en-us/library/ms189573(SQL.90).aspx
October 3, 2009 at 3:48 pm
Jeff
Ron, you've made my day! I thought I was the only cranky ol' fart
Jeff your a young wipper snapper ... heck I have a son older than you!
October 3, 2009 at 12:24 pm
However, you have given me an idea for an article or whatever. "Checklist for creating a database" or something like that. I have policies on the subject, might be worthwhile...
October 3, 2009 at 12:07 pm
The original question by the OP was
Just wondering if there is a way to force SQL Server to skip checking if a table or a column of a table, which...
October 2, 2009 at 4:43 pm
Jan Van der Eecken (10/2/2009)
Is this fair use of the forums by the way?
Well we might soon know. Sent an email to the web master for SSC,...
October 2, 2009 at 4:34 pm
Garadin
These were my test conditions using Developer version of SQL Server 2008 Microsoft SQL Server Management Studio 10.0.1600.22 ((SQL_PreRelease).080709-1414 )
/
ALTER DATABASE Test
SET COMPATIBILITY_LEVEL = 100
CREATE TABLE Dbo.NonExisting
(ABC VARCHAR(10))
CREATE...
October 2, 2009 at 4:23 pm
Looking at that procedure in 2000 there is the following:
-- NOTE: THE IMPLEMENTATION (ie. using trace bit 1717) IS *VERY* LIKELY TO CHANGE,
--SO DONT EVEN *THINK* ABOUT USING THIS TRACE...
October 2, 2009 at 3:27 pm
Garadin
These will compile fine if the entire table does not exist. They will not compile if the table exists but the column you're referencing does not. It will error. Try...
October 2, 2009 at 8:32 am
david.wright-948385
Darn good idea ....
Steve Vassallo
I do disagree with your end line of:
"If everything seems to be going well, you have obviously overlooked something"
Maybe if everything is going well,...
October 2, 2009 at 8:17 am
Do not know why you would want to create an SP and not know if it would function, but yes it can be done for example:
CREATE PROCEDURE Dbo.Garbage
AS
SELECT * FROM...
October 1, 2009 at 6:47 pm
Steve Vassallo
would have to think the question if faulty in some way when close to 85% of the people answering it are getting it wrong
Can not agree with you...
October 1, 2009 at 4:25 pm
Viewing 15 posts - 2,401 through 2,415 (of 3,221 total)