数据库sql语句有哪些呢？下面就让我们一起来了解一下吧
sql语句有很多，比较基本的sql语句有
选择select from table1 where 范围
插入insert into table1(field1,field2) values(value1,value2)
删除delete from table1 where 范围
更新update table1 set field1=value1 where 范围
查找select from table1 where field1 like ’%value1%’
排序select from table1 order by field1,field2 [desc]
总数select count as totalcount from table1
求和select sum(field1) as sumvalue from table1
平均select avg(field1) as avgvalue from table1
最大select max(field1) as maxvalue from table1
最小select min(field1) as minvalue from table1
也还有其他的sql语句，具体介绍如下
若是备份sql server
1、创建、备份数据的 device，示例代码为
USE master
EXEC sp_addumpdevice 'disk', 'testBack', 'c:\mssql7backup\MyNwind_1.dat'
2、开始、备份，示例代码为
BACKUP DATABASE pubs TO testBack
若是创建新表
示例代码为
create table tabname(col1 type1 [not null] [primary key],col2 type2 [not null],..)
若是依照已有的表创建新表
示例代码为
Acreate table tab_new like tab_old (使用旧表创建新表)
Bcreate table tab_new as select col1,col2… from tab_old definition only
若是删除新表
示例代码为
drop table tabname
