SQL routine Development notes (Continuous updates)

In the update of SQLCHARINDEXSQL 2008, I like MERGE most, and OFFSET is used in MySQL 2012. New paging feature of SQL2012 OFFSET: ordebyaaoffset10and20SQL: users with digits after fuzzy query matching

In the update of SQL charindex SQL 2008, I like MERGE most and OFFSET in MySQL 2012. SQL 2012 new paging feature OFFSET: orde by aa offset 10 and 20 SQL fuzzy query matches users with numbers

SQL CHARINDEX

In the SQL 2008 update, the server space and the Hong Kong server are in MERGE, which is OFFSET in 2012.

SQL 2012 new paging feature OFFSET: orde by aa offset 10 and 20

SQL fuzzy query matching is followed by a number

Users: Hong Kong Virtual Host