Viewing 15 posts - 2,011 through 2,025 (of 3,221 total)
WayneS
I'd suggest on the web form, having the submitter actually select the sql version that it's applicable for via checkboxes
- take this to be a sort of select...
March 22, 2010 at 12:21 pm
I would ask for comments (solicit) from those on the thread on the following suggestion for increasing the reception and improvement of the Question Of the Day (QOD).
http://www.sqlservercentral.com/Forums/Topic887478-4-1.aspx
It...
March 22, 2010 at 10:48 am
chandrasekaran.ganapathy
When it will be deleted automatically?
From previous posting in this forum
Local temporary tables are deleted after the user disconnects from the instance of SQL Server. Global temporary...
March 22, 2010 at 6:52 am
Start reading here:
http://msdn.microsoft.com/en-us/library/ms186986.aspx
There are two types of temporary tables: local and global. Local temporary tables are visible only to their creators during the same connection to an instance of SQL...
March 22, 2010 at 6:21 am
Tom.Thomson Posted Today @ 7:47 PM
The ability to fix..with the click of a button: shouldn't that be qualified with "sometimes"? Without the qualification, does it mean "always"...
March 20, 2010 at 6:15 pm
This code works in SQL 2000
SELECT 'Index Name' = i.name, OBJECT_NAME(i.id) AS 'Table Name',
Case Indid
WHEN 1 THEN 'Clustered'
...
March 19, 2010 at 4:24 pm
Following GSquared's advice, and by some good fortune a major article in today's SSC (3/19/2010) Read this article and see if it helps.
http://www.databasejournal.com/features/mssql/article.php/3864246/SSIS-Packages---the-Simplest-Way-to-Create-Them.htm
Not let me...
March 19, 2010 at 7:53 am
Attach your jpg file ... scroll to bottom of this window, in the "Post Options" frame. click on the button labeled "Edit Attachments" browse to whatever drive on your...
March 18, 2010 at 4:41 pm
By an "array", do you mean a list of items or a true multidimensional array?
March 18, 2010 at 8:20 am
GRE (Gethyn Ellis)
Again many thanks .... now I have learned more and I hope the person asking the original question has also learned something new.
You assistance in testing is...
March 16, 2010 at 6:05 pm
GRE (Gethyn Ellis)
Thanks for the feed back. Edited my posting to add 2 additional scripts would you be so kind as to give them a test.
Again I thank...
March 16, 2010 at 5:48 pm
Refer to:
Index Related Dynamic Management Views and Functions (Transact-SQL)
at:
http://technet.microsoft.com/en-us/library/ms187974.aspx
This code works in 2005, but I have not tested in 2008 ... give it a try if it does you have...
March 16, 2010 at 5:24 pm
monzulu
--To make you data available for testing
CREATE TABLE #T(OrderDate DATETIME, Quantity INT )
INSERT INTO #T
SELECT '1/1/2009', 1 UNION ALL
SELECT '2/1/2009', 3 UNION ALL
SELECT '5/1/2009', 7 UNION ALL
SELECT '9/1/2009',...
March 15, 2010 at 1:37 pm
Lynn Pettis (3/15/2010)
Grant Fritchey (3/15/2010)
Lynn Pettis (3/15/2010)
Grant Fritchey (3/15/2010)
GSquared (3/15/2010)
Grant Fritchey (3/15/2010)
Oh cool, tossed under another bus. Thanks Alvin.
What year? (My birthday was yesterday, so I'm curious as to...
March 15, 2010 at 11:00 am
To alter a date so you have no time elements this will work
declare @date Char(10)
set @date = convert(char(10),getdate(),101)
To keep it as DATETIME with zero time values use this:
@midnight DATETIME
SELECT @midnight...
March 14, 2010 at 10:15 am
Viewing 15 posts - 2,011 through 2,025 (of 3,221 total)