If possible plzz provide some more material on SQL2k...
Thanks
Vijay
Type: Posts; User: vavasudevan; Keyword(s):
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...