Click here to Skip to main content
Click here to Skip to main content
Search within:



 
Comments & Discussions

Multiple users doing some operations on single table, missing few records in the table

By , 13 Nov 2012
 

Revisions


  

Compare Revision Minor Date Status Editor
1 No 14 Nov '12 - 0:47 Available Shanalal Kasim

License

This article, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

About the Author

 Shanalal Kasim
Team Leader
India India
Member
No Biography provided

About Article
In change your sql like belowInsert into student (RefNumber ) values ((Select count(RefNumber)+1 from student))Or Set IdentityRefer: http://msdn.microsoft.com/en-us/library/aa933196(v=sql.80).aspx[^]
Type Answer
Licence CPOL
First Posted 13 Nov 2012
Views 0
Bookmarked 0 times
SQLSQL-Server
SqlServer
Top News

Math Primers for Programmers

Get the Insider News free each morning.
Related Videos
Styling Tables and Lists
HTML 5 - 0602 Table Headers
SQL Tuning Tutorial - Understanding a Database Execution Plan (1)
Universal Database Admin for ASP.NET and SQL Server (Reloaded)
Audit Trail Generator for Microsoft SQL
Quick Overview: Temporary Tables in SQL Server 2005
AJAX based CRUD tables using ASP.NET MVC 3 and jTable jQuery plug-in
Traceability in Layered Architecture: A Roadmap
FileDb - A Simple NoSql Database for Silverlight, Windows Phone and .NET
jQuery DataTables and ASP.NET MVC Integration - Part I
Speeding up database access - Part 3: Fixing missing indexes
SQL Joins
A Model to Represent Directed Acyclic Graphs (DAG) on SQL Databases
Rating Demystified: Ajax Way, Amazon Way*
Introduction to the Entity Framework
Undelete a file in NTFS
Record Versioning with SQL Server
Merge Statement in SQL Server 2008
Understanding Table Joins using SQL
Top 10 steps to optimize data access in SQL Server: Part II (Re-factor TSQL and apply best practices)
Composable DML and Merge Statement in SQL Server 2008
Top 10 steps to optimize data access in SQL Server: Part III (Apply advanced indexing and denormalization)
An Introduction to Entity Framework for Absolute Beginners
Permalink | Advertise | Privacy | Mobile
Web02 | 2.6.130516.1 | Last Updated 14 Nov 2012
Article Copyright 2012 by Shanalal Kasim
Everything else Copyright © CodeProject, 1999-2013
Terms of Use
Layout: fixed | fluid