SQL Server database programming

Hi I always thought if I used a rowlock hint during an update it would only lock the row. But the system still locks the table with an IX extent lock, so no other updates to any other row from a different connection can be completed unless ...

First a little history: We have a Pentium II server running SQL 7.0.  The SQL has a database that our users connect to using a client front end app that was created by a former programmer in our office.  The file server name in the beginning was ...

i have a counter in my table that contains the next sequence number for line items in my application (i know about identity columns.... i can't use it in this case). anyway,  i want to write three stored procedures.  one (a select ...

Hi, I'm using VB6 and I want to know which Column in the recordset is the Identity Column (if any). I've a SQL Server 2000 table. It has 5 colums, the first one is the Identity Column. Now I want to recognize this column in VB6 using ADO 2.8. I used the ...

Lets say I have the following table. --------------------------------------------- KEY             |     Value --------------------------------------------- 1000                   1 ...

The following Microsoft article says that use of Orderby in views is now ignored in SQL2005. [link] There seems to be a work around: [link] ...