Viewing 15 posts - 40,636 through 40,650 (of 49,571 total)
tony (3/4/2009)
CREATE PROCEDURE UPDATE_TABLE_COUNT @NAME VARCHAR, @COUNT INT
Just to explain why. If you define a varchar (or char, nchar, nvarchar, binary, varbinary) without giving a length parameter, the default length...
March 4, 2009 at 6:18 am
Mangal Pardeshi (3/4/2009)
March 4, 2009 at 6:15 am
saravanantvr1984 (3/4/2009)
Hi dear all,If I give one date like '2008-03-04' i need the result next month last day or date
Not quite sure I understand. Do you need the last day...
March 4, 2009 at 6:11 am
Grant Fritchey (3/4/2009)
He may as well be quoting from my posts because I'm "guilty" of all the "crimes" he listed.
Likewise, most of them very recently
But hey, don't take it...
March 4, 2009 at 6:05 am
Like Lynn, I have no problem with the idea of an "Answered post" It is something lacking here. I do have a small problem with this though:
I followed some of...
March 4, 2009 at 1:28 am
Lynn Pettis (3/4/2009)
You know, I don't mind helping him, but there are times I really have to wonder how he got to where he is.
I just don't have the...
March 4, 2009 at 1:20 am
Can you post the table definitions, index definitions and execution plan (saved as a.sqlplan file, zipped and attached) please?
March 4, 2009 at 1:10 am
Jeff Moden (3/4/2009)
Heh... I shouldn't post so late at night... I forgot the bloody spaces. :hehe:
Howcanyouforgetthespaces?
March 4, 2009 at 1:04 am
Lynn Pettis (3/4/2009)
And he is supposedly a Senior Software Engineer with a Masters in Computer Application and wants to pursue a Phd?
Our friend again? All yours, I'm not touching his...
March 4, 2009 at 1:03 am
Mangal Pardeshi (3/4/2009)
March 4, 2009 at 12:53 am
Yup, list all the column names (as you've done in your example)
If you don't want to type, and I don't blame you, then there's a quick way. Expand out object...
March 4, 2009 at 12:40 am
one (3/3/2009)
Why all this worry about having the clustered index unique? 🙂
A clustered index is always unique. The only question is do you make it unique, or does SQL make...
March 3, 2009 at 1:06 pm
Paul Randal (3/3/2009)
Not you Gail, dmoldovan.
Yup. I realised that. Just noticed that he'd misquoted me and wanted to set the record straight.
March 3, 2009 at 12:38 pm
sqlcentral (3/3/2009)
The level field isn't unique across all rows, only across rows with the entry and group ids identical.
Then try this
SELECT * FROM YourTable OuterTable WHERE EXISTS (
...
March 3, 2009 at 12:15 pm
Viewing 15 posts - 40,636 through 40,650 (of 49,571 total)