stored procedures

[vlitim]

I am new to SQL and am trying to create a stored procedure that will read a semicolon delimited text file into a table. Any help on this would be much appreciated!

Cheers
Tim

 

[fluteplr]

Rather that use a stored procedure, look at data transfer services (DTS). Assumming you are using sql 7 or 2000.

 

[vlitim]

The reason I wanted to do it as a stored procedure is because I need to be able to call it from an internet page.

 

[foxdev]

You can create a stored procedure that uses the BULK INSERT command, and you'll want to use the FIELDTERMINATOR option to specify semicolons. Robert Bradley

http://www.foxdev.com/

Coming Soon:

http://www.lowcostprints.com

http://www.agrainofhope.org

 

[vlitim]

I have no idea how to go about this, is there a decent reference site for stored procedures for beginners?

 

[foxdev]

No idea how to 1) create a stored procedure or 2) how to use Bulk Insert?

1) See CREATE PROCEDURE in Books Online; basically, its:
[tt]create procedure myproc as
select * from mytable[/tt]
This is a simple example, but you get the idea - any single or series of SQL Statements can be used within the SP.

2) Join the crowd. You can trial-and-error it from Query Analyzer using a test file and test table, then use that as the basis for your stored procedure. Robert Bradley

http://www.foxdev.com/

http://www.lowcostprints.com

http://www.agrainofhope.org