| 摘要: |
| 以MS SQL Server 2000为例分析几种常见流水号生成方法及其不足,针对这些不足给出Int、Char数据类型流水号的解决方案。这些方案具有并发性好,不会引起阻塞,计算效率高等特点。 |
| 关键词: 流水号 MS SQL Server 事务 IDENTITY uniqueidentifier |
| DOI： |
| 投稿时间：2006-09-14 |
| 基金项目: |
|
| A Solution for Problems in Serial Numbers Generation in MS SQL Server 2000 |
|
DI Ying-yue
|
| (Guangxi Liugong Machinery Co., Liuzhou, Guangxi, 545007, China) |
| Abstract: |
| The generation ways of serial numbers in MS SQL Server 2000 are discussed.A solution for the data type serial numbers of Int,Char are presented in order to solve the shortcomings.The solution reveals well concurrent,high efficiency and no jams. |
| Key words: serial numbers MS SQL Server transaction IDENTITY uniqueidentifier |
