1.declare @t table(CountryRegionCode nvarchar(3))insert into @t(CountryRegionCode) (select CountryRegionCode from person.CountryRegion where Name like 'C%')
2.CREATE TABLE #tmp(FuncID UNIQUEIDENTIF...
http://www.blogjava.net/decode360/archive/2008/10/16/286802.html
create or replace type person as object( name varchar2(10), sex varchar2(2), birthday date, age number(2));
两种创建对象表的...
-- 单独查看某张表的索引情况SHOW INDEX FROM 表名称;例如：SHOW INDEX FROM area_regist;-- 查看整表的建表语句，里面同样会显示索引情况SHOW CREATE TABLE 表名称;例如：SHOW CREATE TABLE area_regist;-- 添加索...
