I too Choose "It Depends" Answer and got it wrong

INSERT INTO ta1_Filter(CODE,CENTER)

SELECT CODE,CENTER from [dbo].[Main]

WHERE CENTER IS NOT Null

AND CODE like...

@OLD Hand: My Only intention, was to post a easy question(which , according to u was a dumb question),so that everyone can answer ...

@OLD Hand : If its a dumb question, then why are you wasting your precious time , in the discussion

This was Question Direct from BOL, I have used same sentence as in BOL, Do you still think, its a grammer mistake.

Sir,

There Were People Who Selected, "None Of the above" Option.

Thinking, putting third option was a joke, is a joke itself.(':w00t:');

At least I Tried !!

Can you Specify what kind of Result You are exactly looking?

Paul Randal - Has Provided a very wonderful detail explanation of shrinking a database/File and its affect.

http://technet.microsoft.com/en-us/magazine/ff808322.aspx

and

http://www.sqlskills.com/BLOGS/PAUL/category/Shrink.aspx

If You have say table "Employee" and column Emp_Name(that contains , NULL values)

Then.

Example:

Update Employee

SET Emp_Name = ISNULL(Emp_Name , ' ')

where <condition>.....................(If required, or all wherever there are NULL value...

I Enjoy "Summer Fridays" and "Flexible Schedule" at the place were i am working now.