Getting Started with Adobe After Effects - Part 6: Motion Blur


Upload Image Close it
Select File

Browse by Tags · View All
sql_server 217
t-sql 211
tsql 116
sqlserver 96
BRH 78
#SQLServer 66
#TSQL 56
SQL Server 34
function 11
SSMS 9

Archive · View All
August 2007 17
August 2010 8
June 2012 7
June 2011 7
November 2007 7
August 2012 6
May 2012 6
November 2011 6
August 2011 6
October 2011 6

Madhivanan's TSQL Blog

Select Data from Top N Columns

Aug 27 2007 9:30AM by Madhivanan   

Suppose you have table with many columns and often you need data from first 15 or 20 columns. You have to specify all the columns in your select statement. This procedure will select top N columns you want. All you have to do is to supply table name and number of columns you want

Here is the procedure

CREATE procedure TopNcolumns 
(
	@tableName varchar(100),
	@n int
)  
as    
Declare @s varchar(2000)    
set @s=''  
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  

If you execute TopNColumns 'Mytable',12 then first 12 columns with data from the table Mytable will be displayed

Tags: t-sql, sql_server, Top_columns,


Madhivanan
3 · 40% · 12947
1
 
0
Lifesaver
 
0
Refreshed
 
0
Learned
 
0
Incorrect



Submit

Your Comment


Sign Up or Login to post a comment.

"Select Data from Top N Columns" rated 5 out of 5 by 1 readers
Select Data from Top N Columns , 5.0 out of 5 based on 1 ratings
    Copyright © Rivera Informatic Private Ltd Contact us      Privacy Policy      Terms of use      Report Abuse      Advertising      [ZULU1097]