How do I reset an increment identity's starting value in SQL Server
I would like to have a nice template for doing this in development. ...
identity
In SQL Server is it possible to get "id" of a record when Insert is executed?
In SQL Server 2005 I have an "id" field in a table that has the "Is Identity" property set to 'Yes'. So, when an Insert is executed on that table the "id" gets set automatically to the next incrementing integer. Is there an easy way when the Insert is executed to get what the "id" was set to without having to do a Select statement right ...
Primary key from inserted row jdbc?
Is there a cross database platform way to get the primary key of the record you have just inserted? I noted that this answer says that you can get it by Calling SELECT LAST_INSERT_ID() and I think that you can call SELECT @@IDENTITY AS 'Identity'; is there a common way to do this accross databases in jdbc? If not how would you suggest ...
Question about skipping IDs in an identity column in MSSQL...
Say I have an MSSQL table with two columns: an int ID column that's the identity column and some other datetime or whatever column. Say the table has 10 records with IDs 1-10. Now I delete the record with ID = 5. Are there any scenarios where another record will "fill-in" that missing ID? I.e. when would a record be inserted and giv...
Database-wide equivalent of SET IDENTITY_INSERT OFF
In my eternal saga to insert 1.4 million rows of data from a SQL script, I've written a basic WinForms app that takes each line of the script and executes it individually. However, because the original script contained SET IDENTITY_INSERT [Table] OFF and SET is a session-wide command, this setting is getting lost on every SQL call, m...
What could cause an IDENTITY column to become corrupted?
I had an unusual problem yesterday where I was suddenly unable to insert records into a table with an identity column. A simple insert like this: INSERT INTO MyTable (Column1, Column2) VALUES ('text', 236764) Started throwing a primary key constraint violation. I ran DBCC CHECKIDENT on the table, and realized that SQL Server had stop...
NHibernate mapping identity to a cloumn without a generator
Hi, Can I map the identity of an entity to a column whose values are not auto-generated (but still unique)? If so, what should I put in the xml identity/generator tag? Thanks. ...
Informix: how to get an id of the last inserted record
What's the most efficient way of getting the value of the SERIAL column after the INSERT statement? I.e. I am looking for a way to replicate @@IDENTITY or SCOPE_IDENTITY functionality of MS SQL ...
Bulk Translation Of Table Contents
I'm currently performing a migration operation from a legacy database. I need to perform migration of millions of originating rows, breaking the original content apart into multiple destination parent / child rows. As it's not a simple 1 to 1 migration and the the resulting rows are parent / children row based on identity generated key...
What happen in SQL 2005 when it run out of number for an autonumber column?
What happen when SQL Server 2005 happen to reach the maximum for an IDENTITY column? Does it start from the beginning and start refilling the gap? What is the behavior of SQL Server 2005 when it happen? ...
How do I add the identity property to an existing column in SQL Server
In SQL Server (in my case, 2005) how can I add the identity property to an existing table coulumn using t-sql? something like: alter table tblFoo alter column bar identity(1,1) ...
How to get the next identity number used in SQL 2005 and ASP?
I was previously getting the next available autonumber used in Access by doing a simple query like so: SELECT RecordNumber, Info FROM myTABLE WHERE 0=1 This way I could create a variable to hold the currentRecord and it will use the same autonumber that Access was going to use when I was updating the row Example rs.AddNew currentRec...
Passing the original caller in WCF
We currently have a setup like this: lan\john lan\application1 lan\appService1 lan\appService2 client ------> website ----------> WCF Service1 ------> WCF Service2 So each website/service runs as a different identity account that is setup in active directory. Security checks are based on the identity of the immediate ca...
Classic ASP getting SCOPE_IDENTITY() Value from SQL2005
I can't figure out how to get the SCOPE_IDENTITY() back to my variables from an SQL2005 Store Procedure. My sSQL String: sSQL = "EXEC [sp_NewClaim] " & Chr(34) & ClaimNumber & Chr(34) & ", " & Request.Cookies("UserID") & ", " & Request.Cookies("MasterID") & ", " & Chr(34) & strRestaurante & Chr(34) & ", " & Chr(34) & Fecha & Chr(34) &...
Python "is" operator behaves unexpectedly with integers
Why does the following behave unexpectedly in Python? >>> a = 256 >>> b = 256 >>> a is b True # this is an expected result >>> a = 257 >>> b = 257 >>> a is b False # what happened here? why is this False? >>> 257 is 257 True # yet the literal numbers compare properly I am using Python 2.5.2. Trying some di...
Any sites out there using CardSpace?
I'm interested to know if there's any sites out there that has implemented CardSpace as an alternative authentication. I certainly like to see how different it is from, say, using OpenID. ...
Is there a way to tell whether two COM interface references point at the same instance?
Given two interface references obtained from different sources. Is there a programmatic way to tell whether they're implemented by the same instance? A simple equality check of the interface references always fails. EDIT: Large parts of the original question, which turned out to be an independent problem have now been moved to a new ...
How do I reliably tell that two Inspector references point to the same inspector instance?
[continued from Is there a way to tell whether two COM interface references point at the same instance?] I've got references to Inspector objects from two different sources and need to be able to tell which item from one source corresponds to which item from the other source. However, none of the approaches I have been able to come up w...
How do you find the users name/Identity in C#
I need to programatically find the users name using C#. Specifically, I want to get the system/network user attached to the current process. I'm writing a web application that uses windows integrated security. ...
Javascript === vs == : Does it matter which "equal" operator I use?
I'm using JSLint to go through some horrific JavaScript at work and it's returning a huge number of suggestions to replace == with === when doing things like comparing 'idSele_UNVEHtype.value.length == 0' inside of an if statement. I'm basically wondering if there is a performance benefit to replacing == with ===. Any performance improv...