sqlserver 在插入时应用子查询

想在插入的时候，有些字段是从别的表中查询出来的，原来的代码时

"insert into TT_MarkedCardSendRecord values （(select MarkedCardNo from TT_MarkedCard where MarkedCardCode='" + txtMarkedCode.Text.Trim() + "'),'" + txtMarkedCode.Text.Trim() + "','" + txtCollCode.Text.Trim() + "',(select KindCode from TT_CollKind where kindName='" + txtCoalKind.Text.Trim() + "'),'" + txtSendTime.Text.Trim() + "','" + HttpUtility.UrlDecode(HttpContext.Current.Request.Cookies["UserName"].Value.ToString()) + "',(select DepartName from  tXtDepart where DepartCode=(select DepartCode from tXtUser where UserName='" + HttpUtility.UrlDecode(HttpContext.Current.Request.Cookies["UserName"].Value.ToString()) + "'))）"

 

只要把原来的“values”  改成select 并且去掉values后面的（）即可

"insert into TT_MarkedCardSendRecord select (select MarkedCardNo from TT_MarkedCard where MarkedCardCode='" + txtMarkedCode.Text.Trim() + "'),'" + txtMarkedCode.Text.Trim() + "','" + txtCollCode.Text.Trim() + "',(select KindCode from TT_CollKind where kindName='" + txtCoalKind.Text.Trim() + "'),'" + txtSendTime.Text.Trim() + "','" + HttpUtility.UrlDecode(HttpContext.Current.Request.Cookies["UserName"].Value.ToString()) + "',(select DepartName from  tXtDepart where DepartCode=(select DepartCode from tXtUser where UserName='" + HttpUtility.UrlDecode(HttpContext.Current.Request.Cookies["UserName"].Value.ToString()) + "'))"

转载于:https://www.cnblogs.com/zhangenliang/archive/2008/11/24/1339956.html