Template for creating a insert script in sql server:
-----------------------------------------------------------
/*******************************************************
*This script file insert data into table TBL_TABLE_NAME*
********************************************************/
/******************************************************************
======== BEGIN MAINTENANCE WRAPPER ==========
******************************************************************/
-- Check for existence of if table
IF OBJECT_ID('dbo.TBL_TABLE_NAME') IS NOT NULL
BEGIN
-- Remove all the previous Data
TRUNCATE TABLE dbo.TBL_TABLE_NAME
PRINT 'TABLE TBL_TABLE_NAME TRUNCATED SUCCESSFULLY'
END
ELSE
BEGIN
PRINT 'TABLE TBL_TABLE_NAME DOES NOT EXISTS'
END
GO
/******************************************************************
======== END MAINTENANCE WRAPPER ==========
******************************************************************/
/********************************************************
** REVISION HISTORY : *
** ====================== *
** DATE VERSION NAME COMMENTS *
** ---------- ------- ----------------- -----------------*
** MM/DD/CCYY 1.0 Developer Name Initial Draft *
** *
*****************************************************************/
/* Insert statements like*/
INSERT INTO dbo.TBL_TABLE_NAME
(COLUMN_NAME1,
COLUMN_NAME2
, ------/* remaining column namess*/
COLUMN_NAMEN)
VALUES
('VALUE1',
'VALUE2', ------/* remaining Values*/
'VALUEN')GO
-- SELECT * FROM dbo.TBL_TABLE_NAME
