Importing text files into tables in SQL Server database schemas can be done using different methods.

One method using SQL Server specific SQL is shown below.

SQL Script

If you want to use tab delimited source files you can type in the delimiter into FIELDDELIMITER using the tabulator key in SQL Server Management Studio.

BULK
INSERT CSVTest
FROM 'c:\csvtest.txt'
WITH
(
FIELDTERMINATOR = ',',
ROWTERMINATOR = '\n'
)
GO

Last Updated: 04 May 2015

Hits: 9980

If you are confronted with the inconvenience of having to truncate all tables in a database in MS SQL Server, the following T-SQL might help.

Source Code

USE [db_name]
GO
/****** Object:  StoredProcedure [dbo].[truncate_tables]    Script Date: 17.11.2014 09:23:22 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- =============================================
-- Author:		<,,Alexander Bolte>
-- Create date: <2014-10-30,,>
-- Description:	
-- =============================================
ALTER PROCEDURE [dbo].[truncate_tables]	
AS
BEGIN
	-- SET NOCOUNT ON added to prevent extra result sets from
	-- interfering with SELECT statements.
	SET NOCOUNT ON;
 
	declare tab_names cursor for
	SELECT TABLE_NAME 
	FROM INFORMATION_SCHEMA.TABLES
	WHERE TABLE_TYPE = 'BASE TABLE' 
	declare @tab_name varchar(255)
 
	OPEN tab_names
	FETCH NEXT FROM tab_names
	INTO @tab_name		
	WHILE @@FETCH_STATUS = 0
	BEGIN
	  EXECUTE ('Truncate table [' + @tab_name + '];');
	  FETCH NEXT FROM tab_names
	    INTO @tab_name
	END
	CLOSE tab_names
	DEALLOCATE tab_names
END

It is important to use the type varChar for the name @tab_name since its content is concatenated with some SQL command to truncate tables.

Last Updated: 30 July 2015

Hits: 9777

In order to divide two integer type fields in SQL Server you will have to apply a type cast before applying the mathematical operation.

Else you will receive zero (0) as a result whenever one of the numbers is not null, which is obviously not what we want.

Last Updated: 03 November 2015

Hits: 9910