34,590
社区成员
发帖
与我相关
我的任务
分享
select name from sysobjects where xtype='U' AND year(refdate)<2012
例如我要删除,多个表,建表时间小于2012年的。
咋 个删除哦,
DROP TABLE [avc], [geography], [tb_stuxs03], [sasa], [tb_stu04], [internet_sales], [tb_te04], [tb_stumark08], [kk], [tb_book04], [kdkdk], [tb_tb04], [diff], [bb], [tb_astuinfo08], [tb_student05], [isi], [store_information], [sd], [customer], [oreders], [tb_astr_home], [tb_booksell06], [aa], [wage_table], [tb_], [replace_], [custommer], [tb_amese08], [table_name], [a_a], [tb_astr], [test_a], [tb_stu06], [tb_ware06], [checks], [saa], [sb], [tee], [DEPOSITS], [sc], [tb_sell07], [iid], [BIKES], [tb_sell], [AA_BB], [sdd], [tb_seller07], [transit], [checkss], [aad], [ORGCHART], [tb_student], [aads], [dd], [scs], [TABLE1], [coursee], [TABLE2], [tb_agoods], [CUSTOMER], [tb_abig], [PART], [tb_student09], [sa], [ORDERS], [tb_course09], [tabk], [AV], [teacher09], [tb_booksell07], [COLLECTIO], [test_1], [kak], [test_2], [sk], [AAA], [test_3], [tb_xsb03], [asa], [INVENTORY], [adc], [kasf], [TEMP], [BILLS], [aca], [aabb], [ak], [bills], [tb_sell09], [skk], [bank_accounts], [company], [tb_stuscore09], [tb_namployee09], [student], [teacher], [course], [tb_user], [ab], [tb_user1], [tb_user2], [tb_series09], [tb_info], [tb_privot20], [date1], [tb_unpivot10], [tb_client11], [aaid], [CUSTOMERS], [CSVTable], [CUSTOMERSS], [grade], [tb_grade12], [BALANCES], [tb_employee12], [SALARIES], [ALBUMS], [tb_particular], [ARTISTS], [ti], [MEDIA], [tes], [RECORDINGS], [aa<P], [aa_<o], [ds], [PRODUCTS], [dd_q], [adb], [kkd], [tk], [wage], [tb_stustudent03], [tb_stumark07], [tb_student03], [tb_stuachi], [ueue], [ta], [ui], [es], [NewContact], [UI], [UIW], [tb_mid], [tb_car03], [test], [testtable1], [tb_num03], [tb_fin], [tb_stuindex03], [tb_em], [tb_apay08], [tb_booksale03], [tb_gzmx], [tb_shopping03], [tb_person03], [stuinfo03], [tb_classname04], [teast], [tb_userinfo], [t], [gen_file], [userpwd], [gem_file], [tb_yuan], [av], [函数], [avtv],
我打印出来的结果是这样,我想问一下,里面动态语句后面拼接的豆号啥意思阿。还有,SELECT @SQL=@SQL+ ' ['+NAME+']'+','
中间的,'['+NAME+']' 中括号外面和里面的引号是对中括号操作吗?起啥作用哦!declare @s varchar(1000)
select @s=isnull(@s+',','')+name from sysobjects where xtype='U'
select @s='drop table '+@s
exec(@s)
DECLARE @SQL VARCHAR(MAX)
select @SQL='DROP TABLE'
SELECT @SQL=@SQL+ ' ['+NAME+']'+','
FROM SYS.TABLES
WHERE CREATE_DATE<'2012-1-1'
PRINT (@SQL)
EXEC(@SQL)