But i heard it is possible. do you have any idea ?

do you have any idea why sql server is showing master database as the default one ? why can't it shows Model or tempdb ? is there any reason ?

Is there any restrction to use sp_defaultdb ? Because i have dbo permission only.

what does the formula can do ? I am very confused.Can any experts explain me in detail ?

Jeff,

Concur.

SELECT p.*

FROM PurchaseOrders AS p

P.Posuf in (4)

Will also work. Am i correct ? Is there any difference between your code and my code ?

Visit the following URL's.

msdn2.microsoft.com/en-us/library/zefbf0t6(VS.80).aspx

msdn2.microsoft.com/en-us/library/zefbf0t6(VS.71).aspx

searchsqlserver.techtarget.com/tip/0,289483,sid87_gci1197403,00.html

You will get some idea.

Yes,Because we need to extent our query.Then it may keep on going.

is there any way to generate more than one billion row with some modification in the current code ?

Not yet. I will get back to you shortly.

Will this logic work out to update * in the star column ?

Yes,We can do it. But i don't want to add more cross join and sql queries.

My new RM asked me to provide the solution without REPLICATE function.

Initially i used REPLICATE function.But he did not want to use REPLICATE.

<> Operator perform TableScan method.

Yes i do agree.I think your query(column 0) will use TableScan instead of Index.

Yes, you are correct.

But,how to perform this one without REPLICATE function ?

Again my #1 question,

will column > ' ' eliminate NULL and BlankSpace only or something else ?