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 |
PeterG
Posting Yak Master
156 Posts |
Posted - 2002-05-02 : 18:44:08
|
I am grabbing the rowcount of sysindexes system table but it returns me a binary(8). Is there a way I can convert this so that the recordset returns me the equivalent decimal value? |
|
izaltsman
A custom title
1139 Posts |
Posted - 2002-05-02 : 19:19:34
|
You may not need to... There is a field called rows in sysindexes table, which is of datatype integer... So unless you have huge tables, that field will do until you switch to SQL2k... And in SQL2k rowcnt is of datatype bigint anyway! ---------------Strong SQL Developer wanted in the Boston area. Please e-mail if interested. |
|
|
|
|
|