一些不错的sql语句(面试可能碰到哦!)
例子1) 一个表Table_1 有两个字段
id number,
name varchar2(7)
其中id是主键,name有重复记录
要求删除name字段重复的记录,保留其中id字段值最小的那条记录
如:
id name
1 test
2 test
3 test
4 test1
5 test1
6 test1
删完 了保留
1 test
4 test1
&nbs
相关文档:
1 Export data to existing EXCEL file
from SQL Server table
insert into OPENROWSET('Microsoft.Jet.OLEDB.4.0',
'Excel 8.0;Database=D:\testing.xls;',
'SELECT * from [SheetName$]') select * from SQLServerTable
2 Export data from Excel to new SQL Server table
select *
into SQLServerTab ......
sp_configure 'allow updates', 1
GO
reconfigure with override
GO
update syscolumns set colstat = colstat & 0x0000
where id=object_id('表名') and name='列名'
GO
sp_configure 'allow updates', 0 ......
select c0501 "订单编号",
c0503 "供应商编码",a0302 "供应商名称",
to_char(c0515,'yyyy.mm.dd') "订货日期",
to_char(c0516,'yyyy.mm.dd') "预定交货日期"
from c05,a03 where c0503=a0301 and
&nb ......
c06 --------------7545623条
c05---------------1032652条
vc01--------------427741条
SQL Statement from editor:
select c0602 "商品编码",c0625 "商品条码",
c0103 "商品名称",c0104 "规格",c060 ......
一、基础
1、说明:创建数据库
CREATE DATABASE database-name
2、说明:删除数据库
drop database dbname
3、说明:备份sql server
--- 创建 备份数据的 device
USE master
EXEC sp_addumpdevice 'disk', 'testBack', 'c:\mssql7backup\MyNwind_1.dat'
--- 开始 备份
BACKUP DATABASE pubs TO testBack
4、说 ......