No announcements
Found 1936471 threads
-
2 Votesauto-increment identity column
The ContactID is on auto increment..Answered | 3 Replies | 18771 Views | Created by BobLewiston - Tuesday, March 24, 2009 11:13 PM | Last reply by N_SQL - Thursday, April 2, 2009 11:22 AM
-
2 Votes
displaying an auto-incremented SQL identity column
>guess this means the identity column is incremented when you actually reconnect to the database and insert the new record there, rather than just add the record ...Answered | 4 Replies | 8468 Views | Created by BobLewiston - Friday, March 27, 2009 11:09 PM | Last reply by Aaron Alton - Saturday, April 4, 2009 4:40 PM -
0 Votes
Auto increment over multiple identity columns
If you want to have unique identity values across both tables, you can create identity columns with identity increment = 2 and even and odd ...Answered | 3 Replies | 9446 Views | Created by Martin Pilch - Wednesday, June 23, 2010 8:37 AM | Last reply by Martin Pilch - Wednesday, June 23, 2010 9:22 PM -
0 Votes
Primary key column auto increment
Also need to keep in mind that if you are relying on your identity column which is a surrogate key being perfectly sequential then you have a design issue.Answered | 2 Replies | 6193 Views | Created by lobuljen - Wednesday, October 1, 2014 7:20 AM | Last reply by Craig vn - Thursday, October 2, 2014 12:00 AM -
1 Votes
Auto Increment a field
any table of them can contain one auto-increment field.Answered | 8 Replies | 5698 Views | Created by zlkoh - Tuesday, July 28, 2009 3:34 AM | Last reply by Paul Svirin - Tuesday, August 4, 2009 11:59 PM -
0 Votes
Auto increment column
It sounds like you are talking about the identity property of a column.Answered | 6 Replies | 4946 Views | Created by haroon2k8 - Thursday, October 28, 2010 5:35 AM | Last reply by haroon2k8 - Thursday, October 28, 2010 6:45 AM -
2 Votes
Auto increment
Look this post (you need register in SQL Server Central, it's free): http://www.sqlservercentral.com/articles/T-SQL/61979/ It's a very interesting way to change ...Answered | 3 Replies | 8821 Views | Created by mahima - Monday, April 14, 2008 4:04 PM | Last reply by Esteban Grinberg - Monday, April 14, 2008 4:54 PM -
0 Votes
Reseting Auto-Increment
Hi You can not update directly an Identity column.Answered | 6 Replies | 1397 Views | Created by AGA Neto - Friday, August 8, 2014 3:33 PM | Last reply by Kalman Toth - Friday, August 8, 2014 9:09 PM -
2 Votes
How are SQL Server 2012 sequences different from Auto-Increment column?
In Oracle and DB2 I very seldom use identity columns.Answered | 10 Replies | 15121 Views | Created by OldEnthusiast - Saturday, April 7, 2012 5:52 PM | Last reply by ArunKumar Sharma - Monday, December 30, 2013 6:04 AM -
2 Votes
Elastic Database split-merge with Auto Identity column
The problem with IDENTITY columns that you describe is valid and there are a couple of ways to address them.Answered | 2 Replies | 1000 Views | Created by ASA Developer - Saturday, October 24, 2015 9:26 AM | Last reply by Joseph Idziorek - Wednesday, October 28, 2015 12:45 AM -
0 Votes
updating auto incremental sequence number in a column
Here is a method that will work: WITH TheCTE AS (SELECT *, -- An actual column list is prefered ...Answered | 9 Replies | 12252 Views | Created by SirIndian - Monday, November 1, 2010 12:15 PM | Last reply by Hugo Kornelis - Tuesday, November 2, 2010 9:14 AM -
2 Votes
Creating auto increment column
To truly automate it you can refer the post below, I have answered a similar question here:Answered | 2 Replies | 764 Views | Created by Harris Kristanto - Wednesday, December 28, 2016 8:16 PM | Last reply by Huzefa Mala - Thursday, December 29, 2016 10:40 AM -
2 Votes
Auto increment in asp.net
I do not know how consistent/effective will the code generated auto increments will be?Answered | 4 Replies | 4815 Views | Created by Dk6594 - Saturday, April 20, 2013 5:58 AM | Last reply by Kalman Toth - Tuesday, April 23, 2013 12:28 AM -
0 Votes
Auto Increment Column in a table
You need to do something else with the table such as INSERT or UPDATE.Answered | 5 Replies | 5144 Views | Created by Bharat Khatri - Friday, March 5, 2010 7:25 PM | Last reply by Kalman Toth - Wednesday, March 10, 2010 11:33 PM -
0 Votes
Change auto increament identity column settings
Hi Ameyjoe, We can only change auto increment seed by using DBCC CHECKIDENT('<Table name>', RESEED, <Seed starts ...Answered | 4 Replies | 1746 Views | Created by ameyjoe - Wednesday, December 5, 2012 1:20 PM | Last reply by progfun - Thursday, December 6, 2012 11:29 AM -
0 Votes
adding an auto increment date column
You can set the default value of this column to getdate().Answered | 6 Replies | 3985 Views | Created by oleolehoohoo - Wednesday, January 30, 2013 5:30 PM | Last reply by Harry Bal - Wednesday, January 30, 2013 8:34 PM -
0 Votes
how to set auto increment identity in sql azure table
Also make sure you aren't including PId in the column list in your INSERT clause.Answered | 3 Replies | 25911 Views | Created by Patrick.I - Tuesday, March 26, 2013 7:57 AM | Last reply by Pablo Waisfeld - Wednesday, January 27, 2016 4:04 PM -
0 Votes
Facing Issue When Add Auto Incremental Identity Column to Table After Importing Table and Data
This allow you to specify a value for the identity column.Answered | 5 Replies | 736 Views | Created by Sumit Majhi - Thursday, November 15, 2018 8:32 AM | Last reply by Teige Gao - Monday, November 19, 2018 6:40 AM -
1 Votes
Auto Increment Insert in Merge Syntax
I have used the row number style of auto increment ..Answered | 7 Replies | 6181 Views | Created by Priya Bange - Monday, August 4, 2014 10:44 AM | Last reply by --CELKO-- - Monday, August 4, 2014 11:28 PM -
0 Votes
auto increment id issue
Hi hemaak, if ordering is yur problem, use an ORDERBY clause - select * from tbl_name order by col_name Else, if you want to redefine the ...Answered | 3 Replies | 1453 Views | Created by emaak - Friday, January 10, 2014 4:22 PM | Last reply by Jayakumaur (JK) - Friday, January 10, 2014 4:28 PM - Items 1 to 20 of 1936471 Next ›
No announcements
