Thanks Gila and Jeff:)

Basically why i am asking some known and some available in books online is, They will explain with some good example, I agreed , but If i...

I am asking about DBO level securities.

Experts,

Any Input ?

Can you give me the URL ?

Jeff,

It gives us every row in the first table, joined with every row in the second table.

say for example,we have two tables called TableA and TableB.

Table A

A

B

Table B

C

D

Cartesian Product...

Gila,

Suppose if i have a big table how should i avoid <> operator ?

I am using sql2000. Both gave me the same output.

Ok Joe, I agreed your point.

My question is is there any techincal difference between client cursor and server cursor ?

If yes , how to write server side cursor ? do...

Any output ?

Please try to understand my question !

My Question is:

I have two tables called Table A and Table B.

Table A -> primary key is created by using sp_primarykey TableA,Eno

Table B ->...

Thanks Joe ! :)Suppose if anybody asked the above question then i will say 'No' confidently.

Thanks Jeff and Matt !:) Now I am very clear about WrokTable and TempTable 😎

Jeff,

Before executing this code blindly , can you explain me the following sql query ?

-------------------------------------------

SELECT TOP 1000000 RowNum ...

Thanks.

URL : http://www.sql-server-performance.com/tips/t_sql_where_p1.aspx

Can you give me the description about p.s & p.p.s ?