????1.????????????:
????Select * From TableName Order By CustomerName Collate Chinese_PRC_Stroke_ci_as
????2.???SQL???
????select * from(select (row_number() OVER (ORDER BY tab.ID Desc)) as rownum??tab.* from ???? As tab) As t where rownum between ???λ?? And ????λ??
????3.????????????е??????????
????select * from sysobjects where xtype='U' and category=0
????4.?????????????????
????select name from syscolumns where id=object_id('????')
????5.????????????????????洢?????????
????select a.* from sysobjects a?? syscomments b where a.id = b.id and b.text like '%????%'
????6.???????????????д洢????
????select name as ?洢???????? from sysobjects where xtype='P'
????7.?????????????????????
????select * from master..sysdatabases D where sid not in(select sid from master..syslogins where name='sa')
????????
????select dbid?? name AS DB_NAME from master..sysdatabases where sid <> 0x01
????8.????????????κ?????????
????select column_name??data_type from information_schema.columns
????where table_name = '????'
????9.???????
??????????Щ??????????????SQL????????????????SQL SERVER????????????????????????????????
???????????
????Begin tran
????Insert Into TableName Values(…)
????SQL??????????????????????
???????????
????Rollback tran
????SQL?????????????????????????????????
??????????
????Commit tran
????10. ????????????
????????? LIKE N'%[^a-zA-Z0-9]China[^a-zA-Z0-9]%'
????OR ????? LIKE N'%[^a-zA-Z0-9]China'
????OR ????? LIKE N'China[^a-zA-Z0-9]%'
????OR ????? LIKE N'China
????11?????????SQL????????
????declare @d datetime
????set @d=getdate()
????select * from SYS_ColumnProperties select [?????л??????(????)]=datediff(ms??@d??getdate())
????12??????????????????????
????A?? UNION ?????
????UNION ????????????????????????????? TABLE1 ?? TABLE2????????????κ?????ж?????????????????? ALL ?? UNION ??????????? UNION ALL??????????????С?????????￡???????????в??????? TABLE1 ?????? TABLE2??
????B?? EXCEPT ?????
????EXCEPT ?????????????????? TABLE1 ?е????? TABLE2 ?е??в?????????????ж?????????????????? ALL ?? EXCEPT ??????? (EXCEPT ALL)????????????С?
????C?? INTERSECT ?????
????INTERSECT ????????????? TABLE1 ?? TABLE2 ?ж??е??в?????????????ж?????????????????? ALL ?? INTERSECT ??????? (INTERSECT ALL)????????????С?