\u4e00\u3001\u57fa\u7840
\n1\u3001\u8bf4\u660e\uff1a\u521b\u5efa\u6570\u636e\u5e93
\nCREATE DATABASE database-name
\n2\u3001\u8bf4\u660e\uff1a\u5220\u9664\u6570\u636e\u5e93
\ndrop database dbname
\n3\u3001\u8bf4\u660e\uff1a\u5907\u4efdsql server
\n— \u521b\u5efa \u5907\u4efd\u6570\u636e\u7684 device
\nUSE master
\nEXEC sp_addumpdevice ‘disk’, ‘testBack’, ‘c:\\mssql7backup\\MyNwind_1.dat’
\n— \u5f00\u59cb \u5907\u4efd
\nBACKUP DATABASE pubs TO testBack
\n4\u3001\u8bf4\u660e\uff1a\u521b\u5efa\u65b0\u8868
\ncreate table tabname(col1 type1 [not null] [primary key],col2 type2 [not null],..)
\n\u6839\u636e\u5df2\u6709\u7684\u8868\u521b\u5efa\u65b0\u8868\uff1a
\nA\uff1acreate table tab_new like tab_old (\u4f7f\u7528\u65e7\u8868\u521b\u5efa\u65b0\u8868)
\nB\uff1acreate table tab_new as select col1,col2\u2026 from tab_old definition only
\n5\u3001\u8bf4\u660e\uff1a\u5220\u9664\u65b0\u8868
\ndrop table tabname
\n6\u3001\u8bf4\u660e\uff1a\u589e\u52a0\u4e00\u4e2a\u5217
\nAlter table tabname add column col type
\n\u6ce8\uff1a\u5217\u589e\u52a0\u540e\u5c06\u4e0d\u80fd\u5220\u9664\u3002DB2\u4e2d\u5217\u52a0\u4e0a\u540e\u6570\u636e\u7c7b\u578b\u4e5f\u4e0d\u80fd\u6539\u53d8\uff0c\u552f\u4e00\u80fd\u6539\u53d8\u7684\u662f\u589e\u52a0varchar\u7c7b\u578b\u7684\u957f\u5ea6\u3002
\n7\u3001\u8bf4\u660e\uff1a\u6dfb\u52a0\u4e3b\u952e\uff1a Alter table tabname add primary key(col)
\n\u8bf4\u660e\uff1a\u5220\u9664\u4e3b\u952e\uff1a Alter table tabname drop primary key(col)
\n8\u3001\u8bf4\u660e\uff1a\u521b\u5efa\u7d22\u5f15\uff1acreate [unique] index idxname on tabname(col\u2026.)
\n\u5220\u9664\u7d22\u5f15\uff1adrop index idxname
\n\u6ce8\uff1a\u7d22\u5f15\u662f\u4e0d\u53ef\u66f4\u6539\u7684\uff0c\u60f3\u66f4\u6539\u5fc5\u987b\u5220\u9664\u91cd\u65b0\u5efa\u3002
\n9\u3001\u8bf4\u660e\uff1a\u521b\u5efa\u89c6\u56fe\uff1acreate view viewname as select statement
\n\u5220\u9664\u89c6\u56fe\uff1adrop view viewname
\n10\u3001\u8bf4\u660e\uff1a\u51e0\u4e2a\u7b80\u5355\u7684\u57fa\u672c\u7684sql\u8bed\u53e5
\n\u9009\u62e9\uff1aselect * from table1 where \u8303\u56f4
\n\u63d2\u5165\uff1ainsert into table1(field1,field2) values(value1,value2)
\n\u5220\u9664\uff1adelete from table1 where \u8303\u56f4
\n\u66f4\u65b0\uff1aupdate table1 set field1=value1 where \u8303\u56f4
\n\u67e5\u627e\uff1aselect * from table1 where field1 like \u2019%value1%\u2019 —like\u7684\u8bed\u6cd5\u5f88\u7cbe\u5999\uff0c\u67e5\u8d44\u6599!
\n\u6392\u5e8f\uff1aselect * from table1 order by field1,field2 [desc]
\n\u603b\u6570\uff1aselect count as totalcount from table1
\n\u6c42\u548c\uff1aselect sum(field1) as sumvalue from table1
\n\u5e73\u5747\uff1aselect avg(field1) as avgvalue from table1
\n\u6700\u5927\uff1aselect max(field1) as maxvalue from table1
\n\u6700\u5c0f\uff1aselect min(field1) as minvalue from table1
\n11\u3001\u8bf4\u660e\uff1a\u51e0\u4e2a\u9ad8\u7ea7\u67e5\u8be2\u8fd0\u7b97\u8bcd
\nA\uff1a UNION \u8fd0\u7b97\u7b26
\nUNION \u8fd0\u7b97\u7b26\u901a\u8fc7\u7ec4\u5408\u5176\u4ed6\u4e24\u4e2a\u7ed3\u679c\u8868\uff08\u4f8b\u5982 TABLE1 \u548c TABLE2\uff09\u5e76\u6d88\u53bb\u8868\u4e2d\u4efb\u4f55\u91cd\u590d\u884c\u800c\u6d3e\u751f\u51fa\u4e00\u4e2a\u7ed3\u679c\u8868\u3002\u5f53 ALL \u968f UNION \u4e00\u8d77\u4f7f\u7528\u65f6\uff08\u5373 UNION ALL\uff09\uff0c\u4e0d\u6d88\u9664\u91cd\u590d\u884c\u3002\u4e24\u79cd\u60c5\u51b5\u4e0b\uff0c\u6d3e\u751f\u8868\u7684\u6bcf\u4e00\u884c\u4e0d\u662f\u6765\u81ea TABLE1 \u5c31\u662f\u6765\u81ea TABLE2\u3002
\nB\uff1a EXCEPT \u8fd0\u7b97\u7b26
\nEXCEPT \u8fd0\u7b97\u7b26\u901a\u8fc7\u5305\u62ec\u6240\u6709\u5728 TABLE1 \u4e2d\u4f46\u4e0d\u5728 TABLE2 \u4e2d\u7684\u884c\u5e76\u6d88\u9664\u6240\u6709\u91cd\u590d\u884c\u800c\u6d3e\u751f\u51fa\u4e00\u4e2a\u7ed3\u679c\u8868\u3002\u5f53 ALL \u968f EXCEPT \u4e00\u8d77\u4f7f\u7528\u65f6 (EXCEPT ALL)\uff0c\u4e0d\u6d88\u9664\u91cd\u590d\u884c\u3002
\nC\uff1a INTERSECT \u8fd0\u7b97\u7b26
\nINTERSECT \u8fd0\u7b97\u7b26\u901a\u8fc7\u53ea\u5305\u62ec TABLE1 \u548c TABLE2 \u4e2d\u90fd\u6709\u7684\u884c\u5e76\u6d88\u9664\u6240\u6709\u91cd\u590d\u884c\u800c\u6d3e\u751f\u51fa\u4e00\u4e2a\u7ed3\u679c\u8868\u3002\u5f53 ALL \u968f INTERSECT \u4e00\u8d77\u4f7f\u7528\u65f6 (INTERSECT ALL)\uff0c\u4e0d\u6d88\u9664\u91cd\u590d\u884c\u3002
\n\u6ce8\uff1a\u4f7f\u7528\u8fd0\u7b97\u8bcd\u7684\u51e0\u4e2a\u67e5\u8be2\u7ed3\u679c\u884c\u5fc5\u987b\u662f\u4e00\u81f4\u7684\u3002
\n12\u3001\u8bf4\u660e\uff1a\u4f7f\u7528\u5916\u8fde\u63a5
\nA\u3001left \uff08outer\uff09 join\uff1a
\n\u5de6\u5916\u8fde\u63a5\uff08\u5de6\u8fde\u63a5\uff09\uff1a\u7ed3\u679c\u96c6\u51e0\u5305\u62ec\u8fde\u63a5\u8868\u7684\u5339\u914d\u884c\uff0c\u4e5f\u5305\u62ec\u5de6\u8fde\u63a5\u8868\u7684\u6240\u6709\u884c\u3002
\nSQL: select a.a, a.b, a.c, b.c, b.d, b.f from a LEFT OUT JOIN b ON a.a = b.c
\nB\uff1aright \uff08outer\uff09 join:
\n\u53f3\u5916\u8fde\u63a5(\u53f3\u8fde\u63a5)\uff1a\u7ed3\u679c\u96c6\u65e2\u5305\u62ec\u8fde\u63a5\u8868\u7684\u5339\u914d\u8fde\u63a5\u884c\uff0c\u4e5f\u5305\u62ec\u53f3\u8fde\u63a5\u8868\u7684\u6240\u6709\u884c\u3002
\nC\uff1afull\/cross \uff08outer\uff09 join\uff1a
\n\u5168\u5916\u8fde\u63a5\uff1a\u4e0d\u4ec5\u5305\u62ec\u7b26\u53f7\u8fde\u63a5\u8868\u7684\u5339\u914d\u884c\uff0c\u8fd8\u5305\u62ec\u4e24\u4e2a\u8fde\u63a5\u8868\u4e2d\u7684\u6240\u6709\u8bb0\u5f55\u3002
\n12\u3001\u5206\u7ec4:Group by:
\n \t\u4e00\u5f20\u8868\uff0c\u4e00\u65e6\u5206\u7ec4 \u5b8c\u6210\u540e\uff0c\u67e5\u8be2\u540e\u53ea\u80fd\u5f97\u5230\u7ec4\u76f8\u5173\u7684\u4fe1\u606f\u3002
\n\t\u7ec4\u76f8\u5173\u7684\u4fe1\u606f\uff1a\uff08\u7edf\u8ba1\u4fe1\u606f\uff09 count,sum,max,min,avg \u5206\u7ec4\u7684\u6807\u51c6)
\n \u5728SQLServer\u4e2d\u5206\u7ec4\u65f6\uff1a\u4e0d\u80fd\u4ee5text,ntext,image\u7c7b\u578b\u7684\u5b57\u6bb5\u4f5c\u4e3a\u5206\u7ec4\u4f9d\u636e
\n\t\u5728selecte\u7edf\u8ba1\u51fd\u6570\u4e2d\u7684\u5b57\u6bb5\uff0c\u4e0d\u80fd\u548c\u666e\u901a\u7684\u5b57\u6bb5\u653e\u5728\u4e00\u8d77\uff1b
\n13\u3001\u5bf9\u6570\u636e\u5e93\u8fdb\u884c\u64cd\u4f5c\uff1a
\n\t\u5206\u79bb\u6570\u636e\u5e93\uff1a sp_detach_db; \u9644\u52a0\u6570\u636e\u5e93\uff1asp_attach_db \u540e\u63a5\u8868\u660e\uff0c\u9644\u52a0\u9700\u8981\u5b8c\u6574\u7684\u8def\u5f84\u540d
\n14.\u5982\u4f55\u4fee\u6539\u6570\u636e\u5e93\u7684\u540d\u79f0:
\nsp_renamedb ‘old_name’, ‘new_name’ <\/p>\n
\u4e8c\u3001\u63d0\u5347
\n1\u3001\u8bf4\u660e\uff1a\u590d\u5236\u8868(\u53ea\u590d\u5236\u7ed3\u6784,\u6e90\u8868\u540d\uff1aa \u65b0\u8868\u540d\uff1ab) (Access\u53ef\u7528)
\n\u6cd5\u4e00\uff1aselect * into b from a where 1<>1\uff08\u4ec5\u7528\u4e8eSQlServer\uff09
\n\u6cd5\u4e8c\uff1aselect top 0 * into b from a
\n2\u3001\u8bf4\u660e\uff1a\u62f7\u8d1d\u8868(\u62f7\u8d1d\u6570\u636e,\u6e90\u8868\u540d\uff1aa \u76ee\u6807\u8868\u540d\uff1ab) (Access\u53ef\u7528)
\ninsert into b(a, b, c) select d,e,f from b;
\n3\u3001\u8bf4\u660e\uff1a\u8de8\u6570\u636e\u5e93\u4e4b\u95f4\u8868\u7684\u62f7\u8d1d(\u5177\u4f53\u6570\u636e\u4f7f\u7528\u7edd\u5bf9\u8def\u5f84) (Access\u53ef\u7528)
\ninsert into b(a, b, c) select d,e,f from b in \u2018\u5177\u4f53\u6570\u636e\u5e93\u2019 where \u6761\u4ef6
\n\u4f8b\u5b50\uff1a..from b in ‘”&Server.MapPath(“.”)&”\\data.mdb” &”‘ where..
\n4\u3001\u8bf4\u660e\uff1a\u5b50\u67e5\u8be2(\u8868\u540d1\uff1aa \u8868\u540d2\uff1ab)
\nselect a,b,c from a where a IN (select d from b ) \u6216\u8005: select a,b,c from a where a IN (1,2,3)
\n5\u3001\u8bf4\u660e\uff1a\u663e\u793a\u6587\u7ae0\u3001\u63d0\u4ea4\u4eba\u548c\u6700\u540e\u56de\u590d\u65f6\u95f4
\nselect a.title,a.username,b.adddate from table a,(select max(adddate) adddate from table where table.title=a.title) b
\n6\u3001\u8bf4\u660e\uff1a\u5916\u8fde\u63a5\u67e5\u8be2(\u8868\u540d1\uff1aa \u8868\u540d2\uff1ab)
\nselect a.a, a.b, a.c, b.c, b.d, b.f from a LEFT OUT JOIN b ON a.a = b.c
\n7\u3001\u8bf4\u660e\uff1a\u5728\u7ebf\u89c6\u56fe\u67e5\u8be2(\u8868\u540d1\uff1aa )
\nselect * from (SELECT a,b,c FROM a) T where t.a > 1;
\n8\u3001\u8bf4\u660e\uff1abetween\u7684\u7528\u6cd5,between\u9650\u5236\u67e5\u8be2\u6570\u636e\u8303\u56f4\u65f6\u5305\u62ec\u4e86\u8fb9\u754c\u503c,not between\u4e0d\u5305\u62ec
\nselect * from table1 where time between time1 and time2
\nselect a,b,c, from table1 where a not between \u6570\u503c1 and \u6570\u503c2
\n9\u3001\u8bf4\u660e\uff1ain \u7684\u4f7f\u7528\u65b9\u6cd5
\nselect * from table1 where a [not] in (\u2018\u503c1\u2019,\u2019\u503c2\u2019,\u2019\u503c4\u2019,\u2019\u503c6\u2019)
\n10\u3001\u8bf4\u660e\uff1a\u4e24\u5f20\u5173\u8054\u8868\uff0c\u5220\u9664\u4e3b\u8868\u4e2d\u5df2\u7ecf\u5728\u526f\u8868\u4e2d\u6ca1\u6709\u7684\u4fe1\u606f
\ndelete from table1 where not exists ( select * from table2 where table1.field1=table2.field1 )
\n11\u3001\u8bf4\u660e\uff1a\u56db\u8868\u8054\u67e5\u95ee\u9898\uff1a
\nselect * from a left inner join b on a.a=b.b right inner join c on a.a=c.c inner join d on a.a=d.d where …..
\n12\u3001\u8bf4\u660e\uff1a\u65e5\u7a0b\u5b89\u6392\u63d0\u524d\u4e94\u5206\u949f\u63d0\u9192
\nSQL: select * from \u65e5\u7a0b\u5b89\u6392 where datediff(‘minute’,f\u5f00\u59cb\u65f6\u95f4,getdate())>5
\n13\u3001\u8bf4\u660e\uff1a\u4e00\u6761sql \u8bed\u53e5\u641e\u5b9a\u6570\u636e\u5e93\u5206\u9875
\nselect top 10 b.* from (select top 20 \u4e3b\u952e\u5b57\u6bb5,\u6392\u5e8f\u5b57\u6bb5 from \u8868\u540d order by \u6392\u5e8f\u5b57\u6bb5 desc) a,\u8868\u540d b where b.\u4e3b\u952e\u5b57\u6bb5 = a.\u4e3b\u952e\u5b57\u6bb5 order by a.\u6392\u5e8f\u5b57\u6bb5
\n\u5177\u4f53\u5b9e\u73b0\uff1a
\n\u5173\u4e8e\u6570\u636e\u5e93\u5206\u9875\uff1a
\n declare @start int,@end int
\n @sql nvarchar(600)
\n set @sql=\u2019select top\u2019+str(@end-@start+1)+\u2019+from T where rid not in(select top\u2019+str(@str-1)+\u2019Rid from T where Rid>-1)\u2019
\n exec sp_executesql @sql<\/p>\n
\u6ce8\u610f\uff1a\u5728top\u540e\u4e0d\u80fd\u76f4\u63a5\u8ddf\u4e00\u4e2a\u53d8\u91cf\uff0c\u6240\u4ee5\u5728\u5b9e\u9645\u5e94\u7528\u4e2d\u53ea\u6709\u8fd9\u6837\u7684\u8fdb\u884c\u7279\u6b8a\u7684\u5904\u7406\u3002Rid\u4e3a\u4e00\u4e2a\u6807\u8bc6\u5217\uff0c\u5982\u679ctop\u540e\u8fd8\u6709\u5177\u4f53\u7684\u5b57\u6bb5\uff0c\u8fd9\u6837\u505a\u662f\u975e\u5e38\u6709\u597d\u5904\u7684\u3002\u56e0\u4e3a\u8fd9\u6837\u53ef\u4ee5\u907f\u514d top\u7684\u5b57\u6bb5\u5982\u679c\u662f\u903b\u8f91\u7d22\u5f15\u7684\uff0c\u67e5\u8be2\u7684\u7ed3\u679c\u540e\u5b9e\u9645\u8868\u4e2d\u7684\u4e0d\u4e00\u81f4\uff08\u903b\u8f91\u7d22\u5f15\u4e2d\u7684\u6570\u636e\u6709\u53ef\u80fd\u548c\u6570\u636e\u8868\u4e2d\u7684\u4e0d\u4e00\u81f4\uff0c\u800c\u67e5\u8be2\u65f6\u5982\u679c\u5904\u5728\u7d22\u5f15\u5219\u9996\u5148\u67e5\u8be2\u7d22\u5f15\uff09
\n14\u3001\u8bf4\u660e\uff1a\u524d10\u6761\u8bb0\u5f55
\nselect top 10 * form table1 where \u8303\u56f4
\n15\u3001\u8bf4\u660e\uff1a\u9009\u62e9\u5728\u6bcf\u4e00\u7ec4b\u503c\u76f8\u540c\u7684\u6570\u636e\u4e2d\u5bf9\u5e94\u7684a\u6700\u5927\u7684\u8bb0\u5f55\u7684\u6240\u6709\u4fe1\u606f(\u7c7b\u4f3c\u8fd9\u6837\u7684\u7528\u6cd5\u53ef\u4ee5\u7528\u4e8e\u8bba\u575b\u6bcf\u6708\u6392\u884c\u699c,\u6bcf\u6708\u70ed\u9500\u4ea7\u54c1\u5206\u6790,\u6309\u79d1\u76ee\u6210\u7ee9\u6392\u540d,\u7b49\u7b49.)
\nselect a,b,c from tablename ta where a=(select max(a) from tablename tb where tb.b=ta.b)
\n16\u3001\u8bf4\u660e\uff1a\u5305\u62ec\u6240\u6709\u5728 TableA \u4e2d\u4f46\u4e0d\u5728 TableB\u548cTableC \u4e2d\u7684\u884c\u5e76\u6d88\u9664\u6240\u6709\u91cd\u590d\u884c\u800c\u6d3e\u751f\u51fa\u4e00\u4e2a\u7ed3\u679c\u8868
\n(select a from tableA ) except (select a from tableB) except (select a from tableC)
\n17\u3001\u8bf4\u660e\uff1a\u968f\u673a\u53d6\u51fa10\u6761\u6570\u636e
\nselect top 10 * from tablename order by newid()
\n18\u3001\u8bf4\u660e\uff1a\u968f\u673a\u9009\u62e9\u8bb0\u5f55
\nselect newid()
\n19\u3001\u8bf4\u660e\uff1a\u5220\u9664\u91cd\u590d\u8bb0\u5f55
\n1),delete from tablename where id not in (select max(id) from tablename group by col1,col2,…)
\n2),select distinct * into temp from tablename
\n delete from tablename
\n insert into tablename select * from temp
\n\u8bc4\u4ef7\uff1a \u8fd9\u79cd\u64cd\u4f5c\u7275\u8fde\u5927\u91cf\u7684\u6570\u636e\u7684\u79fb\u52a8\uff0c\u8fd9\u79cd\u505a\u6cd5\u4e0d\u9002\u5408\u5927\u5bb9\u91cf\u4f46\u6570\u636e\u64cd\u4f5c
\n3),\u4f8b\u5982\uff1a\u5728\u4e00\u4e2a\u5916\u90e8\u8868\u4e2d\u5bfc\u5165\u6570\u636e\uff0c\u7531\u4e8e\u67d0\u4e9b\u539f\u56e0\u7b2c\u4e00\u6b21\u53ea\u5bfc\u5165\u4e86\u4e00\u90e8\u5206\uff0c\u4f46\u5f88\u96be\u5224\u65ad\u5177\u4f53\u4f4d\u7f6e\uff0c\u8fd9\u6837\u53ea\u6709\u5728\u4e0b\u4e00\u6b21\u5168\u90e8\u5bfc\u5165\uff0c\u8fd9\u6837\u4e5f\u5c31\u4ea7\u751f\u597d\u591a\u91cd\u590d\u7684\u5b57\u6bb5\uff0c\u600e\u6837\u5220\u9664\u91cd\u590d\u5b57\u6bb5
\nalter table tablename
\n–\u6dfb\u52a0\u4e00\u4e2a\u81ea\u589e\u5217
\nadd column_b int identity(1,1)
\n delete from tablename where column_b not in(
\nselect max(column_b) from tablename group by column1,column2,…)
\nalter table tablename drop column column_b
\n20\u3001\u8bf4\u660e\uff1a\u5217\u51fa\u6570\u636e\u5e93\u91cc\u6240\u6709\u7684\u8868\u540d
\nselect name from sysobjects where type=’U’ \/\/ U\u4ee3\u8868\u7528\u6237
\n21\u3001\u8bf4\u660e\uff1a\u5217\u51fa\u8868\u91cc\u7684\u6240\u6709\u7684\u5217\u540d
\nselect name from syscolumns where id=object_id(‘TableName’)
\n22\u3001\u8bf4\u660e\uff1a\u5217\u793atype\u3001vender\u3001pcs\u5b57\u6bb5\uff0c\u4ee5type\u5b57\u6bb5\u6392\u5217\uff0ccase\u53ef\u4ee5\u65b9\u4fbf\u5730\u5b9e\u73b0\u591a\u91cd\u9009\u62e9\uff0c\u7c7b\u4f3cselect \u4e2d\u7684case\u3002
\nselect type,sum(case vender when ‘A’ then pcs else 0 end),sum(case vender when ‘C’ then pcs else 0 end),sum(case vender when ‘B’ then pcs else 0 end) FROM tablename group by type
\n\u663e\u793a\u7ed3\u679c\uff1a
\ntype vender pcs
\n\u7535\u8111 A 1
\n\u7535\u8111 A 1
\n\u5149\u76d8 B 2
\n\u5149\u76d8 A 2
\n\u624b\u673a B 3
\n\u624b\u673a C 3
\n23\u3001\u8bf4\u660e\uff1a\u521d\u59cb\u5316\u8868table1
\nTRUNCATE TABLE table1
\n24\u3001\u8bf4\u660e\uff1a\u9009\u62e9\u4ece10\u523015\u7684\u8bb0\u5f55
\nselect top 5 * from (select top 15 * from table order by id asc) table_\u522b\u540d order by id desc
\n\u4e09\u3001\u6280\u5de7
\n1\u30011=1\uff0c1=2\u7684\u4f7f\u7528\uff0c\u5728SQL\u8bed\u53e5\u7ec4\u5408\u65f6\u7528\u7684\u8f83\u591a
\n\u201cwhere 1=1\u201d \u662f\u8868\u793a\u9009\u62e9\u5168\u90e8 \u201cwhere 1=2\u201d\u5168\u90e8\u4e0d\u9009\uff0c
\n\u5982\uff1a
\nif @strWhere !=”
\nbegin
\nset @strSQL = ‘select count(*) as Total from [‘ + @tblName + ‘] where ‘ + @strWhere
\nend
\nelse
\nbegin
\nset @strSQL = ‘select count(*) as Total from [‘ + @tblName + ‘]’
\nend
\n\u6211\u4eec\u53ef\u4ee5\u76f4\u63a5\u5199\u6210
\n\u9519\u8bef\uff01\u672a\u627e\u5230\u76ee\u5f55\u9879\u3002
\nset @strSQL = ‘select count(*) as Total from [‘ + @tblName + ‘] where 1=1 \u5b89\u5b9a ‘+ @strWhere 2\u3001\u6536\u7f29\u6570\u636e\u5e93
\n–\u91cd\u5efa\u7d22\u5f15
\nDBCC REINDEX
\nDBCC INDEXDEFRAG
\n–\u6536\u7f29\u6570\u636e\u548c\u65e5\u5fd7
\nDBCC SHRINKDB
\nDBCC SHRINKFILE
\n3\u3001\u538b\u7f29\u6570\u636e\u5e93
\ndbcc shrinkdatabase(dbname)
\n4\u3001\u8f6c\u79fb\u6570\u636e\u5e93\u7ed9\u65b0\u7528\u6237\u4ee5\u5df2\u5b58\u5728\u7528\u6237\u6743\u9650
\nexec sp_change_users_login ‘update_one’,’newname’,’oldname’
\ngo
\n5\u3001\u68c0\u67e5\u5907\u4efd\u96c6
\nRESTORE VERIFYONLY from disk=’E:\\dvbbs.bak’
\n6\u3001\u4fee\u590d\u6570\u636e\u5e93
\nALTER DATABASE [dvbbs] SET SINGLE_USER
\nGO
\nDBCC CHECKDB(‘dvbbs’,repair_allow_data_loss) WITH TABLOCK
\nGO
\nALTER DATABASE [dvbbs] SET MULTI_USER
\nGO
\n7\u3001\u65e5\u5fd7\u6e05\u9664
\nSET NOCOUNT ON
\nDECLARE @LogicalFileName sysname,
\n @MaxMinutes INT,
\n @NewSize INT<\/p>\n
USE tablename — \u8981\u64cd\u4f5c\u7684\u6570\u636e\u5e93\u540d
\nSELECT @LogicalFileName = ‘tablename_log’, — \u65e5\u5fd7\u6587\u4ef6\u540d
\n@MaxMinutes = 10, — Limit on time allowed to wrap log.
\n @NewSize = 1 — \u4f60\u60f3\u8bbe\u5b9a\u7684\u65e5\u5fd7\u6587\u4ef6\u7684\u5927\u5c0f(M)
\nSetup \/ initialize
\nDECLARE @OriginalSize int
\nSELECT @OriginalSize = size
\n FROM sysfiles
\n WHERE name = @LogicalFileName
\nSELECT ‘Original Size of ‘ + db_name() + ‘ LOG is ‘ +
\n CONVERT(VARCHAR(30),@OriginalSize) + ‘ 8K pages or ‘ +
\n CONVERT(VARCHAR(30),(@OriginalSize*8\/1024)) + ‘MB’
\n FROM sysfiles
\n WHERE name = @LogicalFileName
\nCREATE TABLE DummyTrans
\n (DummyColumn char (8000) not null)<\/p>\n
DECLARE @Counter INT,
\n @StartTime DATETIME,
\n @TruncLog VARCHAR(255)
\nSELECT @StartTime = GETDATE(),
\n @TruncLog = ‘BACKUP LOG ‘ + db_name() + ‘ WITH TRUNCATE_ONLY’
\nDBCC SHRINKFILE (@LogicalFileName, @NewSize)
\nEXEC (@TruncLog)
\n— Wrap the log if necessary.
\nWHILE @MaxMinutes > DATEDIFF (mi, @StartTime, GETDATE()) — time has not expired
\n AND @OriginalSize = (SELECT size FROM sysfiles WHERE name = @LogicalFileName)
\n AND (@OriginalSize * 8 \/1024) > @NewSize
\n BEGIN — Outer loop.
\nSELECT @Counter = 0
\n WHILE ((@Counter < @OriginalSize \/ 16) AND (@Counter < 50000))\n BEGIN -- update\n INSERT DummyTrans VALUES ('Fill Log') DELETE DummyTrans\n SELECT @Counter = @Counter + 1\n END\n EXEC (@TruncLog) \n END\nSELECT 'Final Size of ' + db_name() + ' LOG is ' +\n CONVERT(VARCHAR(30),size) + ' 8K pages or ' + \n CONVERT(VARCHAR(30),(size*8\/1024)) + 'MB'\n FROM sysfiles \n WHERE name = @LogicalFileName\nDROP TABLE DummyTrans\nSET NOCOUNT OFF \n8\u3001\u8bf4\u660e\uff1a\u66f4\u6539\u67d0\u4e2a\u8868\nexec sp_changeobjectowner 'tablename','dbo'\n9\u3001\u5b58\u50a8\u66f4\u6539\u5168\u90e8\u8868\nCREATE PROCEDURE dbo.User_ChangeObjectOwnerBatch\n@OldOwner as NVARCHAR(128),\n@NewOwner as NVARCHAR(128)\nAS\nDECLARE @Name as NVARCHAR(128)\nDECLARE @Owner as NVARCHAR(128)\nDECLARE @OwnerName as NVARCHAR(128)\nDECLARE curObject CURSOR FOR \nselect 'Name' = name,\n 'Owner' = user_name(uid)\nfrom sysobjects\nwhere user_name(uid)=@OldOwner\norder by name\nOPEN curObject\nFETCH NEXT FROM curObject INTO @Name, @Owner\nWHILE(@@FETCH_STATUS=0)\nBEGIN \nif @Owner=@OldOwner \nbegin\n set @OwnerName = @OldOwner + '.' + rtrim(@Name)\n exec sp_changeobjectowner @OwnerName, @NewOwner\nend\n-- select @name,@NewOwner,@OldOwner\nFETCH NEXT FROM curObject INTO @Name, @Owner\nEND\nclose curObject\ndeallocate curObject\nGO\n\n10\u3001SQL SERVER\u4e2d\u76f4\u63a5\u5faa\u73af\u5199\u5165\u6570\u636e\ndeclare @i int\nset @i=1\nwhile @i<30\nbegin\n insert into test (userid) values(@i)\n set @i=@i+1\nend\n\u6848\u4f8b\uff1a\n\u6709\u5982\u4e0b\u8868\uff0c\u8981\u6c42\u5c31\u88f1\u4e2d\u6240\u6709\u6c92\u6709\u53ca\u683c\u7684\u6210\u7e3e\uff0c\u5728\u6bcf\u6b21\u589e\u95770.1\u7684\u57fa\u790e\u4e0a\uff0c\u4f7f\u4ed6\u5011\u525b\u597d\u53ca\u683c:\n\tName score\n\tZhangshan\t80\n\tLishi 59\n\tWangwu 50\n\tSongquan\t69\nwhile((select min(score) from tb_table)<60)\nbegin\nupdate tb_table set score =score*1.01 \nwhere score<60\nif (select min(score) from tb_table)>60
\n break
\n else
\n continue
\nend<\/p>\n
\u6570\u636e\u5f00\u53d1-\u7ecf\u5178<\/p>\n
1.\u6309\u59d3\u6c0f\u7b14\u753b\u6392\u5e8f:
\nSelect * From TableName Order By CustomerName Collate Chinese_PRC_Stroke_ci_as \/\/\u4ece\u5c11\u5230\u591a
\n2.\u6570\u636e\u5e93\u52a0\u5bc6:
\nselect encrypt(‘\u539f\u59cb\u5bc6\u7801’)
\nselect pwdencrypt(‘\u539f\u59cb\u5bc6\u7801’)
\nselect pwdcompare(‘\u539f\u59cb\u5bc6\u7801’,’\u52a0\u5bc6\u540e\u5bc6\u7801’) = 1–\u76f8\u540c\uff1b\u5426\u5219\u4e0d\u76f8\u540c encrypt(‘\u539f\u59cb\u5bc6\u7801’)
\nselect pwdencrypt(‘\u539f\u59cb\u5bc6\u7801’)
\nselect pwdcompare(‘\u539f\u59cb\u5bc6\u7801’,’\u52a0\u5bc6\u540e\u5bc6\u7801’) = 1–\u76f8\u540c\uff1b\u5426\u5219\u4e0d\u76f8\u540c
\n3.\u53d6\u56de\u8868\u4e2d\u5b57\u6bb5:
\ndeclare @list varchar(1000),
\n@sql nvarchar(1000)
\nselect @list=@list+’,’+b.name from sysobjects a,syscolumns b where a.id=b.id and a.name=’\u8868A’
\nset @sql=’select ‘+right(@list,len(@list)-1)+’ from \u8868A’
\nexec (@sql)
\n4.\u67e5\u770b\u786c\u76d8\u5206\u533a:
\nEXEC master..xp_fixeddrives
\n5.\u6bd4\u8f83A,B\u8868\u662f\u5426\u76f8\u7b49:
\nif (select checksum_agg(binary_checksum(*)) from A)
\n =
\n (select checksum_agg(binary_checksum(*)) from B)
\nprint ‘\u76f8\u7b49’
\nelse
\nprint ‘\u4e0d\u76f8\u7b49’
\n6.\u6740\u6389\u6240\u6709\u7684\u4e8b\u4ef6\u63a2\u5bdf\u5668\u8fdb\u7a0b:
\nDECLARE hcforeach CURSOR GLOBAL FOR SELECT ‘kill ‘+RTRIM(spid) FROM master.dbo.sysprocesses
\nWHERE program_name IN(‘SQL profiler’,N’SQL \u4e8b\u4ef6\u63a2\u67e5\u5668’)
\nEXEC sp_msforeach_worker ‘?’
\n7.\u8bb0\u5f55\u641c\u7d22:
\n\u5f00\u5934\u5230N\u6761\u8bb0\u5f55
\nSelect Top N * From \u8868
\n——————————-
\nN\u5230M\u6761\u8bb0\u5f55(\u8981\u6709\u4e3b\u7d22\u5f15ID)
\nSelect Top M-N * From \u8868 Where ID in (Select Top M ID From \u8868) Order by ID Desc
\n———————————-
\nN\u5230\u7ed3\u5c3e\u8bb0\u5f55
\nSelect Top N * From \u8868 Order by ID Desc
\n\u6848\u4f8b
\n\u4f8b\u59821\uff1a\u4e00\u5f20\u8868\u6709\u4e00\u4e07\u591a\u6761\u8bb0\u5f55\uff0c\u8868\u7684\u7b2c\u4e00\u4e2a\u5b57\u6bb5 RecID \u662f\u81ea\u589e\u957f\u5b57\u6bb5\uff0c \u5199\u4e00\u4e2aSQL\u8bed\u53e5\uff0c \u627e\u51fa\u8868\u7684\u7b2c31\u5230\u7b2c40\u4e2a\u8bb0\u5f55\u3002
\n select top 10 recid from A where recid not in(select top 30 recid from A)
\n\u5206\u6790\uff1a\u5982\u679c\u8fd9\u6837\u5199\u4f1a\u4ea7\u751f\u67d0\u4e9b\u95ee\u9898\uff0c\u5982\u679crecid\u5728\u8868\u4e2d\u5b58\u5728\u903b\u8f91\u7d22\u5f15\u3002
\n\tselect top 10 recid from A where\u2026\u2026\u662f\u4ece\u7d22\u5f15\u4e2d\u67e5\u627e\uff0c\u800c\u540e\u9762\u7684select top 30 recid from A\u5219\u5728\u6570\u636e\u8868\u4e2d\u67e5\u627e\uff0c\u8fd9\u6837\u7531\u4e8e\u7d22\u5f15\u4e2d\u7684\u987a\u5e8f\u6709\u53ef\u80fd\u548c\u6570\u636e\u8868\u4e2d\u7684\u4e0d\u4e00\u81f4\uff0c\u8fd9\u6837\u5c31\u5bfc\u81f4\u67e5\u8be2\u5230\u7684\u4e0d\u662f\u672c\u6765\u7684\u6b32\u5f97\u5230\u7684\u6570\u636e\u3002
\n\u89e3\u51b3\u65b9\u6848
\n1\uff0c\t\u7528order by select top 30 recid from A order by ricid \u5982\u679c\u8be5\u5b57\u6bb5\u4e0d\u662f\u81ea\u589e\u957f\uff0c\u5c31\u4f1a\u51fa\u73b0\u95ee\u9898
\n2\uff0c\t\u5728\u90a3\u4e2a\u5b50\u67e5\u8be2\u4e2d\u4e5f\u52a0\u6761\u4ef6\uff1aselect top 30 recid from A where recid>-1
\n\u4f8b2\uff1a\u67e5\u8be2\u8868\u4e2d\u7684\u6700\u540e\u4ee5\u6761\u8bb0\u5f55\uff0c\u5e76\u4e0d\u77e5\u9053\u8fd9\u4e2a\u8868\u5171\u6709\u591a\u5c11\u6570\u636e,\u4ee5\u53ca\u8868\u7ed3\u6784\u3002
\nset @s = ‘select top 1 * from T where pid not in (select top ‘ + str(@count-1) + ‘ pid from T)’
\nprint @s exec sp_executesql @s
\n9\uff1a\u83b7\u53d6\u5f53\u524d\u6570\u636e\u5e93\u4e2d\u7684\u6240\u6709\u7528\u6237\u8868
\nselect Name from sysobjects where xtype=’u’ and status>=0
\n10\uff1a\u83b7\u53d6\u67d0\u4e00\u4e2a\u8868\u7684\u6240\u6709\u5b57\u6bb5
\nselect name from syscolumns where id=object_id(‘\u8868\u540d’)
\nselect name from syscolumns where id in (select id from sysobjects where type = ‘u’ and name = ‘\u8868\u540d’)
\n\u4e24\u79cd\u65b9\u5f0f\u7684\u6548\u679c\u76f8\u540c
\n11\uff1a\u67e5\u770b\u4e0e\u67d0\u4e00\u4e2a\u8868\u76f8\u5173\u7684\u89c6\u56fe\u3001\u5b58\u50a8\u8fc7\u7a0b\u3001\u51fd\u6570
\nselect a.* from sysobjects a, syscomments b where a.id = b.id and b.text like ‘%\u8868\u540d%’
\n12\uff1a\u67e5\u770b\u5f53\u524d\u6570\u636e\u5e93\u4e2d\u6240\u6709\u5b58\u50a8\u8fc7\u7a0b
\nselect name as \u5b58\u50a8\u8fc7\u7a0b\u540d\u79f0 from sysobjects where xtype=’P’
\n13\uff1a\u67e5\u8be2\u7528\u6237\u521b\u5efa\u7684\u6240\u6709\u6570\u636e\u5e93
\nselect * from master..sysdatabases D where sid not in(select sid from master..syslogins where name=’sa’)
\n\u6216\u8005
\nselect dbid, name AS DB_NAME from master..sysdatabases where sid <> 0x01
\n14\uff1a\u67e5\u8be2\u67d0\u4e00\u4e2a\u8868\u7684\u5b57\u6bb5\u548c\u6570\u636e\u7c7b\u578b
\nselect column_name,data_type from information_schema.columns
\nwhere table_name = ‘\u8868\u540d’
\n15\uff1a\u4e0d\u540c\u670d\u52a1\u5668\u6570\u636e\u5e93\u4e4b\u95f4\u7684\u6570\u636e\u64cd\u4f5c
\n–\u521b\u5efa\u94fe\u63a5\u670d\u52a1\u5668
\nexec sp_addlinkedserver ‘ITSV ‘, ‘ ‘, ‘SQLOLEDB ‘, ‘\u8fdc\u7a0b\u670d\u52a1\u5668\u540d\u6216ip\u5730\u5740 ‘
\nexec sp_addlinkedsrvlogin ‘ITSV ‘, ‘false ‘,null, ‘\u7528\u6237\u540d ‘, ‘\u5bc6\u7801 ‘
\n–\u67e5\u8be2\u793a\u4f8b
\nselect * from ITSV.\u6570\u636e\u5e93\u540d.dbo.\u8868\u540d
\n–\u5bfc\u5165\u793a\u4f8b
\nselect * into \u8868 from ITSV.\u6570\u636e\u5e93\u540d.dbo.\u8868\u540d
\n–\u4ee5\u540e\u4e0d\u518d\u4f7f\u7528\u65f6\u5220\u9664\u94fe\u63a5\u670d\u52a1\u5668
\nexec sp_dropserver ‘ITSV ‘, ‘droplogins ‘ <\/p>\n
–\u8fde\u63a5\u8fdc\u7a0b\/\u5c40\u57df\u7f51\u6570\u636e(openrowset\/openquery\/opendatasource)
\n–1\u3001openrowset
\n–\u67e5\u8be2\u793a\u4f8b
\nselect * from openrowset( ‘SQLOLEDB ‘, ‘sql\u670d\u52a1\u5668\u540d ‘; ‘\u7528\u6237\u540d ‘; ‘\u5bc6\u7801 ‘,\u6570\u636e\u5e93\u540d.dbo.\u8868\u540d)
\n–\u751f\u6210\u672c\u5730\u8868
\nselect * into \u8868 from openrowset( ‘SQLOLEDB ‘, ‘sql\u670d\u52a1\u5668\u540d ‘; ‘\u7528\u6237\u540d ‘; ‘\u5bc6\u7801 ‘,\u6570\u636e\u5e93\u540d.dbo.\u8868\u540d) <\/p>\n
–\u628a\u672c\u5730\u8868\u5bfc\u5165\u8fdc\u7a0b\u8868
\ninsert openrowset( ‘SQLOLEDB ‘, ‘sql\u670d\u52a1\u5668\u540d ‘; ‘\u7528\u6237\u540d ‘; ‘\u5bc6\u7801 ‘,\u6570\u636e\u5e93\u540d.dbo.\u8868\u540d)
\nselect *from \u672c\u5730\u8868
\n–\u66f4\u65b0\u672c\u5730\u8868
\nupdate b
\nset b.\u5217A=a.\u5217A
\n from openrowset( ‘SQLOLEDB ‘, ‘sql\u670d\u52a1\u5668\u540d ‘; ‘\u7528\u6237\u540d ‘; ‘\u5bc6\u7801 ‘,\u6570\u636e\u5e93\u540d.dbo.\u8868\u540d)as a inner join \u672c\u5730\u8868 b
\non a.column1=b.column1
\n–openquery\u7528\u6cd5\u9700\u8981\u521b\u5efa\u4e00\u4e2a\u8fde\u63a5
\n–\u9996\u5148\u521b\u5efa\u4e00\u4e2a\u8fde\u63a5\u521b\u5efa\u94fe\u63a5\u670d\u52a1\u5668
\nexec sp_addlinkedserver ‘ITSV ‘, ‘ ‘, ‘SQLOLEDB ‘, ‘\u8fdc\u7a0b\u670d\u52a1\u5668\u540d\u6216ip\u5730\u5740 ‘
\n–\u67e5\u8be2
\nselect *
\nFROM openquery(ITSV, ‘SELECT * FROM \u6570\u636e\u5e93.dbo.\u8868\u540d ‘)
\n–\u628a\u672c\u5730\u8868\u5bfc\u5165\u8fdc\u7a0b\u8868
\ninsert openquery(ITSV, ‘SELECT * FROM \u6570\u636e\u5e93.dbo.\u8868\u540d ‘)
\nselect * from \u672c\u5730\u8868
\n–\u66f4\u65b0\u672c\u5730\u8868
\nupdate b
\nset b.\u5217B=a.\u5217B
\nFROM openquery(ITSV, ‘SELECT * FROM \u6570\u636e\u5e93.dbo.\u8868\u540d ‘) as a
\ninner join \u672c\u5730\u8868 b on a.\u5217A=b.\u5217A <\/p>\n
–3\u3001opendatasource\/openrowset
\nSELECT *
\nFROM opendatasource( ‘SQLOLEDB ‘, ‘Data Source=ip\/ServerName;User ID=\u767b\u9646\u540d;Password=\u5bc6\u7801 ‘ ).test.dbo.roy_ta
\n–\u628a\u672c\u5730\u8868\u5bfc\u5165\u8fdc\u7a0b\u8868
\ninsert opendatasource( ‘SQLOLEDB ‘, ‘Data Source=ip\/ServerName;User ID=\u767b\u9646\u540d;Password=\u5bc6\u7801 ‘).\u6570\u636e\u5e93.dbo.\u8868\u540d
\nselect * from \u672c\u5730\u8868
\nSQL Server\u57fa\u672c\u51fd\u6570
\nSQL Server\u57fa\u672c\u51fd\u6570
\n1.\u5b57\u7b26\u4e32\u51fd\u6570 \u957f\u5ea6\u4e0e\u5206\u6790\u7528
\n1,datalength(Char_expr) \u8fd4\u56de\u5b57\u7b26\u4e32\u5305\u542b\u5b57\u7b26\u6570,\u4f46\u4e0d\u5305\u542b\u540e\u9762\u7684\u7a7a\u683c
\n2,substring(expression,start,length) \u53d6\u5b50\u4e32\uff0c\u5b57\u7b26\u4e32\u7684\u4e0b\u6807\u662f\u4ece\u201c1\u201d\uff0cstart\u4e3a\u8d77\u59cb\u4f4d\u7f6e\uff0clength\u4e3a\u5b57\u7b26\u4e32\u957f\u5ea6\uff0c\u5b9e\u9645\u5e94\u7528\u4e2d\u4ee5len(expression)\u53d6\u5f97\u5176\u957f\u5ea6
\n3,right(char_expr,int_expr) \u8fd4\u56de\u5b57\u7b26\u4e32\u53f3\u8fb9\u7b2cint_expr\u4e2a\u5b57\u7b26\uff0c\u8fd8\u7528left\u4e8e\u4e4b\u76f8\u53cd
\n4,isnull( check_expression , replacement_value )\u5982\u679ccheck_expression\u70ba\u7a7a\uff0c\u5247\u8fd4\u56dereplacement_value\u7684\u503c\uff0c\u4e0d\u70ba\u7a7a\uff0c\u5c31\u8fd4\u56decheck_expression\u5b57\u7b26\u64cd\u4f5c\u7c7b
\n5,Sp_addtype \u81ea\u5b9a\u7fa9\u6578\u64da\u985e\u578b
\n\u4f8b\u5982\uff1aEXEC sp_addtype birthday, datetime, ‘NULL’
\n6,set nocount {on|off}
\n\u4f7f\u8fd4\u56de\u7684\u7ed3\u679c\u4e2d\u4e0d\u5305\u542b\u6709\u5173\u53d7 Transact-SQL \u8bed\u53e5\u5f71\u54cd\u7684\u884c\u6570\u7684\u4fe1\u606f\u3002\u5982\u679c\u5b58\u50a8\u8fc7\u7a0b\u4e2d\u5305\u542b\u7684\u4e00\u4e9b\u8bed\u53e5\u5e76\u4e0d\u8fd4\u56de\u8bb8\u591a\u5b9e\u9645\u7684\u6570\u636e\uff0c\u5219\u8be5\u8bbe\u7f6e\u7531\u4e8e\u5927\u91cf\u51cf\u5c11\u4e86\u7f51\u7edc\u6d41\u91cf\uff0c\u56e0\u6b64\u53ef\u663e\u8457\u63d0\u9ad8\u6027\u80fd\u3002SET NOCOUNT \u8bbe\u7f6e\u662f\u5728\u6267\u884c\u6216\u8fd0\u884c\u65f6\u8bbe\u7f6e\uff0c\u800c\u4e0d\u662f\u5728\u5206\u6790\u65f6\u8bbe\u7f6e\u3002
\nSET NOCOUNT \u4e3a ON \u65f6\uff0c\u4e0d\u8fd4\u56de\u8ba1\u6570\uff08\u8868\u793a\u53d7 Transact-SQL \u8bed\u53e5\u5f71\u54cd\u7684\u884c\u6570\uff09\u3002
\nSET NOCOUNT \u4e3a OFF \u65f6\uff0c\u8fd4\u56de\u8ba1\u6570
\n\u5e38\u8bc6<\/p>\n
\u5728SQL\u67e5\u8be2\u4e2d\uff1afrom\u540e\u6700\u591a\u53ef\u4ee5\u8ddf\u591a\u5c11\u5f20\u8868\u6216\u89c6\u56fe\uff1a256
\n\u5728SQL\u8bed\u53e5\u4e2d\u51fa\u73b0 Order by,\u67e5\u8be2\u65f6\uff0c\u5148\u6392\u5e8f\uff0c\u540e\u53d6
\n\u5728SQL\u4e2d\uff0c\u4e00\u4e2a\u5b57\u6bb5\u7684\u6700\u5927\u5bb9\u91cf\u662f8000\uff0c\u800c\u5bf9\u4e8envarchar(4000),\u7531\u4e8envarchar\u662fUnicode\u7801\u3002 <\/p>\n
SQLServer2000\u540c\u6b65\u590d\u5236\u6280\u672f\u5b9e\u73b0\u6b65\u9aa4
\n\u4e00\u3001 \u9884\u5907\u5de5\u4f5c
\n1.\u53d1\u5e03\u670d\u52a1\u5668,\u8ba2\u9605\u670d\u52a1\u5668\u90fd\u521b\u5efa\u4e00\u4e2a\u540c\u540d\u7684windows\u7528\u6237,\u5e76\u8bbe\u7f6e\u76f8\u540c\u7684\u5bc6\u7801,\u505a\u4e3a\u53d1\u5e03\u5feb\u7167\u6587\u4ef6\u5939\u7684\u6709\u6548\u8bbf\u95ee\u7528\u6237
\n–\u7ba1\u7406\u5de5\u5177
\n–\u8ba1\u7b97\u673a\u7ba1\u7406
\n–\u7528\u6237\u548c\u7ec4
\n–\u53f3\u952e\u7528\u6237
\n–\u65b0\u5efa\u7528\u6237
\n–\u5efa\u7acb\u4e00\u4e2a\u96b6\u5c5e\u4e8eadministrator\u7ec4\u7684\u767b\u9646windows\u7684\u7528\u6237\uff08SynUser\uff09
\n2.\u5728\u53d1\u5e03\u670d\u52a1\u5668\u4e0a,\u65b0\u5efa\u4e00\u4e2a\u5171\u4eab\u76ee\u5f55,\u505a\u4e3a\u53d1\u5e03\u7684\u5feb\u7167\u6587\u4ef6\u7684\u5b58\u653e\u76ee\u5f55,\u64cd\u4f5c:
\n\u6211\u7684\u7535\u8111–D:\\ \u65b0\u5efa\u4e00\u4e2a\u76ee\u5f55,\u540d\u4e3a: PUB
\n–\u53f3\u952e\u8fd9\u4e2a\u65b0\u5efa\u7684\u76ee\u5f55
\n–\u5c5e\u6027–\u5171\u4eab
\n–\u9009\u62e9”\u5171\u4eab\u8be5\u6587\u4ef6\u5939”
\n–\u901a\u8fc7”\u6743\u9650”\u6309\u7ebd\u6765\u8bbe\u7f6e\u5177\u4f53\u7684\u7528\u6237\u6743\u9650,\u4fdd\u8bc1\u7b2c\u4e00\u6b65\u4e2d\u521b\u5efa\u7684\u7528\u6237(SynUser) \u5177\u6709\u5bf9\u8be5\u6587\u4ef6\u5939\u7684\u6240\u6709\u6743\u9650<\/p>\n
–\u786e\u5b9a
\n3.\u8bbe\u7f6eSQL\u4ee3\u7406(SQLSERVERAGENT)\u670d\u52a1\u7684\u542f\u52a8\u7528\u6237(\u53d1\u5e03\/\u8ba2\u9605\u670d\u52a1\u5668\u5747\u505a\u6b64\u8bbe\u7f6e)
\n\u5f00\u59cb–\u7a0b\u5e8f–\u7ba1\u7406\u5de5\u5177–\u670d\u52a1
\n–\u53f3\u952eSQLSERVERAGENT
\n–\u5c5e\u6027–\u767b\u9646–\u9009\u62e9”\u6b64\u8d26\u6237”
\n–\u8f93\u5165\u6216\u8005\u9009\u62e9\u7b2c\u4e00\u6b65\u4e2d\u521b\u5efa\u7684windows\u767b\u5f55\u7528\u6237\u540d\uff08SynUser\uff09
\n–“\u5bc6\u7801”\u4e2d\u8f93\u5165\u8be5\u7528\u6237\u7684\u5bc6\u7801
\n4.\u8bbe\u7f6eSQL Server\u8eab\u4efd\u9a8c\u8bc1\u6a21\u5f0f,\u89e3\u51b3\u8fde\u63a5\u65f6\u7684\u6743\u9650\u95ee\u9898(\u53d1\u5e03\/\u8ba2\u9605\u670d\u52a1\u5668\u5747\u505a\u6b64\u8bbe\u7f6e)
\n\u4f01\u4e1a\u7ba1\u7406\u5668
\n–\u53f3\u952eSQL\u5b9e\u4f8b–\u5c5e\u6027
\n–\u5b89\u5168\u6027–\u8eab\u4efd\u9a8c\u8bc1
\n–\u9009\u62e9”SQL Server \u548c Windows”
\n–\u786e\u5b9a
\n5.\u5728\u53d1\u5e03\u670d\u52a1\u5668\u548c\u8ba2\u9605\u670d\u52a1\u5668\u4e0a\u4e92\u76f8\u6ce8\u518c
\n\u4f01\u4e1a\u7ba1\u7406\u5668
\n–\u53f3\u952eSQL Server\u7ec4
\n–\u65b0\u5efaSQL Server\u6ce8\u518c…
\n–\u4e0b\u4e00\u6b65–\u53ef\u7528\u7684\u670d\u52a1\u5668\u4e2d,\u8f93\u5165\u4f60\u8981\u6ce8\u518c\u7684\u8fdc\u7a0b\u670d\u52a1\u5668\u540d –\u6dfb\u52a0
\n–\u4e0b\u4e00\u6b65–\u8fde\u63a5\u4f7f\u7528,\u9009\u62e9\u7b2c\u4e8c\u4e2a”SQL Server\u8eab\u4efd\u9a8c\u8bc1”
\n–\u4e0b\u4e00\u6b65–\u8f93\u5165\u7528\u6237\u540d\u548c\u5bc6\u7801\uff08SynUser\uff09
\n–\u4e0b\u4e00\u6b65–\u9009\u62e9SQL Server\u7ec4,\u4e5f\u53ef\u4ee5\u521b\u5efa\u4e00\u4e2a\u65b0\u7ec4
\n–\u4e0b\u4e00\u6b65–\u5b8c\u6210
\n6.\u5bf9\u4e8e\u53ea\u80fd\u7528IP,\u4e0d\u80fd\u7528\u8ba1\u7b97\u673a\u540d\u7684,\u4e3a\u5176\u6ce8\u518c\u670d\u52a1\u5668\u522b\u540d\uff08\u6b64\u6b65\u5728\u5b9e\u65bd\u4e2d\u6ca1\u7528\u5230\uff09
\n (\u5728\u8fde\u63a5\u7aef\u914d\u7f6e,\u6bd4\u5982,\u5728\u8ba2\u9605\u670d\u52a1\u5668\u4e0a\u914d\u7f6e\u7684\u8bdd,\u670d\u52a1\u5668\u540d\u79f0\u4e2d\u8f93\u5165\u7684\u662f\u53d1\u5e03\u670d\u52a1\u5668\u7684IP)
\n\u5f00\u59cb–\u7a0b\u5e8f–Microsoft SQL Server–\u5ba2\u6237\u7aef\u7f51\u7edc\u5b9e\u7528\u5de5\u5177
\n–\u522b\u540d–\u6dfb\u52a0
\n–\u7f51\u7edc\u5e93\u9009\u62e9”tcp\/ip”–\u670d\u52a1\u5668\u522b\u540d\u8f93\u5165SQL\u670d\u52a1\u5668\u540d
\n–\u8fde\u63a5\u53c2\u6570–\u670d\u52a1\u5668\u540d\u79f0\u4e2d\u8f93\u5165SQL\u670d\u52a1\u5668ip\u5730\u5740
\n–\u5982\u679c\u4f60\u4fee\u6539\u4e86SQL\u7684\u7aef\u53e3,\u53d6\u6d88\u9009\u62e9”\u52a8\u6001\u51b3\u5b9a\u7aef\u53e3”,\u5e76\u8f93\u5165\u5bf9\u5e94\u7684\u7aef\u53e3\u53f7
\n\u4e8c\u3001 \u6b63\u5f0f\u914d\u7f6e
\n1\u3001\u914d\u7f6e\u53d1\u5e03\u670d\u52a1\u5668
\n\u6253\u5f00\u4f01\u4e1a\u7ba1\u7406\u5668\uff0c\u5728\u53d1\u5e03\u670d\u52a1\u5668\uff08B\u3001C\u3001D\uff09\u4e0a\u6267\u884c\u4ee5\u4e0b\u6b65\u9aa4:
\n(1) \u4ece[\u5de5\u5177]\u4e0b\u62c9\u83dc\u5355\u7684[\u590d\u5236]\u5b50\u83dc\u5355\u4e2d\u9009\u62e9[\u914d\u7f6e\u53d1\u5e03\u3001\u8ba2\u9605\u670d\u52a1\u5668\u548c\u5206\u53d1]\u51fa\u73b0\u914d\u7f6e\u53d1\u5e03\u548c\u5206\u53d1\u5411\u5bfc
\n(2) [\u4e0b\u4e00\u6b65] \u9009\u62e9\u5206\u53d1\u670d\u52a1\u5668 \u53ef\u4ee5\u9009\u62e9\u628a\u53d1\u5e03\u670d\u52a1\u5668\u81ea\u5df1\u4f5c\u4e3a\u5206\u53d1\u670d\u52a1\u5668\u6216\u8005\u5176\u4ed6sql\u7684\u670d\u52a1\u5668\uff08\u9009\u62e9\u81ea\u5df1\uff09
\n(3) [\u4e0b\u4e00\u6b65] \u8bbe\u7f6e\u5feb\u7167\u6587\u4ef6\u5939
\n\u91c7\u7528\u9ed8\u8ba4\\\\servername\\Pub
\n(4) [\u4e0b\u4e00\u6b65] \u81ea\u5b9a\u4e49\u914d\u7f6e
\n\u53ef\u4ee5\u9009\u62e9:\u662f,\u8ba9\u6211\u8bbe\u7f6e\u5206\u53d1\u6570\u636e\u5e93\u5c5e\u6027\u542f\u7528\u53d1\u5e03\u670d\u52a1\u5668\u6216\u8bbe\u7f6e\u53d1\u5e03\u8bbe\u7f6e
\n\u5426,\u4f7f\u7528\u4e0b\u5217\u9ed8\u8ba4\u8bbe\u7f6e\uff08\u63a8\u8350\uff09
\n(5) [\u4e0b\u4e00\u6b65] \u8bbe\u7f6e\u5206\u53d1\u6570\u636e\u5e93\u540d\u79f0\u548c\u4f4d\u7f6e \u91c7\u7528\u9ed8\u8ba4\u503c
\n(6) [\u4e0b\u4e00\u6b65] \u542f\u7528\u53d1\u5e03\u670d\u52a1\u5668 \u9009\u62e9\u4f5c\u4e3a\u53d1\u5e03\u7684\u670d\u52a1\u5668
\n(7) [\u4e0b\u4e00\u6b65] \u9009\u62e9\u9700\u8981\u53d1\u5e03\u7684\u6570\u636e\u5e93\u548c\u53d1\u5e03\u7c7b\u578b
\n(8) [\u4e0b\u4e00\u6b65] \u9009\u62e9\u6ce8\u518c\u8ba2\u9605\u670d\u52a1\u5668
\n(9) [\u4e0b\u4e00\u6b65] \u5b8c\u6210\u914d\u7f6e
\n2\u3001\u521b\u5efa\u51fa\u7248\u7269
\n\u53d1\u5e03\u670d\u52a1\u5668B\u3001C\u3001D\u4e0a
\n(1)\u4ece[\u5de5\u5177]\u83dc\u5355\u7684[\u590d\u5236]\u5b50\u83dc\u5355\u4e2d\u9009\u62e9[\u521b\u5efa\u548c\u7ba1\u7406\u53d1\u5e03]\u547d\u4ee4
\n(2)\u9009\u62e9\u8981\u521b\u5efa\u51fa\u7248\u7269\u7684\u6570\u636e\u5e93\uff0c\u7136\u540e\u5355\u51fb[\u521b\u5efa\u53d1\u5e03]
\n(3)\u5728[\u521b\u5efa\u53d1\u5e03\u5411\u5bfc]\u7684\u63d0\u793a\u5bf9\u8bdd\u6846\u4e2d\u5355\u51fb[\u4e0b\u4e00\u6b65]\u7cfb\u7edf\u5c31\u4f1a\u5f39\u51fa\u4e00\u4e2a\u5bf9\u8bdd\u6846\u3002\u5bf9\u8bdd\u6846\u4e0a\u7684\u5185\u5bb9\u662f\u590d\u5236\u7684\u4e09\u4e2a\u7c7b\u578b\u3002\u6211\u4eec\u73b0\u5728\u9009\u7b2c\u4e00\u4e2a\u4e5f\u5c31\u662f\u9ed8\u8ba4\u7684\u5feb\u7167\u53d1\u5e03(\u5176\u4ed6\u4e24\u4e2a\u5927\u5bb6\u53ef\u4ee5\u53bb\u770b\u770b\u5e2e\u52a9)
\n(4)\u5355\u51fb[\u4e0b\u4e00\u6b65]\u7cfb\u7edf\u8981\u6c42\u6307\u5b9a\u53ef\u4ee5\u8ba2\u9605\u8be5\u53d1\u5e03\u7684\u6570\u636e\u5e93\u670d\u52a1\u5668\u7c7b\u578b,
\nSQLSERVER\u5141\u8bb8\u5728\u4e0d\u540c\u7684\u6570\u636e\u5e93\u5982 orACLE\u6216ACCESS\u4e4b\u95f4\u8fdb\u884c\u6570\u636e\u590d\u5236\u3002
\n\u4f46\u662f\u5728\u8fd9\u91cc\u6211\u4eec\u9009\u62e9\u8fd0\u884c”SQL SERVER 2000″\u7684\u6570\u636e\u5e93\u670d\u52a1\u5668
\n(5)\u5355\u51fb[\u4e0b\u4e00\u6b65]\u7cfb\u7edf\u5c31\u5f39\u51fa\u4e00\u4e2a\u5b9a\u4e49\u6587\u7ae0\u7684\u5bf9\u8bdd\u6846\u4e5f\u5c31\u662f\u9009\u62e9\u8981\u51fa\u7248\u7684\u8868
\n\u6ce8\u610f: \u5982\u679c\u524d\u9762\u9009\u62e9\u4e86\u4e8b\u52a1\u53d1\u5e03 \u5219\u518d\u8fd9\u4e00\u6b65\u4e2d\u53ea\u80fd\u9009\u62e9\u5e26\u6709\u4e3b\u952e\u7684\u8868
\n(6)\u9009\u62e9\u53d1\u5e03\u540d\u79f0\u548c\u63cf\u8ff0
\n(7)\u81ea\u5b9a\u4e49\u53d1\u5e03\u5c5e\u6027 \u5411\u5bfc\u63d0\u4f9b\u7684\u9009\u62e9:
\n\u662f \u6211\u5c06\u81ea\u5b9a\u4e49\u6570\u636e\u7b5b\u9009,\u542f\u7528\u533f\u540d\u8ba2\u9605\u548c\u6216\u5176\u4ed6\u81ea\u5b9a\u4e49\u5c5e\u6027
\n\u5426 \u6839\u636e\u6307\u5b9a\u65b9\u5f0f\u521b\u5efa\u53d1\u5e03 \uff08\u5efa\u8bae\u91c7\u7528\u81ea\u5b9a\u4e49\u7684\u65b9\u5f0f\uff09
\n(8)[\u4e0b\u4e00\u6b65] \u9009\u62e9\u7b5b\u9009\u53d1\u5e03\u7684\u65b9\u5f0f
\n(9)[\u4e0b\u4e00\u6b65] \u53ef\u4ee5\u9009\u62e9\u662f\u5426\u5141\u8bb8\u533f\u540d\u8ba2\u9605
\n1)\u5982\u679c\u9009\u62e9\u7f72\u540d\u8ba2\u9605,\u5219\u9700\u8981\u5728\u53d1\u5e03\u670d\u52a1\u5668\u4e0a\u6dfb\u52a0\u8ba2\u9605\u670d\u52a1\u5668
\n\u65b9\u6cd5: [\u5de5\u5177]->[\u590d\u5236]->[\u914d\u7f6e\u53d1\u5e03\u3001\u8ba2\u9605\u670d\u52a1\u5668\u548c\u5206\u53d1\u7684\u5c5e\u6027]->[\u8ba2\u9605\u670d\u52a1\u5668] \u4e2d\u6dfb\u52a0
\n\u5426\u5219\u5728\u8ba2\u9605\u670d\u52a1\u5668\u4e0a\u8bf7\u6c42\u8ba2\u9605\u65f6\u4f1a\u51fa\u73b0\u7684\u63d0\u793a:\u6539\u53d1\u5e03\u4e0d\u5141\u8bb8\u533f\u540d\u8ba2\u9605
\n\u5982\u679c\u4ecd\u7136\u9700\u8981\u533f\u540d\u8ba2\u9605\u5219\u7528\u4ee5\u4e0b\u89e3\u51b3\u529e\u6cd5
\n[\u4f01\u4e1a\u7ba1\u7406\u5668]->[\u590d\u5236]->[\u53d1\u5e03\u5185\u5bb9]->[\u5c5e\u6027]->[\u8ba2\u9605\u9009\u9879] \u9009\u62e9\u5141\u8bb8\u533f\u540d\u8bf7\u6c42\u8ba2\u9605
\n2)\u5982\u679c\u9009\u62e9\u533f\u540d\u8ba2\u9605,\u5219\u914d\u7f6e\u8ba2\u9605\u670d\u52a1\u5668\u65f6\u4e0d\u4f1a\u51fa\u73b0\u4ee5\u4e0a\u63d0\u793a
\n(10)[\u4e0b\u4e00\u6b65] \u8bbe\u7f6e\u5feb\u7167 \u4ee3\u7406\u7a0b\u5e8f\u8c03\u5ea6
\n(11)[\u4e0b\u4e00\u6b65] \u5b8c\u6210\u914d\u7f6e
\n\u5f53\u5b8c\u6210\u51fa\u7248\u7269\u7684\u521b\u5efa\u540e\u521b\u5efa\u51fa\u7248\u7269\u7684\u6570\u636e\u5e93\u4e5f\u5c31\u53d8\u6210\u4e86\u4e00\u4e2a\u5171\u4eab\u6570\u636e\u5e93
\n\u6709\u6570\u636e
\nsrv1.\u5e93\u540d..author\u6709\u5b57\u6bb5:id,name,phone,
\nsrv2.\u5e93\u540d..author\u6709\u5b57\u6bb5:id,name,telphone,adress <\/p>\n
\u8981\u6c42\uff1a
\nsrv1.\u5e93\u540d..author\u589e\u52a0\u8bb0\u5f55\u5219srv1.\u5e93\u540d..author\u8bb0\u5f55\u589e\u52a0
\nsrv1.\u5e93\u540d..author\u7684phone\u5b57\u6bb5\u66f4\u65b0\uff0c\u5219srv1.\u5e93\u540d..author\u5bf9\u5e94\u5b57\u6bb5telphone\u66f4\u65b0
\n–*\/ <\/p>\n
–\u5927\u81f4\u7684\u5904\u7406\u6b65\u9aa4
\n–1.\u5728 srv1 \u4e0a\u521b\u5efa\u8fde\u63a5\u670d\u52a1\u5668,\u4ee5\u4fbf\u5728 srv1 \u4e2d\u64cd\u4f5c srv2,\u5b9e\u73b0\u540c\u6b65
\nexec sp_addlinkedserver ‘srv2′,”,’SQLOLEDB’,’srv2\u7684sql\u5b9e\u4f8b\u540d\u6216ip’
\nexec sp_addlinkedsrvlogin ‘srv2′,’false’,null,’\u7528\u6237\u540d’,’\u5bc6\u7801’
\ngo
\n–2.\u5728 srv1 \u548c srv2 \u8fd9\u4e24\u53f0\u7535\u8111\u4e2d,\u542f\u52a8 msdtc(\u5206\u5e03\u5f0f\u4e8b\u52a1\u5904\u7406\u670d\u52a1),\u5e76\u4e14\u8bbe\u7f6e\u4e3a\u81ea\u52a8\u542f\u52a8
\n\u3002\u6211\u7684\u7535\u8111–\u63a7\u5236\u9762\u677f–\u7ba1\u7406\u5de5\u5177–\u670d\u52a1–\u53f3\u952e Distributed Transaction Coordinator–\u5c5e\u6027–\u542f\u52a8–\u5e76\u5c06\u542f\u52a8\u7c7b\u578b\u8bbe\u7f6e\u4e3a\u81ea\u52a8\u542f\u52a8
\ngo <\/p>\n
–\u7136\u540e\u521b\u5efa\u4e00\u4e2a\u4f5c\u4e1a\u5b9a\u65f6\u8c03\u7528\u4e0a\u9762\u7684\u540c\u6b65\u5904\u7406\u5b58\u50a8\u8fc7\u7a0b\u5c31\u884c\u4e86 <\/p>\n
\u4f01\u4e1a\u7ba1\u7406\u5668
\n–\u7ba1\u7406
\n–SQL Server\u4ee3\u7406
\n–\u53f3\u952e\u4f5c\u4e1a
\n–\u65b0\u5efa\u4f5c\u4e1a
\n–“\u5e38\u89c4”\u9879\u4e2d\u8f93\u5165\u4f5c\u4e1a\u540d\u79f0
\n–“\u6b65\u9aa4”\u9879
\n–\u65b0\u5efa
\n–“\u6b65\u9aa4\u540d”\u4e2d\u8f93\u5165\u6b65\u9aa4\u540d
\n–“\u7c7b\u578b”\u4e2d\u9009\u62e9”Transact-SQL \u811a\u672c(TSQL)”
\n–“\u6570\u636e\u5e93”\u9009\u62e9\u6267\u884c\u547d\u4ee4\u7684\u6570\u636e\u5e93
\n–“\u547d\u4ee4”\u4e2d\u8f93\u5165\u8981\u6267\u884c\u7684\u8bed\u53e5: exec p_process
\n–\u786e\u5b9a
\n–“\u8c03\u5ea6”\u9879
\n–\u65b0\u5efa\u8c03\u5ea6
\n–“\u540d\u79f0”\u4e2d\u8f93\u5165\u8c03\u5ea6\u540d\u79f0
\n–“\u8c03\u5ea6\u7c7b\u578b”\u4e2d\u9009\u62e9\u4f60\u7684\u4f5c\u4e1a\u6267\u884c\u5b89\u6392
\n–\u5982\u679c\u9009\u62e9”\u53cd\u590d\u51fa\u73b0”
\n–\u70b9”\u66f4\u6539”\u6765\u8bbe\u7f6e\u4f60\u7684\u65f6\u95f4\u5b89\u6392 <\/p>\n
\u7136\u540e\u5c06SQL Agent\u670d\u52a1\u542f\u52a8,\u5e76\u8bbe\u7f6e\u4e3a\u81ea\u52a8\u542f\u52a8,\u5426\u5219\u4f60\u7684\u4f5c\u4e1a\u4e0d\u4f1a\u88ab\u6267\u884c <\/p>\n
\u8bbe\u7f6e\u65b9\u6cd5:
\n\u6211\u7684\u7535\u8111–\u63a7\u5236\u9762\u677f–\u7ba1\u7406\u5de5\u5177–\u670d\u52a1–\u53f3\u952e SQLSERVERAGENT–\u5c5e\u6027–\u542f\u52a8\u7c7b\u578b–\u9009\u62e9”\u81ea\u52a8\u542f\u52a8”–\u786e\u5b9a. <\/p>\n
–3.\u5b9e\u73b0\u540c\u6b65\u5904\u7406\u7684\u65b9\u6cd52,\u5b9a\u65f6\u540c\u6b65 <\/p>\n
–\u5728srv1\u4e2d\u521b\u5efa\u5982\u4e0b\u7684\u540c\u6b65\u5904\u7406\u5b58\u50a8\u8fc7\u7a0b
\ncreate proc p_process
\nas
\n–\u66f4\u65b0\u4fee\u6539\u8fc7\u7684\u6570\u636e
\nupdate b set name=i.name,telphone=i.telphone
\nfrom srv2.\u5e93\u540d.dbo.author b,author i
\nwhere b.id=i.id and
\n(b.name <> i.name or b.telphone <> i.telphone) <\/p>\n
–\u63d2\u5165\u65b0\u589e\u7684\u6570\u636e
\ninsert srv2.\u5e93\u540d.dbo.author(id,name,telphone)
\nselect id,name,telphone from author i
\nwhere not exists(
\nselect * from srv2.\u5e93\u540d.dbo.author where id=i.id) <\/p>\n
–\u5220\u9664\u5df2\u7ecf\u5220\u9664\u7684\u6570\u636e(\u5982\u679c\u9700\u8981\u7684\u8bdd)
\ndelete b
\nfrom srv2.\u5e93\u540d.dbo.author b
\nwhere not exists(
\nselect * from author where id=b.id)
\ngo<\/p>\n","protected":false},"excerpt":{"rendered":"
\u4e00\u3001\u57fa\u7840 1\u3001\u8bf4\u660e\uff1a\u521b\u5efa\u6570\u636e\u5e93 CREA…<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[68],"tags":[],"class_list":["post-2104","post","type-post","status-publish","format-standard","hentry","category-zzjy"],"_links":{"self":[{"href":"https:\/\/www.aiersheng.cc\/index.php?rest_route=\/wp\/v2\/posts\/2104","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.aiersheng.cc\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.aiersheng.cc\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.aiersheng.cc\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.aiersheng.cc\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=2104"}],"version-history":[{"count":0,"href":"https:\/\/www.aiersheng.cc\/index.php?rest_route=\/wp\/v2\/posts\/2104\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.aiersheng.cc\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=2104"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.aiersheng.cc\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=2104"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.aiersheng.cc\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=2104"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}