How to Insert Multiple Rows From SPUFI

SPUFI is vital to organizing your server's database.

SPUFI, also known as SQL Processing Using File Input, is a tool of the programming language SQL and is used specifically to create database objects. To create objects that will eventually be able to include a range of customized content, you will need to create a row or multiple rows to store the data in. This will help organize your information and lay the foundation for the entire database.

Instructions

1. Open the server management software of your choice. Some programs have their own individual language that must be used, but you can use SPUFI on any program that reads SQL.

2. Type the command that creates a row for the database:

   insert into Customers (VALUE1, VALUE2, VALUE3) values ('VALUE1', 'VALUE2', 'VALUE3')

   This statement will create a single row that you can use to customize the content that will be stored. In the case of a customer named Lucy, you could replace the first VALUE1 with Customer's Name and replace the second 'VALUE1' with Lucy. Of course, this data can always be changed at a later time. Repeat this step for as many rows as you need.

3. Save your work to keep any changes you make.

References

• Tech on the Net: SQL: INSERT Statement
• SQL Insert Into: Insert Into Statement
• Guy Bursetin's Blog: SQL Server 2008 T-SQL: Insert Multiple Rows