No. If a table have primary key column automatically it is
clustered index. if a table have other than primary key
it have non clustered index. so answer of the question is it
doesn't support non clustered index in the primary key column
No, its not possible to hving Primary key with Non Clusterd
Index, because whenever we have to make a column as Primary
Key, it will create a Clusterd Index on that Column
automatically, it is due to the concept of paging, thats
why we can have only 1 primay key and 1 clusterd index per
Table...Enjoy :-)
Primary cannot be a non clustered index because when you
are creating primary key on a column then by defualt
cluster index will created on that column.
No, its not possible to hving Primary key with Non Clusterd
Index, because whenever we have to make a column as Primary
Key, it will create a Clusterd Index on that Column
automatically, it is due to the concept of paging, thats
why we can have only 1 primay key and 1 clusterd index per
Table...Enjoy :-)
Primary key is also known as clusterd index which is
physical structure .And noncluster index is logical
structure .
therefore Primary key cant be a nonclustered index. and
when we are creating primary key on a table system
understands it as creation of clustered index.
this is the reason one table can have one primary key
Yes it is possible that a primary key can be non clustered
create table abc(eid int PRIMARY KEY
NONCLUSTERED,ename varchar(50),vid int)
create clustered index abc_clustered on abc (vid)
now if you will check the index on eid cloumne it will be
unique and vid will have a clustered index.
Give it a try if you don't belive......
select the 3rd maximum salary from sql server database if 4
(just an example In practically I may not know the exact
situation) of the highest salaries are equal.
I have a website that allows customers to browse and place
orders for certain products.
I have 2 tables; Customers and Orders. The Customers table
holds the customer records and the Orders table
holds the orders placed by the customer. Both tables are
tied based on the field Cust_ID.
Example of the data is shown below:
Cust_ID Cust_Name Cust_ID Product Amount Order_Date
1001 John Tan 1001 P-5211 $120.00 2/13/2006
1002 Michael Wong 1001 K-1428 $88.90 1/11/2006
1003 Mary Cheong 1003 C-0923 $82.50 1/27/2006
1004 Ahmad Suffian 1003 K-1428 $88.90 2/2/2006
Write a single SQL statement that extracts all purchase
records with the following criteria:
1. Customer names starting with “M” only.
2. Orders placed within the current month only.
3. Amount does not exceed $100.00
The list must be sorted by order date with the latest order
showing on top.