【SQL开源代码栏目提醒】:网学会员,鉴于大家对SQL开源代码十分关注,论文会员在此为大家搜集整理了“389.sql”一文,供大家参考学习!
set nocount on
use db_Sql
if exists(select * from INFORMATION_SCHEMA.TABLES
where table_name = 'order_emp')
drop table order_emp
go
use db_Sql
IF exists(select name from sysindexes
where name = 'emp_order_ind')
drop index order_emp.emp_order_ind
GO
use db_Sql
GO
set nocount off
GO
create index ind_shop20
on tb_Shop20
(商品编号, 类别编号)
GO
Select * from tb_Shop20
With (index(ind_shop20))
GO