Create procedure TopNcolumns (@tableName varchar(100),@n int)  
as    
	Declare @s varchar(2000)    
	set @s=''  
	If exists(Select * from information_Schema.tables where table_name=@tablename and table_type='Base Table')
	Begin
		If @n>=0   
			Begin  
				set rowcount @n  
				Select @s=@s+','+ column_name from information_schema.columns   
				where table_name=@tablename order by ordinal_position  
				Set rowcount 0  
				Set @s=substring(@s,2,len(@s)-1)  
				Exec('Select '+@s+' from '+@tablename)  
			End  
		else  
		Select 'Negative values are not allowed' as Error  
	End
	else
		Select 'Table '+@tableName+' does not exist' as Error

quote:

---

Originally posted by maya_zakry

hi madhivanan,

how do we use this SP after we created it? method of use?
how about we dont want to select first top, we want to select any column from 1 to 100? can this be achieved using this function? thanks.
-newbie-

---