How to count the number of lines in an external OS file? Will work for ASCII files only. [ All Languages » SQL Server »  T-SQL] Total Hit ( 3285) Rate this article:     Poor     Excellent   Submit Your Question/Comment about this article Rating

Click here to copy the following block CREATE TABLE #file ( line varchar(255) null ); INSERT #file EXEC master..xp_cmdshell 'type c:\boot.ini'; SELECT * FROM #file; -- Data from the text file: /* line                                                                                                                               --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- [Boot Loader] timeout=10 Default=C:\ NULL [Operating Systems] multi(0)disk(0)rdisk(0)partition(1)\WINNT="Microsoft Windows 2000 Server" /fastdetect C:\="Microsoft Windows 98" C:\CMDCONS\BOOTSECT.DAT="Microsoft Windows 2000 Recovery Console" /cmdcons NULL */ SELECT count(*) AS NumLines FROM #file; /* NumLines   -----------      9 */

Related Article(s)

Get listing of files in a specified directory or a network share. This stored procedure also return some useful information (e.g. date, times, directory, filesize, filename)

Copy text or image into or out of SQL Server

Export data to excel file

How to compare rows in tables without writing a SELECT with all the conditions? Can be used for simple dirty work & of course if you are lazy to type.

File details using NT commands & undocumented SP.

How to check for the existence of a file from SQL Server?

How to get NT Accounts from DOMAIN.

How to get the data, tools & SQL path when there are several instances on the same server?

send NET SEND messages to all the connected SQL Server users in an NT Local Arean Network

T-SQL code to log messages to a text file on the server, from your stored procedures and SQL scripts

How to read remote registry using SQL Server.

Read current sql server error log.

Database Backup Script

Stored procedure to Send SMTP mail from SQL SERVER 2000 (Email Body max 8000 chars)

Monitoring Disk Space and Sending Alerts with TSQL

Submitted By : Nayan Patel  (Member Since : 5/26/2004 12:23:06 PM)
	Job Description : He is the moderator of this site and currently working as an independent consultant. He works with VB.net/ASP.net, SQL Server and other MS technologies. He is MCSD.net, MCDBA and MCSE. In his free time he likes to watch funny movies and doing oil painting.
View all (893) submissions by this author  (Birth Date : 7/14/1981 )