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 |
|
sgondesi
Posting Yak Master
200 Posts |
 Posted - 2014-01-06 : 06:54:49
|
| Can we access an index value?-- Thanks and RegardsSrikar Reddy Gondesi,BTECH-IT 2013 Passed Out,Trainee for SQL Server Administration,Miracle Software systems, Inc. |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2014-01-06 : 07:38:37
|
| Sorry can you elaborate. WHat do you mean here by term "index value"?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/https://www.facebook.com/VmBlogs |
 |
|
|
sgondesi
Posting Yak Master
200 Posts |
Posted - 2014-01-06 : 08:02:17
|
quote:
Originally posted by visakh16
Sorry can you elaborate. WHat do you mean here by term "index value"?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/https://www.facebook.com/VmBlogs
I mean, can we access the uniquifier value which is given to a particular column value?-- Thanks and RegardsSrikar Reddy Gondesi,BTECH-IT 2013 Passed Out,Trainee for SQL Server Administration,Miracle Software systems, Inc. |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2014-01-06 : 09:45:16
|
quote:
Originally posted by sgondesi
quote:
Originally posted by visakh16
Sorry can you elaborate. WHat do you mean here by term "index value"?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/https://www.facebook.com/VmBlogs
I mean, can we access the uniquifier value which is given to a particular column value?-- Thanks and RegardsSrikar Reddy Gondesi,BTECH-IT 2013 Passed Out,Trainee for SQL Server Administration,Miracle Software systems, Inc.
Are you asking about internal RowID generated in cases where you create non clustered indexes on a heap?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/https://www.facebook.com/VmBlogs |
|
|
|
sgondesi
Posting Yak Master
200 Posts |
Posted - 2014-01-06 : 10:28:50
|
| If there is an index on a column which has duplicate columns, then sql server will assign a uniquifier column to that column right?i.e, a unique id which refers to each value of the column.can we access this unique id or uniquifier?-- Thanks and RegardsSrikar Reddy Gondesi,BTECH-IT 2013 Passed Out,Trainee for SQL Server Administration,Miracle Software systems, Inc. |
|
|
|
|
|
|
|
|
Accessing Index values