Search:

If possible plzz provide some more material on SQL2k...

Thanks
Vijay

Hi aarusa,
There are 2 kinds of Indexes, Clustered index and Non-Clustered Index.

Clustered index
Only one can create on One table
This'll get create when ever u were creating...

Hi aarusa,

this query'll give u list of all userdefined tables,
--to list all tables
select distinct ist.* from information_schema.tables as ist
inner join sysobjects as so on...

Hi Aaarusa,
u were using MS-SQL 2000 i think..
U told as u created one table with 2 column, just

Execute this Query for Making existing Column from NULL to NOT NULL

Alter table...

Hi bvani,
Inner Join'll give u matching records and Right join'll give u all records from one tables and non-matching record on left table'l come as NULL.. in Simply, Right join'l give u...