Rolf Eisenring's Quantum Battery

SOURCES:
On the brand new Drupal site

For each procedure in sqlserver 2005 2008 do something ..

ALTER PROCEDURE [dbo].[procUtils_ForEachProcedure]  

WITH EXECUTE AS CALLER  

AS  

BEGIN -- proc start                              

SET NOCOUNT ON;                              

BEGIN TRY        --begin try                    

declare @LogLevel int --THE LOG LEVEL OF THE EXECUTING USER  

declare @ProcedureName varchar(1000) --

DECLARE @CODESTR VARCHAR(MAX)

--Declare the Procedure variable     

DECLARE @ProcedureNames Table    

(    

Number INT IDENTITY(1,1), --Auto incrementing Identity column    

ProcedureName VARCHAR(300) --The string value    

)    

--Decalre a variable to remember the position of the current delimiter    

DECLARE @CurrentDelimiterPositionVar INT     

--Decalre a variable to remember the number of rows in the Procedure    

DECLARE @Count INT    

DECLARE @SqlCode varchar(200)

-- DEBUG select * from sys.procedures

--Populate the Procedure variable using some logic    

INSERT INTO @ProcedureNames 

SELECT name FROM sys.procedures 

--where name like '%procGen%' --ADD SOME CONSTRAINT ALSO ...

--Initialize the looper variable    

SET @CurrentDelimiterPositionVar = 1    

--Determine the number of rows in the Procedure    

SELECT @Count=max(Number) from @ProcedureNames    

--Loop through until all row processing is done    

WHILE @CurrentDelimiterPositionVar <= @Count    

BEGIN   

SET @CODESTR = 'DROP ' 

--Load current value from the Procedure    

SELECT @ProcedureName = ProcedureName FROM @ProcedureNames WHERE Number = @CurrentDelimiterPositionVar    

--Process the current value    

SET  @CODESTR = @CODESTR + 'PROC '+ @ProcedureName + ''              

print @CODESTR

--Increment loop counter    

SET @CurrentDelimiterPositionVar = @CurrentDelimiterPositionVar + 1;    

END    

END TRY        --end try                    

BEGIN CATCH                          

print  ' Error number: ' + CAST(ERROR_NUMBER() AS varchar(100)) +                 

'Error message: ' + ERROR_MESSAGE() + 'Error severity: ' +   

CAST(ERROR_SEVERITY() AS varchar(10)) +                 

'Error state: ' + CAST(ERROR_STATE() AS varchar(1000)) +   

'XACT_STATE: ' + CAST(XACT_STATE() AS varchar(1000))                          

END CATCH                          

END --procedure end                               

/*   

USE [Db]  

GO  

exec procUtils_ForEachProcedure  

*/

Foreach table in sqlserver 2005 2008 do something

--select column_name from INFORMATION_SCHEMA.COLUMNS where TABLE_NAME='Products'    

--Declare the Table variable     

DECLARE @TableNames TABLE    

(    

Number INT IDENTITY(1,1), --Auto incrementing Identity column    

TableName VARCHAR(300) --The string value    

)    

--Decalre a variable to remember the position of the current delimiter    

DECLARE @CurrentDelimiterPositionVar INT     

--Decalre a variable to remember the number of rows in the table    

DECLARE @Count INT    

DECLARE @SqlCode varchar(200)

--Populate the TABLE variable using some logic    

INSERT INTO @TableNames SELECT name FROM sys.tables

--Initialize the looper variable    

SET @CurrentDelimiterPositionVar = 1    

--Determine the number of rows in the Table    

SELECT @Count=max(Number) from @TableNames    

--A variable to hold the currently selected value from the table    

DECLARE @TableName varchar(300);    

--Loop through until all row processing is done    

WHILE @CurrentDelimiterPositionVar <= @Count    

BEGIN    

--Load current value from the Table    

SELECT @TableName = TableName FROM @TableNames WHERE Number = @CurrentDelimiterPositionVar    

--Process the current value    

print 'EXEC [dbo].[procUtils_GenerateInsertProc] @TableName = N'''+ @TableName + ''''              

--Increment loop counter    

SET @CurrentDelimiterPositionVar = @CurrentDelimiterPositionVar + 1;    

END    

what I have been doing lately on SqlServer 2005 2008

USE [Db]

GO

/****** Object:  StoredProcedure [dbo].[procUtils_WhatIHaveBeenDoing]    Script Date: 09/18/2009 11:36:19 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE PROCEDURE [dbo].[procUtils_WhatIHaveBeenDoing]

WITH EXECUTE AS CALLER

AS

BEGIN -- proc start                            

SET NOCOUNT ON;                            

declare @procedureName varchar(200)        

declare @procStep varchar(4000)  

declare    @UserSessionId [int]

declare    @PageTypeId [int]

declare    @msgOut [varchar](200)

declare    @debugMsgOut [varchar](200)

declare    @ret [int] 

set @procedureName = ( SELECT OBJECT_NAME(@@PROCID))        

set @procStep = ' '     

BEGIN TRY        --begin try                  

set @ret = 1 --assume false from the beginning                  

declare @LogLevel int --THE LOG LEVEL OF THE EXECUTING USER

select  o.name  , 

(SELECT [definition] AS [text()] 

FROM sys.all_sql_modules 

where sys.all_sql_modules.object_id=a.object_id FOR XML PATH(''), TYPE) 

AS Statement_Text

, a.object_id, o.modify_date  from sys.all_sql_modules  a 

left join sys.objects  o on a.object_id=o.object_id order by 4 desc

--select * from sys.objects

set @LogLevel = dbo.funcGetUserLogLevelByUserSessionId( @UserSessionId)

set @procStep = 'START PROCEDURE ' + @procedureName

if ( @LogLevel = 1 )

begin --if ( @LogLevel = 1 )

INSERT INTO [dbo].[LogStore] ( [Date],[Thread],[Level],[Logger],[Message])

values ( getdate() , N'8', N'DEBUG', @procedureName , @procStep )

END --if ( @LogLevel = 1 )  

set @procStep = ' PUT HERE THE STEP''S NAME '   

if ( @LogLevel = 1 )

begin --if ( @LogLevel = 1 )

INSERT INTO [dbo].[LogStore]([Date], [Thread], [Level], [Logger], [Message])

values( GETDATE(), N'8', N'DEBUG', @procedureName , @procStep )

END --if ( @LogLevel = 1 )  

-- RUN SOME CODE 

-- IF NEEDED PERFORM SOME DEBUGGING 

--GET SOME MESSAGE OF THE DESIRED LANGUAGE FROM THE MSG TABLE 

DECLARE    @return_value int,

@MsgTxt nvarchar(max)

EXEC    @return_value = [dbo].[procUtils_GetMsgTxtByKeyAndUserSessionId]

@UserSessionId = @UserSessionId,

@MsgKey = N'ErrorMsgMenuRetrievalFailed',

@MsgTxt = @MsgTxt OUTPUT

set @ret = @@ERROR                  

if ( @@ERROR != 0 ) 

set @msgOut = @MsgTxt            

return @RET                   

END TRY        --end try                  

BEGIN CATCH                        

EXEC    @return_value = [dbo].[procUtils_GetMsgTxtByKeyAndUserSessionId]

@UserSessionId = 2,

@MsgKey = N'ErrorMsgMenuRetrievalFailed',

@MsgTxt = @MsgTxt OUTPUT

set @ret = 1                  

set @debugMsgOut = ' Error number: ' + CAST(ERROR_NUMBER() AS varchar(100)) +               

'Error message: ' + ERROR_MESSAGE() + 'Error severity: ' + 

CAST(ERROR_SEVERITY() AS varchar(10)) +               

'Error state: ' + CAST(ERROR_STATE() AS varchar(100)) + 

'XACT_STATE: ' + CAST(XACT_STATE() AS varchar(100))                        

-- record the error in the database                        

set @debugMsgOut = @debugMsgOut + @msgOut            

INSERT INTO [dbo].[LogStore] ( [Date],[Thread],[Level],[Logger],[Message])

values ( getdate() , N'8', N'DEBUG', 'dbo.procUtils_WhatIHaveBeenDoing' , @debugMsgOut )

END CATCH                        

END --procedure end                             

/* 

USAGE:

EXEC procUtils_WhatIHaveBeenDoing

*/

GO

How-to generate update statements on SqlServer 2005 , 2008

alter PROCEDURE [dbo].[procUtils_GenerateMetaUpdate]  

@TableName [varchar](50)  

WITH EXECUTE AS CALLER  

AS  

BEGIN -- proc start                                    

SET NOCOUNT ON;                                    

BEGIN TRY        --begin try                          

--CODE SNIPPET TO LIST TABLE COLUMNS         

-- RUN IN SSMS WITH cTRL + t FIRST TO OUTPUT THE RESULT TO TEXT FOR COPY PASTE        

--FIRST SEARCH THE TABLE WHICH HAD A "Feature" in its name         

--SELECT NAME FROM SYS.TABLES WHERE NAME LIKE '%Feature%'        

--select column_name from INFORMATION_SCHEMA.COLUMNS where TABLE_NAME='Feature'            

--Declare the Table variable             

DECLARE @ColNames TABLE            

(            

Number INT IDENTITY(1,1), --Auto incrementing Identity column            

ColName VARCHAR(300) , --The string value            

DataType varchar(50) --the datatype   

)            

--Decalre a variable to remember the position of the current delimiter            

DECLARE @CurrentDelimiterPositionVar INT             

--Decalre a variable to remember the number of rows in the table            

DECLARE @Count INT            

--Populate the TABLE variable using some logic            

INSERT INTO @ColNames SELECT column_name , Data_type from INFORMATION_SCHEMA.COLUMNS         

where TABLE_NAME=@TableName            

--Initialize the looper variable            

SET @CurrentDelimiterPositionVar = 1            

--Determine the number of rows in the Table            

SELECT @Count=max(Number) from @ColNames            

--A variable to hold the currently selected value from the table            

DECLARE @ColumnName varchar(300);            

DECLARE @DataType varchar(50)  

print '  

SET NOCOUNT ON;  

SET XACT_ABORT ON;  

GO  

SELECT TOP 5 * FROM ' + @TableName + ' order by 1 desc   

GO  

'  

print 'UPDATE ' + @TableName + ' SET '            

--Loop through until all row processing is done            

WHILE @CurrentDelimiterPositionVar <= @Count            

BEGIN            

--Load current value from the Table            

SELECT @ColumnName = ColName FROM @ColNames WHERE Number = @CurrentDelimiterPositionVar  

SELECT @DataType = DataType FROM @ColNames WHERE Number = @CurrentDelimiterPositionVar    

--Process the current value            

if @CurrentDelimiterPositionVar = @Count            

begin

print '[' + @ColumnName + ']= ''' + @ColumnName + '''--type of ' + @DataType 

-- this is the last row no comma!        

end

else         

begin

print '[' + @ColumnName + ']= ''' + @ColumnName + ''', --type of '  + @DataType 

-- print it without the ,        

-- print 'obj1.' + @ColumnName+ ' = obj2.'+ @ColumnName        

end

-- print @ColumnName    --SIMPLE PRINT        

--Increment loop counter            

SET @CurrentDelimiterPositionVar = @CurrentDelimiterPositionVar + 1;            

END            

print 'WHERE '            

--AND START ALL OVER AGAIN       

SET @CurrentDelimiterPositionVar = 1  

--Loop through until all row processing is done            

WHILE @CurrentDelimiterPositionVar <= @Count            

BEGIN            

--Load current value from the Table            

SELECT @ColumnName = ColName FROM @ColNames WHERE Number = @CurrentDelimiterPositionVar  

SELECT @DataType = DataType FROM @ColNames WHERE Number = @CurrentDelimiterPositionVar    

--Process the current value            

if @CurrentDelimiterPositionVar = @Count            

begin

print '[' + @ColumnName + ']=' +  ''''' -- type of ' + @DataType 

-- this is the last row no comma!        

end

else

begin         

print '[' + @ColumnName + ']=' +  ''''' AND -- type of ' + 

@DataType  

-- print it without the ,        

-- print 'obj1.' + @ColumnName+ ' = obj2.'+ @ColumnName        

-- print @ColumnName    --SIMPLE PRINT        

--Increment loop counter            

end

SET @CurrentDelimiterPositionVar = @CurrentDelimiterPositionVar + 1;            

END            

set nocount off         

PRINT '-- NOW VIEW THE RESULTS '        

PRINT 'Select top 5  * from '+ @TableName +' order by 1 desc   '  

END TRY        --end try                          

BEGIN CATCH                                

print ' Error number: ' + CAST(ERROR_NUMBER() AS varchar(100)) +                       

'Error message: ' + ERROR_MESSAGE() + 'Error severity: ' +         

CAST(ERROR_SEVERITY() AS varchar(10)) +                       

'Error state: ' + CAST(ERROR_STATE() AS varchar(100)) +         

'XACT_STATE: ' + CAST(XACT_STATE() AS varchar(100))                                

END CATCH                                

END --procedure end                                     

/*         

USE [Db]        

GO        

SELECT NAME FROM SYS.tables where name like '%Msg%'        

EXEC [dbo].[procUtils_GenerateMetaUpdate] @TableName = N'msg'  

GO        

*/ 

How-to generate insert statements for Sql Server 2005 , 2008

alter PROCEDURE [dbo].[procUtils_GenerateMetaInsert]  

@TableName [varchar](50)  

WITH EXECUTE AS CALLER  

AS  

BEGIN -- proc start                                    

SET NOCOUNT ON;                                    

BEGIN TRY        --begin try                          

--CODE SNIPPET TO LIST TABLE COLUMNS         

-- RUN IN SSMS WITH cTRL + t FIRST TO OUTPUT THE RESULT TO TEXT FOR COPY PASTE        

--FIRST SEARCH THE TABLE WHICH HAD A "Feature" in its name         

--SELECT NAME FROM SYS.TABLES WHERE NAME LIKE '%Feature%'        

--select column_name from INFORMATION_SCHEMA.COLUMNS where TABLE_NAME='Feature'            

--Declare the Table variable             

DECLARE @ColNames TABLE            

(            

Number INT IDENTITY(1,1), --Auto incrementing Identity column            

ColName VARCHAR(300) , --The string value            

DataType varchar(50) --the datatype   

)            

--Decalre a variable to remember the position of the current delimiter            

DECLARE @CurrentDelimiterPositionVar INT             

--Decalre a variable to remember the number of rows in the table            

DECLARE @Count INT            

--Populate the TABLE variable using some logic            

INSERT INTO @ColNames SELECT column_name , Data_type from INFORMATION_SCHEMA.COLUMNS         

where TABLE_NAME=@TableName            

--Initialize the looper variable            

SET @CurrentDelimiterPositionVar = 1            

--Determine the number of rows in the Table            

SELECT @Count=max(Number) from @ColNames            

--A variable to hold the currently selected value from the table            

DECLARE @ColumnName varchar(300);            

DECLARE @DataType varchar(50)  

print '  

SET NOCOUNT ON;  

SET XACT_ABORT ON;  

GO  

SET IDENTITY_INSERT [dbo].[' + @TableName + '] ON;  

SELECT TOP 5 * FROM ' + @TableName + ' order by 1 desc   

GO  

'  

print 'INSERT INTO ' + @TableName + '( '            

--Loop through until all row processing is done            

WHILE @CurrentDelimiterPositionVar <= @Count            

BEGIN            

--Load current value from the Table            

SELECT @ColumnName = ColName FROM @ColNames WHERE Number = @CurrentDelimiterPositionVar  

SELECT @DataType = DataType FROM @ColNames WHERE Number = @CurrentDelimiterPositionVar    

--Process the current value            

if @CurrentDelimiterPositionVar = @Count            

print '[' + @ColumnName + '] --type of ' + @DataType -- this is the last row no comma!        

else         

print '[' + @ColumnName + '], --type of '  + @DataType -- print it without the ,        

-- print 'obj1.' + @ColumnName+ ' = obj2.'+ @ColumnName        

-- print @ColumnName    --SIMPLE PRINT        

--Increment loop counter            

SET @CurrentDelimiterPositionVar = @CurrentDelimiterPositionVar + 1;            

END            

print ') VALUES ( '            

--AND START ALL OVER AGAIN       

SET @CurrentDelimiterPositionVar = 1  

--Loop through until all row processing is done            

WHILE @CurrentDelimiterPositionVar <= @Count            

BEGIN            

--Load current value from the Table            

SELECT @ColumnName = ColName FROM @ColNames WHERE Number = @CurrentDelimiterPositionVar  

SELECT @DataType = DataType FROM @ColNames WHERE Number = @CurrentDelimiterPositionVar    

--Process the current value            

if @CurrentDelimiterPositionVar = @Count            

print ''''' --[' + @ColumnName + '] type of ' + @DataType -- this is the last row no comma!        

else         

print ''''' , --[' + @ColumnName + '] type of ' + @DataType  -- print it without the ,        

-- print 'obj1.' + @ColumnName+ ' = obj2.'+ @ColumnName        

-- print @ColumnName    --SIMPLE PRINT        

--Increment loop counter            

SET @CurrentDelimiterPositionVar = @CurrentDelimiterPositionVar + 1;            

END            

set nocount off         

PRINT ')'  

PRINT '-- NOW VIEW THE RESULTS '        

PRINT 'Select top 5  * from '+ @TableName +' order by 1 desc   '  

END TRY        --end try                          

BEGIN CATCH                                

print ' Error number: ' + CAST(ERROR_NUMBER() AS varchar(100)) +                       

'Error message: ' + ERROR_MESSAGE() + 'Error severity: ' +         

CAST(ERROR_SEVERITY() AS varchar(10)) +                       

'Error state: ' + CAST(ERROR_STATE() AS varchar(100)) +         

'XACT_STATE: ' + CAST(XACT_STATE() AS varchar(100))                                

END CATCH                                

END --procedure end                                     

/*         

USE [GenApp]        

GO        

SELECT NAME FROM SYS.tables where name like '%Msg%'        

EXEC [dbo].[procUtils_GenerateMetaInsert] @TableName = N'msg'  

GO        

*/ 

Generic Getter and Setter in C#

using System;

using System.Collections.Generic;

using System.Collections.Generic;

namespace GenApp.Dh

{

/// <summary>

/// Provides simple wrapping around generated single item 

/// for less refactoring during swaping of DAL generation libs

/// </summary>

public class HolderForItem<T>

{

private T _Item ; 

public void  SetItem (T item)

{

this._Item = (T)item;

} //eof Set

public T GetItem()

{

return (T)_Item;

} //eof 

} //eof class 

} //eof namespace 

Online dictionaries - revised

Online dictionaries - revised

Swedish - Bulgarian
Swedish - Finnish
Swedish - English
Swedish - Russian
Swedish - German


ENG - BUL -FI mashup

www.dictionary.com
Sorry , the list is meant just to serve me in my language brain gymnastics ...


Ryska till svenska

svenska till finska

Online dictionaries - revised

Online dictionaries - revised

Swedish - Bulgarian
Swedish - Finnish
Swedish - English
Swedish - Russian
Swedish - German


ENG - BUL -FI mashup

www.dictionary.com
Sorry , the list is meant just to serve me in my language brain gymnastics ...


Ryska till svenska

svenska till finska

Use online translation - example google translate

Here is a sample list

Swedish - Bulgarian
Swedish - Finnish
Swedish - English
Swedish - Russian
Swedish - German


Sorry , the list is meant just to serve me in my language brain gymnastics ...

emc2 got more funding

SOURCES:
list of US DOD contracts
The article in Next Big Future

how-to generate list of column names of a table in sql server 2005 2008

USE [GenApp]

GO

/****** Object:  StoredProcedure [dbo].[procUtils_PrintTableCols]    Script Date: 09/11/2009 14:25:22 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

ALTER PROCEDURE [dbo].[procUtils_PrintTableCols]

@TableName [varchar](50)

WITH EXECUTE AS CALLER

AS

BEGIN -- proc start                                  

SET NOCOUNT ON;                                  

BEGIN TRY        --begin try                        

--CODE SNIPPET TO LIST TABLE COLUMNS       

-- RUN IN SSMS WITH cTRL + t FIRST TO OUTPUT THE RESULT TO TEXT FOR COPY PASTE      

--FIRST SEARCH THE TABLE WHICH HAD A "Feature" in its name       

--SELECT NAME FROM SYS.TABLES WHERE NAME LIKE '%Feature%'      

--select column_name from INFORMATION_SCHEMA.COLUMNS where TABLE_NAME='Feature'          

--Declare the Table variable           

DECLARE @ColNames TABLE          

(          

Number INT IDENTITY(1,1), --Auto incrementing Identity column          

ColName VARCHAR(300) , --The string value          

DataType varchar(50) --the datatype 

)          

--Decalre a variable to remember the position of the current delimiter          

DECLARE @CurrentDelimiterPositionVar INT           

--Decalre a variable to remember the number of rows in the table          

DECLARE @Count INT          

--Populate the TABLE variable using some logic          

INSERT INTO @ColNames SELECT column_name , Data_type from INFORMATION_SCHEMA.COLUMNS       

where TABLE_NAME=@TableName          

--Initialize the looper variable          

SET @CurrentDelimiterPositionVar = 1          

--Determine the number of rows in the Table          

SELECT @Count=max(Number) from @ColNames          

--A variable to hold the currently selected value from the table          

DECLARE @ColumnName varchar(300);          

DECLARE @DataType varchar(50)

--Loop through until all row processing is done          

WHILE @CurrentDelimiterPositionVar <= @Count          

BEGIN          

--Load current value from the Table          

SELECT @ColumnName = ColName FROM @ColNames WHERE Number = @CurrentDelimiterPositionVar

SELECT @DataType = DataType FROM @ColNames WHERE Number = @CurrentDelimiterPositionVar  

--Process the current value          

if @CurrentDelimiterPositionVar = @Count          

print '[' + @ColumnName + '] --type of ' + @DataType -- this is the last row no comma!      

else       

print '[' + @ColumnName + '], --type of '  + @DataType -- print it without the ,      

-- print 'obj1.' + @ColumnName+ ' = obj2.'+ @ColumnName      

-- print @ColumnName    --SIMPLE PRINT      

--Increment loop counter          

SET @CurrentDelimiterPositionVar = @CurrentDelimiterPositionVar + 1;          

END          

PRINT 'Select top 5  * from '+ @TableName +' order by 1 desc   '

END TRY        --end try                        

BEGIN CATCH                              

print ' Error number: ' + CAST(ERROR_NUMBER() AS varchar(100)) +                     

'Error message: ' + ERROR_MESSAGE() + 'Error severity: ' +       

CAST(ERROR_SEVERITY() AS varchar(10)) +                     

'Error state: ' + CAST(ERROR_STATE() AS varchar(100)) +       

'XACT_STATE: ' + CAST(XACT_STATE() AS varchar(100))                              

END CATCH                              

END --procedure end                                   

/*       

USE [GenApp]      

GO      

SELECT NAME FROM SYS.tables where name like '%feature%'      

EXEC    [dbo].[procUtils_PrintTableCols] @TableName = N'fEATURE'

GO      

*/ 

How-to generate insert statements from a table name

alter PROCEDURE [dbo].[procUtils_GenerateMetaInsert]      

@TableName varchar(50)      

AS      

BEGIN -- proc start                                  

SET NOCOUNT ON;                                  

BEGIN TRY        --begin try                        

--CODE SNIPPET TO LIST TABLE COLUMNS       

-- RUN IN SSMS WITH cTRL + t FIRST TO OUTPUT THE RESULT TO TEXT FOR COPY PASTE      

--FIRST SEARCH THE TABLE WHICH HAD A "Feature" in its name       

--SELECT NAME FROM SYS.TABLES WHERE NAME LIKE '%Feature%'      

--select column_name from INFORMATION_SCHEMA.COLUMNS where TABLE_NAME='Feature'          

--Declare the Table variable           

DECLARE @ColNames TABLE          

(          

Number INT IDENTITY(1,1), --Auto incrementing Identity column          

ColName VARCHAR(300) , --The string value          

DataType varchar(50) --the datatype 

)          

--Decalre a variable to remember the position of the current delimiter          

DECLARE @CurrentDelimiterPositionVar INT           

--Decalre a variable to remember the number of rows in the table          

DECLARE @Count INT          

--Populate the TABLE variable using some logic          

INSERT INTO @ColNames SELECT column_name , Data_type from INFORMATION_SCHEMA.COLUMNS       

where TABLE_NAME=@TableName          

--Initialize the looper variable          

SET @CurrentDelimiterPositionVar = 1          

--Determine the number of rows in the Table          

SELECT @Count=max(Number) from @ColNames          

--A variable to hold the currently selected value from the table          

DECLARE @ColumnName varchar(300);          

DECLARE @DataType varchar(50)

print 'INSERT INTO ' + @TableName + '( '          

--Loop through until all row processing is done          

WHILE @CurrentDelimiterPositionVar <= @Count          

BEGIN          

--Load current value from the Table          

SELECT @ColumnName = ColName FROM @ColNames WHERE Number = @CurrentDelimiterPositionVar

SELECT @DataType = DataType FROM @ColNames WHERE Number = @CurrentDelimiterPositionVar  

--Process the current value          

if @CurrentDelimiterPositionVar = @Count          

print '[' + @ColumnName + '] --type of ' + @DataType -- this is the last row no comma!      

else       

print '[' + @ColumnName + '], --type of '  + @DataType -- print it without the ,      

-- print 'obj1.' + @ColumnName+ ' = obj2.'+ @ColumnName      

-- print @ColumnName    --SIMPLE PRINT      

--Increment loop counter          

SET @CurrentDelimiterPositionVar = @CurrentDelimiterPositionVar + 1;          

END          

print ') VALUES ( '          

--AND START ALL OVER AGAIN     

SET @CurrentDelimiterPositionVar = 1

--Loop through until all row processing is done          

WHILE @CurrentDelimiterPositionVar <= @Count          

BEGIN          

--Load current value from the Table          

SELECT @ColumnName = ColName FROM @ColNames WHERE Number = @CurrentDelimiterPositionVar

SELECT @DataType = DataType FROM @ColNames WHERE Number = @CurrentDelimiterPositionVar  

--Process the current value          

if @CurrentDelimiterPositionVar = @Count          

print ''''' --[' + @ColumnName + '] type of ' + @DataType -- this is the last row no comma!      

else       

print ''''' , --[' + @ColumnName + '] type of ' + @DataType  -- print it without the ,      

-- print 'obj1.' + @ColumnName+ ' = obj2.'+ @ColumnName      

-- print @ColumnName    --SIMPLE PRINT      

--Increment loop counter          

SET @CurrentDelimiterPositionVar = @CurrentDelimiterPositionVar + 1;          

END          

set nocount off       

PRINT ')'      

END TRY        --end try                        

BEGIN CATCH                              

print ' Error number: ' + CAST(ERROR_NUMBER() AS varchar(100)) +                     

'Error message: ' + ERROR_MESSAGE() + 'Error severity: ' +       

CAST(ERROR_SEVERITY() AS varchar(10)) +                     

'Error state: ' + CAST(ERROR_STATE() AS varchar(100)) +       

'XACT_STATE: ' + CAST(XACT_STATE() AS varchar(100))                              

END CATCH                              

END --procedure end                                   

/*       

USE [GenApp]      

GO      

EXEC    [dbo].[procUtils_GenerateMetaInsert] @TableName = N'Msg'

GO      

*/ 

List columns from any table and generate code in tsql

--CODE SNIPPET TO LIST TABLE COLUMNS 

-- RUN IN SSMS WITH cTRL + t FIRST TO OUTPUT THE RESULT TO TEXT FOR COPY PASTE

--FIRST SEARCH THE TABLE WHICH HAD A "Feature" in its name 

--SELECT NAME FROM SYS.TABLES WHERE NAME LIKE '%Feature%'

--select column_name from INFORMATION_SCHEMA.COLUMNS where TABLE_NAME='Feature'    

--Declare the Table variable     

DECLARE @ColNames TABLE    

(    

Number INT IDENTITY(1,1), --Auto incrementing Identity column    

ColName VARCHAR(300) --The string value    

)    

--Decalre a variable to remember the position of the current delimiter    

DECLARE @CurrentDelimiterPositionVar INT     

--Decalre a variable to remember the number of rows in the table    

DECLARE @Count INT    

--Populate the TABLE variable using some logic    

INSERT INTO @ColNames SELECT column_name from INFORMATION_SCHEMA.COLUMNS 

where TABLE_NAME='Feature'    

--Initialize the looper variable    

SET @CurrentDelimiterPositionVar = 1    

--Determine the number of rows in the Table    

SELECT @Count=max(Number) from @ColNames    

--A variable to hold the currently selected value from the table    

DECLARE @CurrentValue varchar(300);    

--Loop through until all row processing is done    

WHILE @CurrentDelimiterPositionVar <= @Count    

BEGIN    

--Load current value from the Table    

SELECT @CurrentValue = ColName FROM @ColNames WHERE Number = @CurrentDelimiterPositionVar    

--Process the current value    

if @CurrentDelimiterPositionVar = @Count    

print '[' + @CurrentValue + ']' -- this is the last row no comma!

else 

print '[' + @CurrentValue + '],' -- print it without the ,

-- print 'obj1.' + @CurrentValue+ ' = obj2.'+ @CurrentValue

-- print @CurrentValue    --SIMPLE PRINT

--Increment loop counter    

SET @CurrentDelimiterPositionVar = @CurrentDelimiterPositionVar + 1;    

END    

set nocount off 

How-to create a table and its according history table in tsql

The main principle -

recreate the table from ssms
with TableNameHistory
add A TableNameHistoryId with the identity
add an Action Column - specifies what is the action performed on the table to track
add an SqlLogin Column - specifies the sql login performing the action
add an UpdateWhen column - specifies the time of the update ( here Update means the UPDATE , DELETE , INSERT actions )

Copy paste this triggers and replace the name of the "Feature" table with the name of your table
+ replace the corresponing columns.

The whole thing could wrap up in a single DDL trigger for CREATE_TABLE. If you have done it , please share a code ...

USE [GenApp]

GO

/****** Object:  Table [dbo].[FeatureHistory]    Script Date: 09/08/2009 10:02:43 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

SET ANSI_PADDING ON

GO

CREATE TABLE [dbo].[FeatureHistory](

[FeatureHistoryId] [int] IDENTITY(1,1) NOT NULL,

[FeatureId] [int] NOT NULL,

[Vote] [int] NULL,

[Key] [varchar](200) NULL,

[Title] [varchar](2000) NOT NULL,

[Description] [varchar](2000) NOT NULL,

[GenAppApplicationId] [int] NULL,

[FeatureHistoryTagId] [int] NULL,

[Action] [varchar](50) NULL,

[SqlLogin] [varchar](200) NULL,

[UpdateWhen] [datetime] NOT NULL,

CONSTRAINT [PK_FeatureHistory] PRIMARY KEY CLUSTERED 

(

[FeatureHistoryId] ASC

)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]

) ON [PRIMARY]

GO

SET ANSI_PADDING ON

GO

ALTER TABLE [dbo].[FeatureHistory] ADD  CONSTRAINT [DF_FeatureHistory_UpdateWhen]  DEFAULT (getdate()) FOR [UpdateWhen]

GO

USE [GenApp]

GO

/****** Object:  Table [dbo].[Feature]    Script Date: 09/08/2009 10:02:32 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

SET ANSI_PADDING ON

GO

CREATE TABLE [dbo].[Feature](

[FeatureId] [int] IDENTITY(1,1) NOT NULL,

[Vote] [int] NULL,

[Key] [varchar](200) NULL,

[Title] [varchar](2000) NOT NULL,

[Description] [varchar](2000) NOT NULL,

[GenAppApplicationId] [int] NULL,

[FeatureTagId] [int] NULL,

CONSTRAINT [PK_Feature] PRIMARY KEY CLUSTERED 

(

[FeatureId] ASC

)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]

) ON [PRIMARY]

GO

SET ANSI_PADDING ON

GO

/****** Object:  Trigger [dbo].[trig_AfterDeleteOnFeature]    Script Date: 09/08/2009 10:02:32 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

-- =============================================

-- Author:        <Yordan Georgiev>

-- Create date: <Create Date,,>

-- Description:    <Description,,>

-- =============================================

CREATE TRIGGER [dbo].[trig_AfterDeleteOnFeature]    

ON  [dbo].[Feature]

for Delete

AS 

BEGIN

-- SET NOCOUNT ON added to prevent extra result sets from

-- interfering with SELECT statements.

SET NOCOUNT ON;

Insert into FeatureHistory 

( 

[FeatureId] , 

[Vote],

[Key],

[Title],

[Description],

[GenAppApplicationId],

[FeatureHistoryTagId],

[SqlLogin] , 

[Action],

[UpdateWhen]

)

select

[FeatureId] , 

[Vote],

[Key],

[Title],

[Description],

[GenAppApplicationId],

[FeatureTagId],

user_name(),

'DELETE',

getdate()

from Deleted

END

GO

/****** Object:  Trigger [dbo].[trig_AfterInsertOnFeature]    Script Date: 09/08/2009 10:02:32 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

-- =============================================

-- Author:        <Yordan Georgiev>

-- Create date: <Create Date,,>

-- Description:    <Description,,>

-- =============================================

CREATE TRIGGER [dbo].[trig_AfterInsertOnFeature]    

ON  [dbo].[Feature]

AFTER insert

AS 

BEGIN

-- SET NOCOUNT ON added to prevent extra result sets from

-- interfering with SELECT statements.

SET NOCOUNT ON;

insert     into FeatureHistory 

( 

[FeatureId] , 

[Vote],

[Key],

[Title],

[Description],

[GenAppApplicationId],

[FeatureHistoryTagId],

[Action],

[SqlLogin],

[UpdateWhen]

)

select

[FeatureId] , 

[Vote],

[Key],

[Title],

[Description],

[GenAppApplicationId],

[FeatureTagId],

'INSERT',

user_name(), 

getdate()

from Feature where FeatureId in (select FeatureId from inserted)

select current_user

END

GO

/****** Object:  Trigger [dbo].[trig_AfterUpdateOnFeature]    Script Date: 09/08/2009 10:02:32 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

-- =============================================

-- Author:        <Yordan Georgiev>

-- Create date: <Create Date,,>

-- Description:    <Description,,>

-- =============================================

CREATE TRIGGER [dbo].[trig_AfterUpdateOnFeature]    

ON  [dbo].[Feature]

AFTER UPDATE

AS 

BEGIN

-- SET NOCOUNT ON added to prevent extra result sets from

-- interfering with SELECT statements.

SET NOCOUNT ON;

insert     into FeatureHistory 

(

[FeatureId] ,  

[Vote],

[Key],

[Title],

[Description],

[GenAppApplicationId],

[FeatureHistoryTagId],

[SqlLogin] , 

[Action],

[UpdateWhen]

)

select

[FeatureId] , 

[Vote],

[Key],

[Title],

[Description],

[GenAppApplicationId],

[FeatureTagId],

user_name() , 

'UPDATE'  , 

getdate()

from Feature where FeatureId in (select FeatureId from inserted)

END

GO