问题与sql有关 [英] question realated to sql
本文介绍了问题与sql有关的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我想在sql中为两个autonumer在一个表中使用rollno而第二个用于注册我们怎么做
解决方案
首先生成像这样的卷号。 。
1 。)右键单击开表选择修改表。
2 。)点击 你希望的列到递增。
3 。) 列属性窗口下方点击+ 身份规范
4 。)从到 make( 身份) 是。
多数民众赞成。
您可以生成另一种方式......你可以写这样的程序...
< span class =code-keyword>创建 PROCEDURE [dbo] .PRocName
AS
BEGIN
SET < span class =code-keyword> NOCOUNT ON ;
SELECT RIGHT (REPLICATE(' 0', 4 )+ CAST(CAST( COALESCE (MAX(autoGenerateColumnName), 0 ) AS INT ) AS VARCHAR ), 4 )dcno
FROM
(
SELECT TOP 1 autoGenerateColumnName
FROM TableName
ORDER BY sno DESC
)q;
end
else
END
看看http://www.w3schools.com/ SQL / sql_autoincrement.asp
i want to ganrate two autonumer in single table in sql one for rollno and second for registration no how we can do
解决方案
first generate roll number like this..
1.) Right Click On the table Select Modify Table. 2.) Click on the Column you want to increment. 3.) In the column Property Window below click + of Identity Specification 4.) Make (Is Identity) from No to "Yes". Thats It.
You can generate another way...You can write procedure like this...
Create PROCEDURE [dbo].PRocName AS BEGIN SET NOCOUNT ON; SELECT RIGHT(REPLICATE('0', 4) + CAST(CAST(COALESCE(MAX(autoGenerateColumnName), 0) AS INT) AS VARCHAR), 4) dcno FROM ( SELECT TOP 1 autoGenerateColumnName FROM TableName ORDER BY sno DESC ) q; end else END
Take a look http://www.w3schools.com/sql/sql_autoincrement.asp
这篇关于问题与sql有关的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文