how can generate auto incremented alpha numeric no?

At the time of table  creation use the following
[ID] [int] IDENTITY(1,1) NOT NULL,
Above stmt is auto increment. try it. but only interger increment.

Try this method....
I create a procedure for it...




USE [practice]
GO

/****** Object:  StoredProcedure [dbo].[Insert_Value]    Script Date: 3/6/2015 10:11:21 PM ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE proc [dbo].[Insert_Value](@iid nvarchar(max)=null,@name nvarchar(max)=null,@fname nvarchar(max))
as
begin


declare @lastval int
set @lastval = (select count(iid) from testit where iid like '%'+@iid+'%')
declare @iidn nvarchar(max)
 set @lastval=@lastval+1
set @iidn=@iid+'000'+ + CAST( @lastval as nvarchar(max))
insert into testit(iid,name,fname) values(@iidn,@name,@fname)

end

GO