数据库操作基本SQL语句

1、查询语句

select * from tb_test

2、修改语句

update tb_test

set

    testnumber = 2,

    testname = 'name'

    where testid = 1

go

3、删除语句

delete from tb_test where testid = 1

4、插入语句

insert into tb_test(testid,testname) values(1,'name')

5、创建存储过程

create procedure Proc_test

    @testid int,

    @testname

as

select * from tb_test

    where testid = @testid and testname = @testname

go