如何为学生生成注册ID? [英] How to generate Registration Id for Students?
本文介绍了如何为学生生成注册ID?的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
Hai Sir,
如何基于分支和课程生成自动生成的学生ID同样是两个大学注册模块.. ??
Hai Sir,
How to generate auto generated Student Id based on Branch and Course likewise two Modules for College Registration..??
推荐答案
参考
声明@Count int
声明@id varchar(10)
SET @Count = 1
WHILE(@Count< = 10)
BEGIN
set @ id ='C'+ RIGHT(REPLICATE('0',4)+ CAST(@Count AS VARCHAR(4)),4)
PRINT @id
SET @Count = @Count + 1
END
refer
declare @Count int
declare @id varchar(10)
SET @Count = 1
WHILE (@Count <=10)
BEGIN
set @id='C'+RIGHT(REPLICATE('0', 4) + CAST(@Count AS VARCHAR(4)), 4)
PRINT @id
SET @Count = @Count + 1
END
这篇关于如何为学生生成注册ID?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文