使用VB.NET/C#在MS SQL Server中进行研究 [英] Reserial in MS SQL Server using VB.NET/C#
本文介绍了使用VB.NET/C#在MS SQL Server中进行研究的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
假设我有一张这样的桌子..
---------------------- --------------
ID(PK)| SLNO |其他栏目
------------------------------------
1 | 1 |数据1
2 | 2 |数据2
3 | 3 |数据3
4 | 4 |数据4
5 | 5 |数据5
6 | 6 |数据6
如果我删除SLNO 4(ID 4),它会变成这样的
------------------------------------
ID(PK) | SLNO |其他栏目
------------------------------------
1 | 1 |数据1
2 | 2 |数据2
3 | 3 |数据3
5 | 5 |数据5
6 | 6 |数据6
我想要排列这样的行...
---- --------------------------------
ID(PK)| SLNO |其他栏目
------------------------------------
1 | 1 |数据1
2 | 2 |数据2
3 | 3 |数据3
5 | 4 |数据5
6 | 5 |数据6
谁能告诉我怎么样? ..
提前致谢...
解决方案
CREATE TABLE [dbo]。[ColumnsExample](
[ID] [ int ] NOT NULL ,
[SLNO] [ int ] IDENTITY ( 1 , 1 ) NOT NULL ,
[其他列] [ varchar ]( 50 ) NOT NULL ,
CONSTRAINT [PK_History] PRIMARY KEY CLUSTERED
(
[ID] ASC
) WITH (PAD_INDEX = OFF ,STATISTICS_NORECOMPUTE = < span class =code-keyword> OFF ,IGNORE_DUP_KEY = OFF ,ALLOW_ROW_LOCKS = ON ,ALLOW_PAGE_LOCKS = ON )
) ON [主要]
要重置,请使用以下SQL命令:
DBCC CHECKIDENT(ColumnsExample,RESEED, 1 )
删除:
DELETE FROM ColumnsExample
WHERE ID = 4 AND
DBCC CHECKIDENT(ColumnsExample,RESEED, 1 跨度>)
Suppose I have a table like this..
------------------------------------
ID(PK) | SLNO | Other Columns
------------------------------------
1 | 1 | Data 1
2 | 2 | Data 2
3 | 3 | Data 3
4 | 4 | Data 4
5 | 5 | Data 5
6 | 6 | Data 6
If I delete SLNO 4 (ID 4), it would become like this
------------------------------------
ID(PK) | SLNO | Other Columns
------------------------------------
1 | 1 | Data 1
2 | 2 | Data 2
3 | 3 | Data 3
5 | 5 | Data 5
6 | 6 | Data 6
And I want the to arrange the rows like this...
------------------------------------
ID(PK) | SLNO | Other Columns
------------------------------------
1 | 1 | Data 1
2 | 2 | Data 2
3 | 3 | Data 3
5 | 4 | Data 5
6 | 5 | Data 6
Can anyone tell me how? ..
Thanks in advance...
解决方案
CREATE TABLE [dbo].[ColumnsExample]( [ID] [int] NOT NULL, [SLNO] [int] IDENTITY(1,1) NOT NULL, [Other Columns] [varchar](50) NOT NULL, CONSTRAINT [PK_History] PRIMARY KEY CLUSTERED ( [ID] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ) ON [PRIMARY]
To Reset, use the following SQL command:
DBCC CHECKIDENT(ColumnsExample, RESEED,1)
Deletion:
DELETE FROM ColumnsExample WHERE ID=4 AND DBCC CHECKIDENT (ColumnsExample,RESEED, 1)
这篇关于使用VB.NET/C#在MS SQL Server中进行研究的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文