摘要：Sometimes, we might encounter such error from SSIS:The transaction log for database '@dbname' is full. To find out why space in the log cannot be reused, see the log_reuse_wait_desc column in sys.data... 阅读全文

摘要：SQL Server和Oracle的查询通配符有所区别，%功能相同，Oracle中使用的？在SQLSERVER中以下划线'_'取代。另外还有方括号[]等，用法大致相同。 Wildcard character Description Example % Any string of zero or more characters. WHERE title LIKE '%computer%' finds... 阅读全文