Lab Sql

I'm trying to insert a row and get back the new row's identity with something like this: IN… Read more Inserting A Row And Retrieving Identity Of New Row In Sql Server Ce

I'm getting this error in puTTY. Not sure why, looks right to me ... psql:pierre.sql:10: ERROR:… Read more Error With Auto_increment While Conneted To Postgres Via Psql And Putty

I have a object that contains data from a DB. The object has a ID, which in the DB is auto incremen… Read more Sqlite.net Output Parameter

Is it possible to reuse an identity field value after deleting rows in SQL Server 2008 Express? Her… Read more Reuse Identity Value After Deleting Rows

I have a database table which has ~ 40 000 000 rows. I want to add an identity column to this table… Read more How To Add An Identity Column To An Existing Database Table Which Has Large Number Of Rows

I am making an SQL database that stores contacts. I want to be able to delete contacts, and the cor… Read more Reset Identity Column In Sql Server

Here is a minimal repro example. Database: CREATE TABLE temp (x int IDENTITY(1, 1), y int); Code (… Read more Server-side Forward-only Cursor Breaks @@identity

I want to generate a custom identity column related to type of product. Can this query guaranty the… Read more Sql Server Custom Identity Column