Without using primary key

Posted by Rameshajogi under ASP.NET on 3/8/2012 | Points: 10 | Views : 1505 | Status : [Member] | Replies : 2

Write New Post |

Search Forums | Answered

Resolved Posts |

Un Answered Posts |

Forums Home

Hi sir
I m Ramesh Jogi i want coding for using 3tier architecture and using SqL server Without using primary key the column will this type(RJKAR004). Back end table one is RJKAR004 and retrieve this column to front end and also auto incrementing this column.

Reply | Reply with Attachment

Alert Moderator

Responses

Posted by: Vijayar on: 3/9/2012 [Member] Starter | Points: 25

0	CREATE TABLE tablename(ID INT IDENTITY PRIMARY KEY, IDwithChar AS 'C' + RIGHT('RJKAR004' + CAST(ID AS VARCHAR(15)), 6) PERSISTED ) vijaya Rameshajogi, if this helps please login to Mark As Answer. \| Alert Moderator

Posted by: Hmanjarawala on: 3/9/2012 [Member] Bronze | Points: 25

0	CREATE TABLE tablename(ID INT IDENTITY, IDwithChar AS 'C' + RIGHT('RJKAR004' + CAST(ID AS VARCHAR(15)), 6) PERSISTED ) Himanshu Manjarawala Sr. Software Engineer@AutomationAnywhere http://fieredotnet.wordpress.com/ Rameshajogi, if this helps please login to Mark As Answer. \| Alert Moderator

Latest Posts