SQL server常用操作sql语句介绍:
1、查询:select * from table1 where 范围
2、插入:insert into table1(field1,field2) values(value1,value2)
3、删除:delete from table1 where 范围
4、更新:update table1 set field1=value1 where 范围
5、查找:select * from table1 where field1 like ’%value1%’