![](https://img-blog.csdnimg.cn/20201014180756916.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
sqlserver
iteye_15129
这个作者很懒,什么都没留下…
展开
-
java调用sqlserver存储过程
package com.senlany.service.impl.k3;import java.io.IOException;import java.io.OutputStream;import java.sql.CallableStatement;import java.sql.Connection;import java.sql.ResultSet;import java.sql.Result...原创 2015-05-30 15:54:56 · 119 阅读 · 0 评论 -
获取sqlserver数据库中临时表的方法
select name from tempdb.sys.columns where object_id = object_id('tempdb..##financial_report_table')原创 2015-06-02 11:20:07 · 816 阅读 · 0 评论 -
with as 及 update
with a as(select a.EmplID, a.WorkID,a.EmplName,b.Pws from HrEmployee ainner join EquFinger bon b.EmplID=a.EmplID)--select b.ssn,b.name,b.cardno,a.pws,a.workid,a.emplname ,c.WorkIDupdate c set workid=b...原创 2015-04-23 17:38:10 · 818 阅读 · 0 评论