MERGE语句使用

 string strsql = string.Format(@"MERGE INTO hisbf..ZY_PrintReport_Rows as A
                                USING(select @ID as ID) as B
                                ON a.ID = B.ID
                                WHEN MATCHED THEN
                                UPDATE SET a.DJZDMC = @DJZDMC,a.DJZDDM = @DJZDDM,a.ROWINDEX = @ROWINDEX,a.Visible = @Visible
                                WHEN NOT MATCHED THEN
                                INSERT(DJID ,DJZDMC ,DJZDDM ,ROWINDEX ,Visible)
                                VALUES (@DJID,@DJZDMC,@DJZDDM,@ROWINDEX,@Visible);");
                SqlParameter[] parms = new SqlParameter[] {
                        new SqlParameter("@ID", SqlDbType.Char,36){ Value = ZDID.ToUpper() },
                        new SqlParameter("@DJID",zY_PRINTREPORT.ID.ToString()),
                        new SqlParameter("@DJZDMC",tbxcaption.EditValue.ToString()),
                        new SqlParameter("@DJZDDM",tbxfiledname.EditValue.ToString()),
                        new SqlParameter("@ROWINDEX",sptVisibleIndex.EditValue.ToString()),
                        new SqlParameter("@Visible",checkEdit1.Checked==true?1:0),
                 };