![](https://img-blog.csdnimg.cn/20201014180756918.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
数据库
IT-工程
从事java开发。
展开
-
sqlserver数据库merge操作
数据的覆盖操作实例MERGE INTO m_c_expense_ReportHistory ERH --目标表USING (SELECT ReportID , ReportName , Status ,Processor_Start_Date FROMm_c_expense_Report ) ER --数据源表ON (ER.ReportID = E原创 2017-01-20 20:53:34 · 556 阅读 · 0 评论 -
sqlserver 经典关联查询语句
sqlserver关联查询: SELECT EI.EMPLOYEE_NAME AS employeeName, EI.EMPLOYEE_NUMBER AS employeeNumber, EI.E_MAIL AS email, EI.EMPLOYEE_STATUS AS employeeStatus, EI.ISPEOPLEMANAGER AS isPeopl原创 2017-01-20 21:58:24 · 1576 阅读 · 0 评论