Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
goodsolution
Starting Member
38 Posts |
 Posted - 2009-05-19 : 13:05:08
|
| Hi all, Case 1: If i want to insert a new record on clustered column, where the record is going to insert (will it insert in-between or will it append at las?)Case 2:if i want to insert a new record on non-clustered column, where the record is going to insert? -Thanks |
|
|
Lamprey
Master Smack Fu Yak Hacker
4614 Posts |
Posted - 2009-05-19 : 13:06:38
|
| Depends on your data. |
 |
|
|
goodsolution
Starting Member
38 Posts |
Posted - 2009-05-19 : 13:10:09
|
quote:
Originally posted by Lamprey
Depends on your data.
for example, i have 100 records in a table, and col1 is having clustered index, so internally it will have some index on it right, now i want to insert 101th record, so how system will adjust those numbers and insert, same for non-clustered index as well-Thanks |
|
|
|
DonAtWork
Master Smack Fu Yak Hacker
2167 Posts |
Posted - 2009-05-19 : 13:23:05
|
| Your question is still opaque. Follow the first link in my signature and restate your question with the data that we will need to answer it.[Signature]For fast help, follow this link:http://weblogs.sqlteam.com/brettk/archive/2005/05/25.aspxLearn SQL or How to sell Used CarsFor ultra basic questions, follow these links.http://www.sql-tutorial.net/ http://www.firstsql.com/tutor.htm http://www.w3schools.com/sql/default.asp |
|
|
|
|
|
|
insert record on clustered and non-clustered colum