insert into 语句例

insert into Sal_operation select '" + Convert.ToString(Empno.GetKey(i)) + "','KM012',isnull(sum(Layoff_P),0),'" + user + "','" + time + "' from Sal_sins_p2 where  empno = '" + Convert.ToString(Empno.GetKey(i)) + "' and Per_SNNO = '" + snno + "' group by Empno"
posted @ 2008-09-05 14:10  XGU_Winner  阅读(171)  评论(0编辑  收藏  举报