{"id":1030,"date":"2021-06-26T17:19:16","date_gmt":"2021-06-26T09:19:16","guid":{"rendered":"http:\/\/www.haoht.com.cn\/?p=1030"},"modified":"2021-06-29T11:56:37","modified_gmt":"2021-06-29T03:56:37","slug":"%e5%b0%86%e4%b8%aa%e4%ba%ba%e7%bd%91%e7%9b%98%e6%96%87%e4%bb%b6%e8%bd%ac%e7%a7%bb%ef%bc%88%e7%94%a8%e6%88%b7a%e8%bd%ac%e8%87%b3%e7%94%a8%e6%88%b7b%e6%8c%87%e5%ae%9a%e7%9b%ae%e5%bd%95%e4%b8%8b%ef%bc%89","status":"publish","type":"post","link":"http:\/\/www.haoht.com.cn\/1030\/","title":{"rendered":"\u5c06\u4e2a\u4eba\u7f51\u76d8\u6587\u4ef6\u8f6c\u79fb\uff08\u7528\u6237A\u8f6c\u81f3\u7528\u6237B\u6307\u5b9a\u76ee\u5f55\u4e0b\uff09"},"content":{"rendered":"
— \u4e2a\u4eba\u7f51\u76d8\u7528\u6237A \u6240\u6709\u7f51\u76d8\u6570\u636e\u90fd\u8f6c\u81f3 \u7528\u6237B \u6839\u76ee\u5f55\u4e0b\u7684\u4e00\u4e2a\u76ee\u5f55\u4e2d\uff08\u6b64\u76ee\u5f55\u81ea\u52a8\u521b\u5efa\uff0c\u540d\u79f0\uff1a\u8f6c\u81ea\u3010\u7528\u6237A\u3011_YYYYmmdd\uff09<\/div>\n
BEGIN<\/div>\n
\u00a0 Declare @strUserLogin1 as nvarchar(32)<\/div>\n
\u00a0 Declare @strUserLogin2 as nvarchar(32)<\/div>\n
\u00a0 Declare @strUserName1 as nvarchar(64)<\/div>\n
\u00a0 Declare @strUserName2 as nvarchar(64)<\/div>\n
\u00a0 Declare @nUserIndex1 as int<\/div>\n
\u00a0 Declare @nUserIndex2 as int<\/div>\n
\u00a0 Declare @strTabIndex1 as nchar(1)<\/div>\n
\u00a0 Declare @strTabIndex2 as nchar(1)<\/div>\n
\u00a0 Declare @strCatalogID as nvarchar(36)<\/div>\n
\u00a0 Declare @strCatalogName as nvarchar(64)<\/div>\n
\u00a0 Declare @strSQL as nvarchar(1024)<\/div>\n
\u00a0 Declare @strOwner as nvarchar(32)<\/div>\n
\u00a0 Declare @strOwnerName as nvarchar(64)<\/div>\n
\u00a0 Declare @nNDIndex as int<\/div>\n
\u00a0 Declare @strDate as nvarchar(8)<\/div>\n
<\/div>\n
\u00a0 — \u6307\u5b9a\u7528\u6237A \u4e0e \u7528\u6237B \u7684\u767b\u5f55\u540d\uff0c\u6700\u597d\u5c0f\u5199<\/div>\n
\u00a0 Set @strUserLogin1 = N’\u7528\u6237A’<\/div>\n
\u00a0 Set @strUserLogin2 = N’\u7528\u6237B’<\/div>\n
<\/div>\n
\u00a0 Set @nUserIndex1 = -1<\/div>\n
\u00a0 Set @nUserIndex2 = -1<\/div>\n
\u00a0 — \u7533\u8bf7\u6e38\u6807\uff0c\u5f97\u5230\u7528\u6237\u4e2a\u4eba\u7f51\u76d8\u4fe1\u606f<\/div>\n
\u00a0 Declare userindex_cursor cursor for (SELECT Lower( CN_S_OWNER_ID ), CN_S_OWNER_NAME, CN_N_NDX FROM OI_ND_USER WHERE CN_S_OWNER_ID IN ( @strUserLogin1, @strUserLogin2 ) )<\/div>\n
\u00a0 — \u6253\u5f00\u6e38\u6807<\/div>\n
\u00a0 Open userindex_cursor<\/div>\n
<\/div>\n
\u00a0 — \u5f00\u59cb\u5faa\u73af\u6e38\u6807\u53d8\u91cf<\/div>\n
\u00a0 Fetch Next From userindex_cursor into @strOwner, @strOwnerName, @nNDIndex<\/div>\n
\u00a0 — FETCH \u540e\u7684\u6e38\u6807\u72b6\u6001<\/div>\n
\u00a0 While @@FETCH_STATUS = 0<\/div>\n
\u00a0 Begin<\/div>\n
\u00a0 \u00a0 If @strOwner = @strUserLogin1<\/div>\n
\u00a0 \u00a0 Begin<\/div>\n
\u00a0 \u00a0 \u00a0 Set @nUserIndex1 = @nNDIndex<\/div>\n
\u00a0 \u00a0 \u00a0 Set @strUserName1 = @strOwnerName<\/div>\n
\u00a0 \u00a0 End<\/div>\n
\u00a0 \u00a0 Else<\/div>\n
\u00a0 \u00a0 Begin<\/div>\n
\u00a0 \u00a0 \u00a0 Set @nUserIndex2 = @nNDIndex<\/div>\n
\u00a0 \u00a0 \u00a0 Set @strUserName2 = @strOwnerName<\/div>\n
\u00a0 \u00a0 End<\/div>\n
<\/div>\n
\u00a0 \u00a0 — \u8f6c\u5230\u4e0b\u4e00\u4e2a\u6e38\u6807<\/div>\n
\u00a0 \u00a0 Fetch Next From userindex_cursor into @strOwner, @strOwnerName, @nNDIndex<\/div>\n
\u00a0 End<\/div>\n
<\/div>\n
\u00a0 — \u5173\u95ed\u6e38\u6807<\/div>\n
\u00a0 Close userindex_cursor<\/div>\n
\u00a0 — \u91ca\u653e\u6e38\u6807<\/div>\n
\u00a0 Deallocate userindex_cursor<\/div>\n
<\/div>\n
\u00a0 — \u5224\u65ad\u7528\u6237\u7d22\u5f15<\/div>\n
\u00a0 If @nUserIndex1 = -1 Or @nUserIndex2 = -1<\/div>\n
\u00a0 Begin<\/div>\n
\u00a0 \u00a0 Print N’\u6307\u5b9a\u7684\u7528\u6237\u4e0d\u5b58\u5728’<\/div>\n
\u00a0 \u00a0 Return<\/div>\n
\u00a0 End<\/div>\n
<\/div>\n
\u00a0 — \u751f\u6210\u8868\u7d22\u5f15<\/div>\n
\u00a0 Set @strTabIndex1 = Str( @nUserIndex1, 1 )<\/div>\n
\u00a0 Set @strTabIndex2 = Str( @nUserIndex2, 1 )<\/div>\n
<\/div>\n
\u00a0 — \u5728\u7528\u6237B\u6839\u76ee\u5f55\u4e0b\u521b\u5efa\u5b58\u653e\u8f6c\u79fb\u6570\u636e\u7684\u76ee\u5f55\uff1a\u8f6c\u81ea\u3010\u7528\u6237A\u3011_YYYYmmdd<\/div>\n
\u00a0 Print N’\u521b\u5efa\u8f6c\u79fb\u6570\u636e\u7684\u76ee\u5f55’<\/div>\n
\u00a0 Set @strCatalogID = NewID()<\/div>\n
\u00a0 Set @strDate = Left( Convert( char(8), GetDate(), 112 ), 8 )<\/div>\n
\u00a0 Set @strCatalogName = ‘\u8f6c\u81ea\u3010’ + @strUserName1 + ‘\u3011_’ + @strDate<\/div>\n
\u00a0 Set @strSQL = N’INSERT INTO OI_ND_CATALOG ( CN_S_ID, CN_S_NAME, CN_N_DOC_LIST_TYPE, CN_N_SHARE, CN_S_CREATOR_ID, CN_S_CREATOR, CN_T_CREATE, CN_N_ORDER, CN_S_PARENTID ) ‘ +<\/div>\n
N’VALUES ( ”’ + @strCatalogID + ”’, ”’ + @strCatalogName + ”’, 0, 0, ”’ + @strUserLogin2 + ”’, ”’ + @strUserName2 + ”’, GetDate(), 0, ”” )’<\/div>\n
\u00a0 EXEC( @strSQL )<\/div>\n
<\/div>\n
\u00a0 — \u7d22\u5f15\u503c\u76f8\u540c\uff0c\u76f4\u63a5\u66ff\u6362<\/div>\n
\u00a0 If @nUserIndex1 = @nUserIndex2<\/div>\n
\u00a0 Begin<\/div>\n
\u00a0 \u00a0 Print N’\u7528\u6237\u7d22\u5f15\u76f8\u540c’<\/div>\n
\u00a0 \u00a0 — \u4e2a\u4eba\u6587\u6863\u8868<\/div>\n
\u00a0 \u00a0 Print N’\u4e2a\u4eba\u6587\u6863\u8868’<\/div>\n
\u00a0 \u00a0 Set @strSQL = N’UPDATE OI_ND_DOC_’ + @strTabIndex1 + N’ SET CN_S_CREATOR_ID = ”’ + @strUserLogin2 + N”’, CN_S_CREATOR = ”’ + @strUserName2 + N”’ WHERE CN_S_CREATOR_ID = ”’ + @strUserLogin1 + N””<\/div>\n
\u00a0 \u00a0 EXEC( @strSQL )<\/div>\n
<\/div>\n
\u00a0 \u00a0 — \u6839\u7ea7\u76ee\u5f55\u6587\u6863<\/div>\n
\u00a0 \u00a0 Print N’\u6839\u7ea7\u76ee\u5f55\u6587\u6863’<\/div>\n
\u00a0 \u00a0 Set @strSQL = N’UPDATE OI_ND_CATALOG_HLINK_’ + @strTabIndex1 + N’ SET CN_S_CREATOR_ID = ”’ + @strUserLogin2 + N”’, CN_S_CATALOG_ID = ”’ + @strCatalogID + N”’ WHERE (CN_S_CATALOG_ID IS NULL OR CN_S_CATALOG_ID = ””) AND CN_S_CREATOR_ID = ”’ + @strUserLogin1 + N””<\/div>\n
\u00a0 \u00a0 EXEC( @strSQL )<\/div>\n
\u00a0 \u00a0 — \u5b50\u7ea7\u76ee\u5f55\u6587\u6863<\/div>\n
\u00a0 \u00a0 Print N’\u5b50\u7ea7\u76ee\u5f55\u6587\u6863’<\/div>\n
\u00a0 \u00a0 Set @strSQL = N’UPDATE OI_ND_CATATLOG_HLINK_’ + @strTabIndex1 + N’ SET CN_S_CREATOR_ID = ”’ + @strUserLogin2 + N”’ WHERE CN_S_CREATOR_ID = ”’ + @strUserLogin1 + N””<\/div>\n
\u00a0 \u00a0 EXEC( @strSQL )<\/div>\n
\u00a0 End<\/div>\n
\u00a0 — \u7d22\u5f15\u503c\u4e0d\u540c\uff0c\u6570\u636e\u8bb0\u5f55\u8fc1\u79fb\uff08\u8bb0\u5f55\u590d\u5236\u81f3 B\u7528\u6237\u7d22\u5f15\u8868\uff0c\u5220\u9664A\u7528\u6237\u7d22\u5f15\u8868\u8bb0\u5f55\uff09<\/div>\n
\u00a0 Else<\/div>\n
\u00a0 Begin<\/div>\n
\u00a0 \u00a0 Print N’\u7528\u6237\u7d22\u5f15\u4e0d\u76f8\u540c’<\/div>\n
\u00a0 \u00a0 — \u4e2a\u4eba\u6587\u6863\u8868\uff0c\u590d\u5236<\/div>\n
\u00a0 \u00a0 Print N’\u4e2a\u4eba\u6587\u6863\u8868\uff0c\u590d\u5236’<\/div>\n
\u00a0 \u00a0 Set @strSQL = N’INSERT INTO OI_ND_DOC_’ + @strTabIndex2 + N’ ( CN_S_ID, CN_S_FILE_NAME, CN_S_FILE_TYPE, CN_N_FILE_SIZE, CN_T_FILE_DATETIME, CN_S_FILE_MD5, CN_S_FILE_SERVER, CN_G_FILE_ID, CN_G_PDF_FILE_ID, CN_G_FLASH_FILE_ID, CN_G_THUMB_IMAGE_ID, CN_S_THUMB_URL, ‘ +<\/div>\n
N’CN_S_CREATOR_ID, CN_S_CREATOR, CN_T_CREATE, CN_S_VERSION, CN_S_TAGS_NAME, CN_N_SHARE, CN_N_MOD, CN_S_NOTE, CN_S_SYS_NOTE ) ‘ +<\/div>\n
N’SELECT CN_S_ID, CN_S_FILE_NAME, CN_S_FILE_TYPE, CN_N_FILE_SIZE, CN_T_FILE_DATETIME, CN_S_FILE_MD5, CN_S_FILE_SERVER, CN_G_FILE_ID, CN_G_PDF_FILE_ID, CN_G_FLASH_FILE_ID, CN_G_THUMB_IMAGE_ID, CN_S_THUMB_URL, ‘ +<\/div>\n
N”” + @strUserLogin2 + N”’, ”’ + @strUserName2 + N”’, CN_T_CREATE, CN_S_VERSION, CN_S_TAGS_NAME, CN_N_SHARE, CN_N_MOD, CN_S_NOTE, CN_S_SYS_NOTE ‘ +<\/div>\n
N’FROM OI_ND_DOC_’ + @strTabIndex1 +<\/div>\n
N’ WHERE CN_S_CREATOR_ID = ”’ + @strUserLogin1 + N””<\/div>\n
\u00a0 \u00a0 EXEC( @strSQL )<\/div>\n
\u00a0 \u00a0 — \u5220\u9664<\/div>\n
\u00a0 \u00a0 Print N’\u4e2a\u4eba\u6587\u6863\u8868\uff0c\u5220\u9664’<\/div>\n
\u00a0 \u00a0 Set @strSQL = N’DELETE OI_ND_DOC_’ + @strTabIndex1 + N’ WHERE CN_S_CREATOR_ID = ”’ + @strUserLogin1 + N””<\/div>\n
\u00a0 \u00a0 EXEC( @strSQL )<\/div>\n
<\/div>\n
\u00a0 \u00a0 — \u6839\u7ea7\u76ee\u5f55\u6587\u6863\uff0c\u590d\u5236<\/div>\n
\u00a0 \u00a0 Print N’\u6839\u7ea7\u76ee\u5f55\u6587\u6863\uff0c\u590d\u5236’<\/div>\n
\u00a0 \u00a0 Set @strSQL = N’INSERT INTO OI_ND_CATALOG_HLINK_’ + @strTabIndex2 + N’ ( CN_S_CREATOR_ID, CN_S_CATALOG_ID, CN_S_OBJ_ID, CN_S_DISPLAY_NAME, CN_S_FILE_TYPE, CN_N_FILE_SIZE, CN_S_THUMB_URL, CN_T_FILE_DATETIME, CN_S_EXTATTR, CN_N_SHARE, CN_T_LINK, CN_S_TAGS ) ‘ +<\/div>\n
N’SELECT ”’ + @strUserLogin2 + N”’, ”’ + @strCatalogID + N”’, CN_S_OBJ_ID, CN_S_DISPLAY_NAME, CN_S_FILE_TYPE, CN_N_FILE_SIZE, CN_S_THUMB_URL, CN_T_FILE_DATETIME, CN_S_EXTATTR, CN_N_SHARE, CN_T_LINK, CN_S_TAGS ‘ +<\/div>\n
N’FROM OI_ND_CATALOG_HLINK_’ + @strTabIndex1 +<\/div>\n
N’ WHERE (CN_S_CATALOG_ID IS NULL OR CN_S_CATALOG_ID = ””) AND CN_S_CREATOR_ID = ”’ + @strUserLogin1 + N””<\/div>\n
\u00a0 \u00a0 EXEC( @strSQL )<\/div>\n
\u00a0 \u00a0 — \u5220\u9664<\/div>\n
\u00a0 \u00a0 Print N’\u6839\u7ea7\u76ee\u5f55\u6587\u6863\uff0c\u5220\u9664’<\/div>\n
\u00a0 \u00a0 Set @strSQL = N’DELETE OI_ND_CATALOG_HLINK_’ + @strTabIndex1 + N’ WHERE (CN_S_CATALOG_ID IS NULL OR CN_S_CATALOG_ID = ””) AND CN_S_CREATOR_ID = ”’ + @strUserLogin1 + N””<\/div>\n
\u00a0 \u00a0 EXEC( @strSQL )<\/div>\n
<\/div>\n
\u00a0 \u00a0 — \u5b50\u7ea7\u76ee\u5f55\u6587\u6863\uff0c\u590d\u5236<\/div>\n
\u00a0 \u00a0 Print N’\u5b50\u7ea7\u76ee\u5f55\u6587\u6863\uff0c\u590d\u5236’<\/div>\n
\u00a0 \u00a0 Set @strSQL = N’INSERT INTO OI_ND_CATALOG_HLINK_’ + @strTabIndex2 + N’ ( CN_S_CREATOR_ID, CN_S_CATALOG_ID, CN_S_OBJ_ID, CN_S_DISPLAY_NAME, CN_S_FILE_TYPE, CN_N_FILE_SIZE, CN_S_THUMB_URL, CN_T_FILE_DATETIME, CN_S_EXTATTR, CN_N_SHARE, CN_T_LINK, CN_S_TAGS ) ‘ +<\/div>\n
N’SELECT ”’ + @strUserLogin2 + N”’, CN_S_CATALOG_ID, CN_S_OBJ_ID, CN_S_DISPLAY_NAME, CN_S_FILE_TYPE, CN_N_FILE_SIZE, CN_S_THUMB_URL, CN_T_FILE_DATETIME, CN_S_EXTATTR, CN_N_SHARE, CN_T_LINK, CN_S_TAGS ‘ +<\/div>\n
N’FROM OI_ND_CATALOG_HLINK_’ + @strTabIndex1 +<\/div>\n
N’ WHERE CN_S_CREATOR_ID = ”’ + @strUserLogin1 + N””<\/div>\n
\u00a0 \u00a0 EXEC( @strSQL )<\/div>\n
\u00a0 \u00a0 — \u5220\u9664<\/div>\n
\u00a0 \u00a0 Print N’\u5b50\u7ea7\u76ee\u5f55\u6587\u6863\uff0c\u5220\u9664’<\/div>\n
\u00a0 \u00a0 Set @strSQL = N’DELETE OI_ND_CATALOG_HLINK_’ + @strTabIndex1 + N’ WHERE CN_S_CREATOR_ID = ”’ + @strUserLogin1 + N””<\/div>\n
\u00a0 \u00a0 EXEC( @strSQL )<\/div>\n
\u00a0 End<\/div>\n
<\/div>\n
\u00a0 — \u672a\u5206\u8868\u7684\u6570\u636e\u8868\uff0c\u76f4\u63a5\u66ff\u6362<\/div>\n
\u00a0 — \u56de\u6536\u7ad9\uff0c\u539f\u6839\u76ee\u5f55\u6587\u6863<\/div>\n
\u00a0 Print N’\u56de\u6536\u7ad9\uff0c\u539f\u6839\u76ee\u5f55\u6587\u6863’<\/div>\n
\u00a0 Set @strSQL = N’UPDATE OI_ND_DOC_DELETE SET CN_S_CREATOR_ID = ”’ + @strUserLogin2 + N”’, CN_S_CREATOR = ”’ + @strUserName2 + N”’, CN_S_DELETED_BY_ID = ”’ + @strUserLogin2 + N”’, CN_S_DELETED_BY = ”’ + @strUserName2 + N”’, CN_G_CATALOG_ID = ”’ + @strCatalogID + N”’ ‘ +<\/div>\n
N’WHERE (CN_G_CATALOG_ID IS NULL OR CN_G_CATALOG_ID = ””) AND CN_S_CREATOR_ID = ”’ + @strUserLogin1 + N””<\/div>\n
\u00a0 EXEC( @strSQL )<\/div>\n
\u00a0 — \u56de\u6536\u7ad9\uff0c\u5176\u5b83\u76ee\u5f55\u6587\u6863<\/div>\n
\u00a0 Print N’\u56de\u6536\u7ad9\uff0c\u5176\u5b83\u76ee\u5f55\u6587\u6863’<\/div>\n
\u00a0 Set @strSQL = N’UPDATE OI_ND_DOC_DELETE SET CN_S_CREATOR_ID = ”’ + @strUserLogin2 + N”’, CN_S_CREATOR = ”’ + @strUserName2 + N”’, CN_S_DELETED_BY_ID = ”’ + @strUserLogin2 + N”’, CN_S_DELETED_BY = ”’ + @strUserName2 + N”’ ‘ +<\/div>\n
N’WHERE CN_S_CREATOR_ID = ”’ + @strUserLogin1 + N””<\/div>\n
\u00a0 EXEC( @strSQL )<\/div>\n
<\/div>\n
\u00a0 — \u5386\u53f2\u8868<\/div>\n
\u00a0 Print N’\u5386\u53f2\u8868’<\/div>\n
\u00a0 Set @strSQL = N’UPDATE OI_ND_DOC_HISTORY SET CN_S_CREATOR_ID = ”’ + @strUserLogin2 + N”’, CN_S_CREATOR = ”’ + @strUserName2 + N”’, CN_S_OPERATOR_ID = ”’ + @strUserLogin2 + N”’, CN_S_OPERATOR = ”’ + @strUserName2 + N”’ ‘ +<\/div>\n
N’WHERE CN_S_CREATOR_ID = ”’ + @strUserLogin1 + N””<\/div>\n
\u00a0 EXEC( @strSQL )<\/div>\n
<\/div>\n
\u00a0 — \u6839\u7ea7\u76ee\u5f55<\/div>\n
\u00a0 Print N’\u6839\u7ea7\u76ee\u5f55’<\/div>\n
\u00a0 Set @strSQL = N’UPDATE OI_ND_CATALOG SET CN_S_CREATOR_ID = ”’ + @strUserLogin2 + N”’, CN_S_CREATOR = ”’ + @strUserName2 + N”’, CN_S_PARENTID = ”’ + @strCatalogID + N”’ ‘ +<\/div>\n
N’WHERE (CN_S_PARENTID IS NULL OR CN_S_PARENTID = ””) AND CN_S_CREATOR_ID = ”’ + @strUserLogin1 + N””<\/div>\n
\u00a0 EXEC( @strSQL )<\/div>\n
\u00a0 — \u5b50\u7ea7\u76ee\u5f55<\/div>\n
\u00a0 Print N’\u5b50\u7ea7\u76ee\u5f55’<\/div>\n
\u00a0 Set @strSQL = N’UPDATE OI_ND_CATALOG SET CN_S_CREATOR_ID = ”’ + @strUserLogin2 + N”’, CN_S_CREATOR = ”’ + @strUserName2 + N”’ ‘ +<\/div>\n
N’WHERE CN_S_CREATOR_ID = ”’ + @strUserLogin1 + N””<\/div>\n
\u00a0 EXEC( @strSQL )<\/div>\n
<\/div>\n
\u00a0 — \u5171\u4eab\u51fa\u53bb\u4fe1\u606f\u66ff\u6362<\/div>\n
\u00a0 Print N’\u5171\u4eab\u51fa\u53bb\u4fe1\u606f\u66ff\u6362’<\/div>\n
\u00a0 Set @strSQL = N’UPDATE OI_ND_SHARE_OUT SET CN_S_CREATOR_ID = ”’ + @strUserLogin2 + N”’ WHERE CN_S_CREATOR_ID = ”’ + @strUserLogin1 + N””<\/div>\n
\u00a0 EXEC( @strSQL )<\/div>\n
<\/div>\n
\u00a0 — \u5220\u9664\u5171\u4eab\u8fdb\u6765 A -> B\uff0cB -> A \u8bb0\u5f55<\/div>\n
\u00a0 Print N’\u5220\u9664\u5171\u4eab\u8fdb\u6765 A -> B\uff0cB -> A \u8bb0\u5f55’<\/div>\n
\u00a0 Set @strSQL = N’DELETE OI_ND_SHARE_IN WHERE (CN_S_CREATOR_ID = ”’ + @strUserLogin1 + N”’ AND CN_S_SHARER_ID = ”’ + @strUserLogin2 + N”’) OR (CN_S_CREATOR_ID = ”’ + @strUserLogin2 + N”’ AND CN_S_SHARER_ID = ”’ + @strUserLogin1 + N”’)’<\/div>\n
\u00a0 EXEC( @strSQL )<\/div>\n
\u00a0 — \u5171\u4eab\u8fdb\u6765\u4fe1\u606f\u66ff\u6362<\/div>\n
\u00a0 Print N’\u5171\u4eab\u8fdb\u6765\u4fe1\u606f\u66ff\u6362’<\/div>\n
\u00a0 Set @strSQL = N’UPDATE OI_ND_SHARE_IN SET CN_S_CREATOR_ID = ”’ + @strUserLogin2 + N”’, CN_S_CREATOR = ”’ + @strUserName2 + N”’ WHERE CN_S_CREATOR_ID = ”’ + @strUserLogin1 + N””<\/div>\n
\u00a0 EXEC( @strSQL )<\/div>\n
END<\/div>\n
GO<\/div>\n","protected":false},"excerpt":{"rendered":"

— \u4e2a\u4eba\u7f51\u76d8\u7528\u6237A \u6240\u6709\u7f51\u76d8\u6570\u636e\u90fd\u8f6c\u81f3 \u7528\u6237B \u6839\u76ee\u5f55\u4e0b\u7684\u4e00\u4e2a\u76ee\u5f55\u4e2d\uff08\u6b64\u76ee\u5f55\u81ea\u52a8\u521b\u5efa\uff0c\u540d\u79f0\uff1a\u8f6c\u81ea\u3010 […]<\/p>\n","protected":false},"author":1,"featured_media":1029,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[6,2],"tags":[15],"class_list":["post-1030","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-ercikf","category-pcenter","tag-sql"],"_links":{"self":[{"href":"http:\/\/www.haoht.com.cn\/wp-json\/wp\/v2\/posts\/1030","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/www.haoht.com.cn\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.haoht.com.cn\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.haoht.com.cn\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/www.haoht.com.cn\/wp-json\/wp\/v2\/comments?post=1030"}],"version-history":[{"count":1,"href":"http:\/\/www.haoht.com.cn\/wp-json\/wp\/v2\/posts\/1030\/revisions"}],"predecessor-version":[{"id":1031,"href":"http:\/\/www.haoht.com.cn\/wp-json\/wp\/v2\/posts\/1030\/revisions\/1031"}],"wp:featuredmedia":[{"embeddable":true,"href":"http:\/\/www.haoht.com.cn\/wp-json\/wp\/v2\/media\/1029"}],"wp:attachment":[{"href":"http:\/\/www.haoht.com.cn\/wp-json\/wp\/v2\/media?parent=1030"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.haoht.com.cn\/wp-json\/wp\/v2\/categories?post=1030"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.haoht.com.cn\/wp-json\/wp\/v2\/tags?post=1030"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}