\u4e5f\u8bb8\u4f1a\u78b0\u5230\u8fd9\u6837\u7684\u95ee\u9898\uff1a<\/p>\n
\u6709\u4e00\u5f20\u8868\u6709\u51e0\u5341\u4e2a\u6216\u8005\u4e0a\u767e\u4e2a\u5b57\u6bb5\uff0c\u5907\u4efd\u540e\u5220\u9664\u4e86\u4e00\u90e8\u5206\u6570\u636e\uff0c\u8fc7\u540e\u53d1\u73b0\u95ee\u9898\u9700\u8981\u6062\u590d\u5176\u4e2d\u4e00\u90e8\u5206\u6570\u636e\uff0c\u4f46\u6709\u51e0\u4e2a\u5b57\u6bb5\u4e0d\u9700\u8981\u6062\u590d(\u6bd4\u5982100\u4e2a\u5b57\u6bb5\uff0c\u53ea\u9700\u6062\u590d97\u4e2a)<\/p>\n
\u521d\u5b66\u9636\u6bb5\uff1a<\/p>\n
\u5bf9\u4e8e\u4e00\u4e2a\u521d\u5b66\u8005\u53ef\u80fd\u662f\u4e2a\u5669\u68a6\uff1a”oh, my god! \u96be\u9053\u8981\u624b\u625397\u4e2a\u5b57\u6bb5\uff1f\uff1f\uff1f”\uff0c\u4e00\u8fb9\u4ece\u7f51\u4e0a\u627e\u6848\u4f8b\uff0c\u4e00\u8fb9\u82e6\u601d\u51a5\u60f3\uff0c\u6298\u817e\u5341\u51e0\u5206\u949f\uff0c\u6700\u7ec8\u8fd8\u662f\u624b\u6253…<\/p>\n
\u5165\u95e8\u9636\u6bb5\uff1a<\/p>\n
\u5bf9\u4e8e\u4e86\u89e3\u6570\u636e\u5e93\u4f46\u4e0d\u662f\u5f88\u64c5\u957f\u7f16\u5199sql\u8bed\u53e5(\u6d89\u53ca\u7cfb\u7edf\u8868)\u7684\u6280\u672f\u4eba\u5458\uff1a”\u55ef…\u8fd9\u4e2a\u53ef\u4ee5\u4ece\u5efa\u8868\u8bed\u53e5\u6216\u8005\u7528sp_help table_name\u62ff\u5230\u6240\u6709\u5b57\u6bb5\uff0c\u53ea\u9700\u8981\u5c06\u5b57\u6bb5\u590d\u5236\u51fa\u6765\u6574\u7406\u4e00\u4e0b…”\uff0c\u4e8e\u662f\u590d\u5236\u7c98\u8d34\uff0c\u6539\u5b57\u6bb5\u52a0\u7b26\u53f7\uff0c\u5904\u7406\u4e86\u51e0\u5206\u949f<\/p>\n
\u8fdb\u9636\u9636\u6bb5\uff1a<\/p>\n
\u5bf9\u4e8e\u719f\u6089\u6570\u636e\u53ca\u7f16\u5199sql\u8bed\u53e5\u7684\u6280\u672f\u4eba\u5458\uff1a”\u7cfb\u7edf\u8868\u91cc\u9762\u5b58\u653e\u8868\u7684\u5b57\u6bb5\u4fe1\u606f\uff0c\u5728\u67e5\u8be2\u5b57\u6bb5\u65f6\u53ef\u4ee5\u628a\u4e0d\u9700\u8981\u7684\u5b57\u6bb5\u5254\u9664\uff0c\u62fc\u63a5\u51fa\u53ef\u76f4\u63a5\u7528\u4e8e\u6267\u884c\u7684\u8bed\u53e5…”\uff0c\u51e0\u5206\u949f\u540e\uff0c\u6572\u51fa\u4ee3\u7801\uff1a<\/p>\n
declare @into_table_name varchar(50)<\/p>\n
declare @select_table_name varchar(50)<\/p>\n
declare @except_columns varchar(100)<\/p>\n
declare @where_condition varchar(500)<\/p>\n
–\u539f\u8868<\/p>\n
set @into_table_name=”<\/p>\n
–\u5907\u4efd\u8868<\/p>\n
set @select_table_name=”<\/p>\n
–\u6392\u9664\u7684\u5b57\u6bb5<\/p>\n
set @except_columns=”<\/p>\n
–where\u6761\u4ef6<\/p>\n
set @where_condition=’ where 1=2′<\/p>\n
declare @insert_str varchar(max)<\/p>\n
declare @column_str varchar(max)<\/p>\n
–\u62fc\u63a5\u5b57\u6bb5<\/p>\n
set @column_str=(<\/p>\n
select b.name+’,’<\/p>\n
from sysobjects a,syscolumns b<\/p>\n
where a.id=b.id<\/p>\n
and a.name=@table_name<\/p>\n
and b.name not in(@except_columns)<\/p>\n
for xml path(”))<\/p>\n
–\u5220\u9664\u672b\u5c3e\u9017\u53f7<\/p>\n
select @column_str=substring(@column_str,1,len(@column_str)-1)<\/p>\n
–\u62fc\u63a5sql\u8bed\u53e5<\/p>\n
set @insert_str=’insert into ‘+@into_table_name+'(‘+@column_str+’) select ‘+@column_str+’ from ‘+@select_table_name+@where_condition<\/p>\n
select @insert_str<\/p>\n
\u68c0\u67e5\u65e0\u8bef\u540e\uff1aexec(@insert_str)<\/p>\n
\u7c7b\u4f3c\u7684\u95ee\u9898\u518d\u6b21\u51fa\u73b0<\/p>\n
\u521d\u5b66\u8005\uff1a”##$#@!@#!@#%$#%…”<\/p>\n
\u5165\u95e8\u8005\uff1a”\u5509…”<\/p>\n
\u8fdb\u9636\u8005\u7b11\u4e86\u7b11\uff0c\u4ece\u5bb9\u4e0d\u8feb\u7684\u66ff\u6362\u53c2\u6570\uff0c\u5341\u51e0\u79d2\u540e\u4e00\u5207\u641e\u5b9a…<\/p>\n","protected":false},"excerpt":{"rendered":"
\u4e5f\u8bb8\u4f1a\u78b0\u5230\u8fd9\u6837\u7684\u95ee\u9898\uff1a \u6709\u4e00\u5f20\u8868\u6709\u51e0\u5341\u4e2a\u6216\u8005\u4e0a\u767e\u4e2a\u5b57\u6bb5\uff0c\u5907\u4efd\u540e\u5220\u9664\u4e86\u4e00\u90e8\u5206\u6570\u636e\uff0c\u8fc7\u540e\u53d1\u73b0\u95ee\u9898\u9700\u8981\u6062\u590d\u5176\u4e2d\u4e00\u90e8\u5206 … \u9605\u8bfb\u66f4\u591a<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[10],"tags":[],"class_list":["post-2838","post","type-post","status-publish","format-standard","hentry","category-shujuku"],"aioseo_notices":[],"jetpack_featured_media_url":"","jetpack-related-posts":[],"jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/cn.hostease.com\/xueyuan\/wp-json\/wp\/v2\/posts\/2838","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/cn.hostease.com\/xueyuan\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/cn.hostease.com\/xueyuan\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/cn.hostease.com\/xueyuan\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/cn.hostease.com\/xueyuan\/wp-json\/wp\/v2\/comments?post=2838"}],"version-history":[{"count":1,"href":"https:\/\/cn.hostease.com\/xueyuan\/wp-json\/wp\/v2\/posts\/2838\/revisions"}],"predecessor-version":[{"id":2839,"href":"https:\/\/cn.hostease.com\/xueyuan\/wp-json\/wp\/v2\/posts\/2838\/revisions\/2839"}],"wp:attachment":[{"href":"https:\/\/cn.hostease.com\/xueyuan\/wp-json\/wp\/v2\/media?parent=2838"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/cn.hostease.com\/xueyuan\/wp-json\/wp\/v2\/categories?post=2838"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/cn.hostease.com\/xueyuan\/wp-json\/wp\/v2\/tags?post=2838"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}