Basic insert, delete, update command in SQL

Hi... these are just a basic insert, delete, and update command in database SQL (200, 2005) .

Example data

Database name: user

Table name: user_t

Columns: user_id,lname,fname,username,password,usertype

____________________________________________________________________________

Insert command

Insert into user_t (user_id, lname, fname, username, password, usertype) values (@parameter1, @parameter2, @parameter3, @parameter4, @parameter5, @parameter6)

It means, @parameter1 is a value that points to user_id, @parameter2 points to lname and so on…..

Update command

Update user_t set lname = @parameter1, fname = @parameter2, username = @parameter3, password = @parameter4, usertype = @parameter5 where user_id like @parameter6

Delete command

Delete from user_t where user_id like @parameter1

To download SQL server 2005 express edition and .Net framework 2.0 click here.

To download Visual Studio 2005 click here.