Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 Transact-SQL (2005)
 Please help me

Author  Topic 

MohammedKhamees
Starting Member

1 Post

Posted - 2007-05-01 : 07:32:23
I want to make a column in a certain table ,this column consists of 3 chars an 6 autoincrement numbers like "abc-000123" .Furthermore this column is a primary key

how can i do this?
thanks

M.S

khtan
In (Som, Ni, Yak)

17689 Posts

Posted - 2007-05-01 : 07:51:28
see http://www.sqlteam.com/item.asp?ItemID=26939


KH

Go to Top of Page
   

- Advertisement -