|
I was thinking
UPDATE User SET Clue=@Clue WHERE Clue IS NULL
|
|
|
|
|
that one would throw a SystemOverloadedException
Luc Pattyn [Forum Guidelines] [My Articles] Nil Volentibus Arduum
Please use <PRE> tags for code snippets, they preserve indentation, improve readability, and make me actually look at the code.
|
|
|
|
|
Amazing way to answer Luc..
You stole the show...
|
|
|
|
|
please let me know the difference b/w clustered and non-clustered index... in sQL server in
simple language....eventhough i searched in google im not clear abt the exact diff
and in which scenario use these indexes...(clustered and non clustered)
|
|
|
|
|
Basically the main difference is that both are B-tree indexes but clustered index causes the data in the table to be sorted based on the indexed columns. This is why a single table cannot have multiple clustered indexes. Nonclustered index is like an index at the end of a book. Entries are sorted and there are pointers (page numbers in book) referencing the actual place for the data.
Have a look at this: Nonclustered Index Structures
[^]
Regards,
mika
|
|
|
|
|
Mika Wendelius wrote: data in the table to be sorted
Don't you mean sorted and STORED using the clustered index, I think that is the most relevant part.
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
Yap, exactly. I was thinking the table as a permanent object but it's a good idea to clearly point that out. Thanks.
|
|
|
|
|
It's been a while since we saw you here, welcome back.
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
Thank you Mycroft
Yes, it's been a really busy couple of years.
I noticed that you've been a 2010 MVP . Congratulations (sorry that this comes so late!)
|
|
|
|
|
Guys I have joke;
who know what is the opposite of 'Safe'?
Help people,so poeple can help you.
|
|
|
|
|
Walking down Balham High Street at 2.30 in the morning in a pair of slingbacks?
------------------------------------
I will never again mention that I was the poster of the One Millionth Lounge Post, nor that it was complete drivel. Dalek Dave
CCC League Table Link
CCC Link[ ^]
|
|
|
|
|
|
Not if he overruns it (other than first).
|
|
|
|
|
Posting messages like this in the Database forum.
Software rusts. Simon Stephenson, ca 1994.
|
|
|
|
|
Makes perfect sence. A joke Database
He wanted to be sure that the joke would be in the database
All the best,
Dan
|
|
|
|
|
|
Sir, you shouldn't keep serious all the time. a joke after a serious discussion wont kill any body
100
Help people,so poeple can help you.
|
|
|
|
|
|
Ali Al Omairi(Abu AlHassan) wrote: Guys I have joke;
Well take it to the lounge where it will get treated properly.
I must get a clever new signature for 2011.
|
|
|
|
|
thank you for doing this, Alen.
Help people,so poeple can help you.
|
|
|
|
|
Ali Al Omairi(Abu AlHassan) wrote: Guys I have joke;
who know what is the opposite of 'Safe'?
first of all Is it safe?[^] posting jokes in this forum & also asking a question about that
|
|
|
|
|
Sir, what is your problem with that?
making a joke in the end of a working day is also necessary.
100
Help people,so poeple can help you.
|
|
|
|
|
Ali Al Omairi(Abu AlHassan) wrote: Sir, what is your problem with that?
Nothing dude, but what about the lounge where many people there....also it's not a right place to post jokes. That's it.
Anyway come to lounge if you have interesting things to post. Cheers.
|
|
|
|
|
thank you for doing this, Alen.
Help people,so poeple can help you.
|
|
|
|
|
I have a SQL database column that was orignally declared with a not null constraint. (using alter table add column) Turns out, the column needs to be nullable to keep from breaking legacy apps. Should be easy, use alter statement to change to all not null, right? Not. This throws an error complaining that "The object 'xxxx' is dependent on column 'columnName'". So I looked it up in SSMS and there it is under constraints with what appears to be a generated name. This is a distributed application, so I am thinking that the constraint name is not guaranteed to be the same. OK then, just use ADOX or OpenSchema to get the offending constraint name. After googling and trying different approaches for about an hour, and not finding anything that worked, (and getting pretty disgusted in the process) it ocurred to me that the name of the constraint is reported back in the error description, always between the first two quotes! It was right there the whole time! Extracted the name, ran the alter table drop constraint statement, then was able to alter the column to not null. This approach should work regardless of the locale.
|
|
|
|