Without using primary key

Posted by Rameshajogi under ASP.NET on 3/8/2012 | Points: 10 | Views : 709 | Status : [Member] | Replies : 3
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.




Responses

Posted by: CGN007 on: 3/8/2012 [Member] Silver | Points: 25

Up
0
Down
Could you please give a clear picture about the scenario...?

Rameshajogi, if this helps please login to Mark As Answer. | Alert Moderator

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

Up
0
Down
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

Up
0
Down
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

Login to post response