Buy Questpond's video subscriptions on huge discount.
DotNetFunda.com
Online: 2824
Home > Forums > Sql Server >

Auto generated column in sql server [Resolved]

Posted by Saranya Boopathi under Sql Server on 6/11/2013 | Points: 10 | Views : 1952 | Status : [Member] | Replies : 1
Write New Post | Search Forums | AnsweredResolved Posts | Un Answered Posts | Forums Home 
How to create userdefined auto generated column in sql server

Saranya Boopathi

Reply | Reply with Attachment
Alert Moderator 

Responses

Posted by: Kirthiga on: 6/17/2013 [Member] Starter | Points: 50

Up
0
Down

Resolved
Hi Saranya,

This may help you 
create table #AutoGen( Col varchar(100))

DECLARE @slno int

select @slno =10

DECLARE @i varchar(10),@alter varchar(4000)

SET @i=1

while(@i<=@slno)

	begin

		select @alter='alter table #AutoGen add Col'+@i+' varchar(100)'

		exec (@alter)

		set	 @i=@i+1

	end

Select * from #AutoGen


This is not your required output please explain your requirement with example.

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

Login to post response

Latest Posts