请问,我要导出数据库中以某些字母开头的所有表数据,什么方法最快?代码最少?且能实现事务
请问,我要导出数据库中以某些字母开头的所有表数据,什么方法最快?代码最少?
且能实现事务
------解决方案--------------------declare @tt table
(string varchar(10))
insert into @tt
select 'caaaaaaaa '
union select 'baaaaaaaa '
union select 'Aaaaaaaaa '
union select 'Zaaaaaaaa '
union select '1aaaaaaaa '
select * from @tt where
(ASCII(string)> =65 and ASCII(string) <=90)
or
(ASCII(string)> =97 and ASCII(string) <=122)