[重新发布]自定义主键 [英] [Repost] Custom Primary key

问题描述

谁能帮我?我创建了一个表，并使用了一个名为"ID"的主键.但是，我也希望"ID"也能自动递增.

这是我的问题，我该如何使用以下格式:
"PIC0001"，"PIC0002"，"PIC0003"，............等.

有人可以帮助我吗?

Hi,

Can anyone help me? I have created a table and with a primary key called "ID". However, I want the "ID" be auto increment as well.

Here is my question, how can I do in the following format:
"PIC0001", "PIC0002", "PIC0003", ............ etc.

Anyone can help me?

推荐答案

我们已经在这里建议了如何实现的方法:L
http://www.codeproject.com/Answers/72563/How-To-generate-user-defind-lab-no.aspx#answer1 [

We already suggested of how you can achieve it here:L
http://www.codeproject.com/Answers/72563/How-To-generate-user-defind-lab-no.aspx#answer1[^]

这篇关于[重新发布]自定义主键的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！