本文介绍了获取SQL表中的行数的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我的表格列(studentID,studentName,studentRegNumber)
当我输入studentID和studentName时,应通过考虑表中的当前记录数来自动添加studentRegNumber.
示例记录
StdID StdName StdRegNo
1尼山A1
2布赖恩A2
3托马斯A3
应该这样自动添加StdRegNumber..
给我一个例子...
因为我是c#
my table columns(studentID,studentName,studentRegNumber)
when I enter studentID & studentName studentRegNumber should be added automatically by considering current number of records in the table.
Examples records
StdID StdName StdRegNo
1 Nishan A1
2 Brian A2
3 Thomas A3
StdRegNumber should be added automatically like this..
Give me a help with an example...
Because I am a beginner for c#
推荐答案
SELECT StdID, StdName, 'A' + CAST(StdID AS VARCHAR) AS StdRegNo FROM [YourTableName]
You can use IDENTITY (Property)[^] to auto generate the student ID.
这篇关于获取SQL表中的行数的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!