× 评论会员:韦恩Gaylard 时间:2012/02/06
你应该有你的序列号在数据库中存储的另一个表。然后,你可以检索这个号码,只要你想插入一个新的采购订单,创造您独特的ID,序列号递增,并保存所有数据库。
希望这有助于
× 评论会员:游客 时间:2012/02/06
sachin10d:存储过程需要的表名作为输入参数ColumnName和retruns未来数Employee表将返回E11090001输出codeprelang="sql"spanclass="code-keyword"create/spanspanclass="code-keyword"proc/spanGetNextNumber@tableNamespanclass="code-keyword"nvarchar/span(spanclass="code-digit"100/span),@columnNamespanclass="code-keyword"nvarchar/span(spanclass="code-digit"100/span)spanclass="code-keyword"as/spanspanclass="code-keyword"declare/span@strSqlspanclass="code-keyword"nvarchar/span(spanclass="code-digit"1000/span)spanclass="code-keyword"set/span@strSql=spanclass="code-string"'/spanspanclass="code-string"select'/spanspanclass="code-string"'/spanspanclass="code-string"'/span+upper(spanclass="code-keyword"right/span(@tableName,spanclass="code-digit"1/span))+spanclass="code-string"'/spanspanclass="code-string"'/spanspanclass="code-string"'/spanspanclass="code-string"+ left(convert(nvarchar,GETDATE(),12),4)+ right('/spanspanclass="code-string"'/spanspanclass="code-string"0000'/spanspanclass="code-string"'/spanspanclass="code-string"+convert(nvarchar,max(right('/span+@columnName+spanclass="code-string"'/spanspanclass="code-string",4))+1),4) from'/span+@tableNamespanclass="code-keyword"exec/spansp_executesql@strsql /pre/code
josh1nine
× 评论会员:游客 时间:2012/02/06
喜韦恩,重置为零的序列号,当年度或按月变动。例如,订单纪录LT;P1108-0326gt;codeprelang="vb"(2011-Aug,series#spanclass="code-digit"326/span)/pre/code的将有望一次更改的日期设置为P1109-00019月01日(2011年9月01)
josh1nine
× 评论会员:游客 时间:2012/02/06
您好sachin10d,我会尽量此过程。不过,我必须学习如何调用SQLDOTNETstoredproc。谢谢。