| Author: Mayura Sangeene 03 Nov 2009 | Member Level: Bronze | Rating:  Points: 2 |
Using " Select * ", but can select All the Columns,but if u want to select some specific columns then write "Select <ColumnName1>, <ColumnName2>,...."
A table can have ONLY ONE primary key.
However this primary key can be a compound primary key comprised of more than ONE field/column.
On the Contrary A table can have more than 1 unique keys,It can be NULL
Regards
Mayura Sangeene
|
| Author: greeny_1984 03 Nov 2009 | Member Level: Diamond | Rating: Points: 2 |
Hi,
You can select all columns in a table using select statement.
There is only one primary key per table and we can have many
unique keys in a table.
Regards,
Greeny_1984
Rate this Response[Excellent/Good/Poor]
FRESHERS check this link
Need help from me join here
|
| Author: atulpatel 03 Nov 2009 | Member Level: Gold | Rating: Points: 2 |
Hi,
SQL Server 2005 can have 1,024 columns per table. So you can access upto 1024 columns using SELECT Statement.
Only one Primary key can be created per table.
More than one Unique key can be created on the table. Exceed Limit will be nos of columns in the table
Using Clustered Constraint, Data is stored in order physically. Primary Key,Unique Key can be Clustered Index.
Thanks,
Atul
|
| Author: Shameer 03 Nov 2009 | Member Level: Silver | Rating: Points: 2 |
Only one primary key can be created for one table
|
| Author: sudha 12 Nov 2009 | Member Level: Silver | Rating: Points: 2 |
Hi,
The table must contain only one primary key. But it can have more than one unique key. We can select no of columns in the table using SELECT statement.
|
| Author: sriram 23 Nov 2009 | Member Level: Bronze | Rating: Points: 2 |
u can select Any Number of Columns in sql server Query.
Each table can have only one primay key possible .
Primary key is defaule clusteres Index Constraint..
SriramRamaswamy
|