This script enables you to return data from SQL Server's table without specyfing the name of the column .All you only need to supply is the column number, that you want the data from. In the example we want to chose all rows from the second column (categories table - northwind) Column number is based on colorder from the syscolumns of every database.
----------------------------------- ----Michal Krawczyk ----Returning data with col number ----------------------------------- CREATE PROCEDURE return_with_number @table varchar(30), @col_num int AS DECLARE @sql varchar(60) DECLARE @number1 varchar(30) SELECT @number1 = COL_NAME(OBJECT_ID(@table), @col_num) SET @sql = 'select ' + @number1 + ' from ' + @table EXEC (@sql) For example: USE northwind EXEC return_with_number 'categories',2
2002-03-27
2,836 reads
This short and simple script is a very fast way to count the rows in all your indexed tables. I ran it against a 2-gigabyte database containing large tables (some with over a million rows!), and it returned results in under a second.
2002-03-12
2,839 reads
It calculates log free space in mb and in percent for all databases, and also show the quantity of different objects for one databases.
2002-02-02
2,736 reads
I wanted to be able to use info about an operating system file in TSQL. So I wrote this stored procedure that uses the special stored procedures xp_fileexist and xp_getfiledetails. This can tell if a file or folder exists, and if it is a file what is its size, created date and time, last written […]
2002-02-01
1,208 reads
This stored procedure reads the file names from a directory and stores just the names in a given table. It returns also the number of files present. The sp uses xp_cmdshell and so permissions are restricted to sysadmins and SQLAgentCmdExec. You can test with the following: Create Table ##tmp2 ( fldx nvarchar(255) ) Declare @FilePath […]
2002-02-01
1,933 reads
