jqs7807151的博客

-----判定实体表是否存在 IF EXISTS ( SELECT * FROM sys.objects WHERE NAME = 'test' ) BEGIN DROP TABLE test END -----判定临时表是否存在 IF OBJECT_ID('tempdb..#...

select * from tablle1 WHERE field1 LIKE N'%[啊-座]%'