check temp table 2014-12-01 wo 電腦小知識 IF OBJECT_ID(‘tempdb..##test’) IS NOT NULL BEG[……]查看全部 Database, Example Query, MSSQL, Program
Delete duplicate row SQLQuery 2014-12-01 wo 電腦小知識 –loop 幾多 SET ROWCOUNT 0–check and delete[……]查看全部 Database, Example Query, MSSQL, Program
patindex like regex 2014-12-01 wo 電腦小知識 SELECT PATINDEX(‘%[^a-z]com[^a-z]%’, ‘TechOnTheNe[……]查看全部 Database, MSSQL, Program
SQL get Child Parent 2014-12-01 wo 電腦小知識 –http://forums.asp.net/t/1849469.aspx –get par[……]查看全部 Database, Example Query, MSSQL, Program
SQLQuery 2014-12-01 wo 電腦小知識 order by sort: select right(c_emp_no, len(c_emp_[……]查看全部 Database, Example Query, MSSQL, Program