<address id="xpjh9"><listing id="xpjh9"><meter id="xpjh9"></meter></listing></address>

<address id="xpjh9"><address id="xpjh9"><listing id="xpjh9"></listing></address></address>
<noframes id="xpjh9">
<noframes id="xpjh9">

<address id="xpjh9"><address id="xpjh9"><listing id="xpjh9"></listing></address></address>
    <form id="xpjh9"></form><address id="xpjh9"><listing id="xpjh9"><menuitem id="xpjh9"></menuitem></listing></address>

      <noframes id="xpjh9">
      VB.net 2010 視頻教程 VB.net 2010 視頻教程 VB.net 2010 視頻教程
      SQL Server 2008 視頻教程 c#入門經典教程 Visual Basic從門到精通視頻教程
      當前位置:
      首頁 > 數據庫 > T-SQL >
      • sql語句大全之新建存過,查詢表結構的方法。

      • 2019-05-03 11:11 來源:未知
      復制代碼
      CREATE  PROC [dbo].[sp_help_table]
          @tableName NVARCHAR(50)--表名稱
      AS
      BEGIN
          SELECT a.colorder 字段序號,a.name 字段名,b.name 字段類型,b.length AS 字段長度,g.[value] AS 字段說明
          FROM syscolumns a left join systypes b
          on a.xtype=b.xusertype
          inner join sysobjects d
          on a.id=d.id and d.xtype='U' and d.name<>'dtproperties'
          left join sys.extended_properties g
          on a.id=g.major_id AND a.colid = g.minor_id
          WHERE d.[name] =@tableName 
          order by a.id,a.colorder
      END    
      復制代碼

      這樣,在查詢某個表的時候,直接執行這個存過,參數就是表名稱,最后的結果就是這樣

      ,字段說明是在新建表的時候填寫的說明,如果沒寫這列就是NULL

      相關教程
      江苏快3 www.500cd.com | www.602327.com | www.54968f.com | www.c300.biz | www.258015.com | www.54400a.com | www.50064s.com | www.8039i.com | www.015ac.com | www.pkfc8.com | www.599840.com | www.80767t.com | www.659zf.com | www.fo03.com | www.680477.com | www.99677z.com | www.68689k.com | www.hw8877.com | www.375990.com | www.66332x.com | www.12015.cc | www.506792.com | www.91233n.com | www.318548.com | www.33112d.com | www.699by.com | www.053059.com | www.77801k.com | www.9478d.com | www.444165.com | www.00840u.com | www.979816.com | www.25688j.com | www.589703.com | www.2109m.com | www.603154.com | www.16878m.com | www.799413.com | www.50052n.com | www.848166.com | www.146656.com | www.11201.cc | www.97171.cc | www.566921.com | www.50064l.com | www.771746.com | www.92092.cc | www.86267u.com | www.3479w.com | www.21202x.com | www.371956.com | www.971291.com | www.16878m.com | www.202115.com | www.34czj.com | www.08588p.com | www.286898.com | www.987jc.com | www.68689r.com | www.83033x.com | www.327477.com | www.890995.com | www.3479e.com | www.08500w.com | www.49956t.com | www.138037.com | www.912339.com | www.c5884.com | www.88kcw.com | www.550346.com | www.3005w.com | www.152918.com | www.15czj.com | www.91233z.com | www.566217.com | www.37439.cc | www.78949e.com | www.978351.com | www.16878y.com | www.xinyc6.com | www.50052k.com | www.306061.com | www.982jc.com | www.bxcp3.com | www.193629.com | www.am8080.com | www.66621l.com | www.215077.com | www.hm2555.com | www.50732r.com | www.858776.com | www.7793q.com | www.71233x.com | www.602957.com | www.zc35.com | www.3126e.com | www.77210f.com | www.281380.com | www.wcp666888.com | www.7782r.com | www.43131a.com | www.xinyc8.com | www.88ac.com | www.981jc.com | www.06500w.com | www.99677y.com | www.66376q.com | www.106537.com | www.338996.com | www.955708.com | www.66653.com | www.07163k.com | www.26163k.com | www.84499q.com | www.215602.com | www.397836.com | www.936399.com | www.99jtg.com | www.2632e.com | www.00840y.com | www.50026n.com | www.91233w.com | www.80065j.com | www.197802.com | www.237944.com | www.665991.com | www.896165.com | www.847577.com | www.848266.com | www.919227.com | www.ck09.com | www.813770.com | www.926887.com | www.az0908.com | www.csw288.com | www.878743.com | www.799046.com | www.630155.com | www.599210.com | www.424988.com | www.325771.com | www.216880.com | www.78949v.com | www.51515r.com | www.99677m.com | www.80065l.com | www.35155j.com | www.80075f.com | www.33588z.com | www.1888ac.com | www.ztc7.com | www.168232.com | www.50788m.com | www.80075p.com | www.3416u.com | www.cp500.pw | www.177542.com | www.50788e.com | www.26299k.com | www.99jtg.com | www.781217.com | www.369908.com | www.71399j.com | www.16878j.com | www.hx5566.com | www.hcw332.com | www.84499r.com | www.6832e.com | www.c139.vip | www.106267.com | www.52303k.com | www.hy6933.com | www.375990.com | www.66652d.com | www.zfcp3.com | www.768997.com | www.96386h.com | www.41518f.com | www.590777a.com | www.305644.com | www.39500m.com | www.901593.com | www.370837.com | www.50026x.com | www.770816.com | www.29277l.com | www.h679.com | www.101372.com | www.2109d.com | www.570323.com | www.53900b.com | www.097wy.com | www.412228.com | www.51550.cc | www.398518.com | www.15355q.com | www.ywzuqiu.com | www.57578d.com | www.760320.com | www.bxcp3.com | www.914908.com | www.52303y.com | www.cai003.vip | www.50052w.com | www.889938.com | www.07163a.com | www.909309.com | www.91233z.com | www.652592.com | www.52303q.com | www.527990.com | www.288hc.com | www.34788x.com | www.9889hc.com | www.271696.com | www.015ac.com | www.77djcp.com | www.04gcw.com | www.77802f.com | www.c2953.com | www.66332t.com | www.358939.com | www.5xci.com | www.2350t.com | www.81233v.com | www.987957.com | www.16878l.com | www.525059.com | www.3933u.cc | www.508477.com | www.062wy.com | www.75538c.com | www.xinyc5.com | www.015ac.com | www.50052b.com | www.609535.com | www.33ttz.com | www.71233r.com | www.96386s.com | www.609716.com | www.095wy.com | www.77210g.com | www.177888.com | www.679313.com | www.055cp.cc | www.3126g.com | www.33598v.com | www.186793.com | www.590833.com | www.889688.com | www.wo41.com | www.1368i.cc | www.15355z.com | www.81233p.com | www.50064x.com | www.150961.com | www.514611.com | www.814646.com | www.912339.com | www.hw6689.com | www.tj92.com | www.055b.cc | www.9155c.com | www.33598r.com | www.26163y.com | www.51515u.com | www.67258c.com | www.040435.com | www.xinyc2.com | www.401279.com | www.548338.com | www.xinyc8.com | www.613069.com | www.652592.com | www.624880.com | www.603294.com | www.550347.com | www.386918.com | www.343277.com | www.187396.com | www.062166.com | www.99788o.com | www.99677h.com | www.50026c.com | www.32123h.com | www.52303s.com | www.50026j.com | www.5522f.cc | www.hy6935.com | www.855790.com | www.hcw332.com | www.330276.com | www.88266p.com | www.88266x.com | www.12018.cc | www.rcw456.com | www.361576.com | www.61655p.com | www.66653l.com | www.981jc.com | www.809215.com | www.535051.com | www.178213.com | www.83033z.com | www.781566.com | www.hf0668.com | www.685548.com | www.98528f.com | www.595601.com | www.81520n.com | www.50052m.com | www.sygj9.com | www.xinyc8.com | www.89894q.com | www.50732y.com | www.hy6937.com | www.330832.com | www.76520n.com | www.hqcp3.com | www.342377.com | www.89894y.com | www.ban57.com | www.606674.com | www.50026n.com | www.076wy.com | www.504833.com | www.99677n.com | www.07hc.com | www.168153.com | www.54844.com | www.856659.com | www.66376g.com | www.083wy.com | www.485648.com | www.65707h.com | www.963220.com | www.bxcp3.com | www.1368j.cc | www.178726.com | www.9889hc.com | www.554363.com | www.53900p.com | www.677375.com | www.08588e.com | www.csw288.com | www.07163b.com | www.803402.com | www.50024j.com | www.588767.com | www.89969.cc | www.391110.com | www.69465.com | www.399046.com | www.2875n.com | www.178571.com | www.35czj.com | www.50052l.com | www.975627.com | www.26878r.com | www.808751.com | www.36166j.com | www.535059.com | www.918li.com | www.73736a.com | www.xinyc8.com | www.9818x.cc | www.106135.com | www.hx1111.com | www.bxcp3.com | www.507633.com | www.664by.com | www.54400b.com | www.759585.com | www.1333ac.com | www.50054i.com | www.587991.com | www.090.la | www.77114r.com | www.178532.com | www.918361.com | www.2632k.com | www.36166x.com | www.382780.com | www.hx6622.com | www.50080r.com | www.97655c.com | www.661929.com | www.ya619.com | www.07163d.com | www.35155t.com | www.155091.com | www.558363.com | www.c5957.com | www.088wy.com | www.99638p.com | www.063552.com | www.431770.com | www.657269.com | www.178012.com | www.1555hc.com | www.35155b.com | www.23579f.com | www.87668q.com | www.xinyc5.com | www.550264.com | www.xcw866.com | www.960307.com | www.lqc7.com | www.24czj.com | www.1035o.com | www.5854m.cc | www.5095v.com | www.8499y.com | www.66710.cc | www.6832v.com | www.3890l.com | www.89959.cc | www.664by.com | www.2373h.com | www.350zf.com | www.509866.com | www.5086p.com | www.6364o.com | www.1035v.com | www.5666hc.com | www.44czt.com | www.qmfc7.com | www.995684.com | www.938527.com | www.zuan222.com | www.701547.com | www.544097.com | www.369965.com | www.217650.com | www.88266g.com | www.50052h.com | www.66376s.com | www.7782b.com | www.66ckb.com | www.915044.com | www.665039.com | www.320667.com | www.025727.com | www.29277g.com | www.zuan222.com | www.575hc.com | www.936370.com | www.544094.com | www.088185.com | www.25688c.com | www.5441q.com | www.hx1165.com | www.599846.com | www.063353.com | www.77114m.com | www.99fzc.com | www.775020.com | www.223065.com | www.29178h.com | www.281877.com | www.852699.com | www.190994.com | www.88266h.com | www.878zf.com | www.771247.com | www.023128.com | www.00840g.com | www.890886.com | www.050236.com | www.9356o.com | www.927150.com | www.290282.com | www.33997y.com | www.920959.com | www.87668r.com | www.1368x.cc | www.rcw789.com | www.71233j.com | www.937787.com | www.80065d.com | www.022b.cc | www.530126.com | www.88266c.com | www.924177.com | www.66652b.com | www.qilc0.com | www.025069.com | www.88ttz.com | www.106316.com | www.23040.com | www.196067.com | www.781566.com | www.266991.com | www.5091p.com | www.236002.com | www.2350g.com | www.xinyc2.com | www.071wy.com | www.112028.com | www.fl82.com | www.39500y.com | www.809699.com | www.60108y.com | www.573898.com | www.9356d.com | www.fh7557.com | www.ya033.com | www.60108z.com | www.910883.com | www.50080x.com | www.369052.com | www.461.cc | www.35918g.com | www.hcw332.com | www.588yc.com | www.61233p.com | www.810277.com | www.3005.am | www.77801v.com | www.826925.com | www.5484h.com | www.65707m.com | www.589244.com | www.55ckb.com | www.78949x.com | www.310477.com | www.wcp686.com | www.9478o.com | www.60007y.com | www.730719.com | www.982jc.com | www.68689k.com | www.065766.com | www.594883.com | www.c1636.com | www.6364u.com | www.26878o.com | www.173631.com | www.599380.com | www.987931.com | www.918li.com | www.66332p.com | www.66621i.com | www.235387.com | www.680477.com | www.983888a.com | www.089wy.com | www.9356v.com | www.71233g.com | www.50064k.com | www.96386f.com | www.230757.com | www.498166.com | www.609387.com | www.781217.com | www.955381.com | www.hy6937.com | www.22czj.com | www.0719.cc | www.5086m.com | www.9155f.cc | www.53531.cc | www.9818f.cc | www.3890b.com | www.6832n.com | www.7782b.com | www.8039x.com | www.7782i.com | www.5091p.com | www.2373d.com | www.1368y.cc | www.050.la | www.hjin4.com | www.c5986.com | www.csw288.com | www.290282.com | www.723135.com | www.572699.com | www.351587.com | www.193987.com | www.96386h.com | www.52072n.com | www.83993m.com | www.50026x.com | www.5441v.com | www.22czj.com | www.011888a.com | www.699915.com | www.572113.com | www.231844.com | www.73166l.com | www.76520w.com | www.3479a.com | www.qbwc2.com | www.701574.com | www.349077.com | www.80767q.com | www.71233d.com | www.022xz.cc | www.998632.com | www.599810.com | www.116205.com | www.99788p.com | www.2109r.com | www.tj92.com | www.1248h.cc | www.848966.com | www.319126.com | www.50080x.com | www.5086l.com | www.958351.com | www.281110.com | www.96386f.com | www.055.la | www.558610.com | www.52303o.com | www.5086l.com | www.802733.com | www.234972.com | www.50026s.com | www.xcw866.com | www.196346.com | www.33598q.com | www.csw288.com | www.89894v.com | www.cll168.com | www.626212.com | www.33588g.com | www.88cmc.com | www.372839.com | www.61655p.com | www.cc6769.com | www.196039.com | www.6364k.com | www.594211.com | www.81520g.com | www.sj119.9slyl.com | www.126019.com | www.686vv.com | www.327988.com | www.9205d.com | www.516113.com | www.50054c.com | www.631279.com | www.77801s.com | www.767200.com | www.16878l.com | www.810262.com | www.88266g.com | www.722563.com | www.68568j.com | www.630958.com | www.35155l.com | www.496918.com | www.3479d.com | www.187397.com | www.23hf.com | www.43818k.com | www.894450.com | www.60123t.com | www.461113.com | www.2350p.com | www.068671.com | www.hx6693.com | www.16878w.com | www.582993.com | www.1248g.cc | www.53900l.com | www.700345.com | www.3005.am | www.89894u.com | www.900248.com | www.12455h.com | www.055168.cc | www.901582.com | www.08588z.com | www.068631.com | www.784782.com | www.3005w.com | www.52072q.com | www.550414.com | www.jcai1.com | www.68568y.com | www.178319.com | www.788151.com | www.371q.cc | www.87668s.com | www.324277.com | www.xinyc3.com | www.544bb.cc | www.71399g.com | www.032059.com | www.603154.com | www.hx6692.com | www.9478a.com | www.50024b.com | www.548511.com | www.933709.com | www.686pp.com | www.54400b.com | www.bxcp3.com | www.501342.com | www.931669.com | www.288hc.com | www.02500w.com | www.26878o.com | www.86267l.com | www.xcw866.com | www.586974.com | www.912480.com | www.hjin7.com | www.2109k.com | www.26163r.com | www.35155p.com | www.89894u.com | www.330276.com | www.539126.com | www.645326.com | www.luck887.com | www.ch8900.com | www.can87.com | www.918li.com | www.39391.cc | www.87467.com | www.50051n.com | www.52072s.com | www.80075f.com | www.bxcp3.com | www.26878p.com | www.32123g.com | www.16878j.com | www.08588c.com | www.23636g.com | www.96386y.com | www.83033g.com | www.66653l.com | www.35918m.com | www.9356m.com | www.3126v.com | www.073wy.com | www.sfk3.com | www.937787.com | www.810877.com | www.602927.com | www.407872.com | www.189370.com | www.86267q.com | www.32123d.com | www.50989j.com | www.3479i.com | www.tang000.com | www.c300.cc | www.721588.com | www.450689.com | www.196806.com | www.50788l.com | www.54400j.com | www.055i.cc | www.927320.com | www.ywzuqiu.com | www.175969.com | www.35918s.com | www.15239.cc | www.c146.vip | www.559748.com | www.99638p.com | www.55228f.com | www.19kpl.com | www.689477.com | www.rcw321.com | www.96386d.com | www.9889hc.com | www.691063.com | www.96386h.com | www.36788q.com | www.hx6694.com | www.376531.com | www.33598k.com | www.885pz.com | www.622209.com | www.77114f.com | www.62355.com | www.cp369.net | www.320663.com | www.83993z.com | www.qilc2.com | www.394211.com | www.00840q.com | www.zcwf5.com | www.319126.com | www.53900b.com | www.915399.com | www.89894i.com | www.2408e.cc | www.503662.com | www.78700g.com | www.799666aa.com | www.506477.com | www.77801n.com | www.903079.com | www.71233l.com | www.lycp886.com | www.234269.com | www.8499w.com | www.548477.com | www.50024d.com | www.689631.com | www.90305c.com | www.867865.com | www.36788w.com | www.914077.com | www.35918r.com | www.905844.com | www.53900m.com | www.960923.com | www.35918k.com | www.898418.com | www.99677q.com | www.758786.com | www.55228b.com | www.566677.com | www.9205c.com | www.374311.com | www.103ak.com | www.083065.com | www.hf0666.com | www.33598u.com | www.635850.com | www.9149e.com | www.xinyc1.com | www.22dwj.com | www.53911d.com | www.760250.com | www.27776.cc | www.349377.com | www.318548.com | www.33112a.com | www.564658.com | www.081wy.com | www.50051v.com | www.602983.com | www.669by.com | www.50074a.com | www.606920.com | www.688dl.com | www.41518j.com | www.529081.com | www.lczg5.com | www.61233c.com | www.202901.com | www.901770.com | www.5441v.com | www.60007z.com | www.659957.com | www.ya044.com | www.50788j.com | www.099386.com | www.671566.com | www.55fzc.com | www.49956x.com | www.77802l.com | www.444801.com | www.901770.com | www.500pt.com | www.66332b.com | www.80767z.com | www.401282.com | www.846689.com | www.267by.com | www.80767.com | www.33598u.com | www.155782.com | www.542770.com | www.843933.com | www.sygj1.com | www.2632x.com | www.83993q.com | www.hcw332.com | www.346577.com | www.609810.com | www.826927.com | www.c1350.com | www.585hc.com | www.22743.com | www.50788y.com | www.99788m.com | www.50788l.com | www.77803l.com | www.032154.com | www.188932.com | www.346918.com | www.400322.com | www.560703.com | www.567630.com | www.599439.com | www.602857.com | www.622105.com | www.606920.com | www.54968f.com | www.562500.com | www.541638.com | www.401279.com | www.330692.com | www.224344.com | www.165090.com | www.106135.com | www.86267g.com | www.60123z.com | www.26878c.com | www.60108t.com | www.41518.com | www.0014m.com | www.66ffy.com | www.cp8018.cc | www.896020.com | www.599894.com | www.309135.com | www.040431.com | www.49956d.com | www.52303b.com | www.3005w.com | www.bai355.com | www.915056.com | www.589744.com | www.210602.com | www.81233o.com | www.bxcp3.com | www.5522a.cc | www.cpkk6.com | www.lcw997.com | www.293399.com | www.51515y.com | www.26878j.com | www.gai40.com | www.689244.com | www.187516.com | www.08588v.com | www.fh7557.com | www.912183.com | www.346077.com | www.50052n.com | www.3479u.com | www.911888.com | www.330716.com | www.50052hh.com | www.3478v.cc | www.rcw8855.com | www.127918.com | www.81678r.com | www.zch4.com | www.le33.cc | www.33588s.com | www.267by.com | www.596233.com | www.57578a.com | www.6364i.com | www.739233.com | www.78949e.com | www.2875r.com | www.618393.com | www.50080b.com | www.99jtc.com | www.456685.com | www.91233x.com | www.ck9191.com | www.106260.com | www.3478l.cc | www.589467.com | www.87668q.com | www.952583.com | www.99788q.com | www.981jc.com | www.398846.com | www.26878l.com | www.611036.com | www.68689m.com | www.786819.com | www.07163a.com | www.895594.com | www.33997l.com | www.919509.com | www.50064v.com | www.911888a.com | www.60007r.com | www.976561.com | www.34788c.com | www.820687.com | www.77802g.com | www.636550.com | www.15355z.com | www.399010.com | www.0014h.com | www.135169.com | www.qilc0.com | www.50732u.com | www.817055.com | www.50026z.com | www.439863.com | www.078wy.com | www.132880.com | www.yy63.com | www.21202e.com | www.649880.com | www.6832w.com | www.fh7557.com | www.hm2666.com | www.91233b.com | www.507670.com | www.267by.com | www.50064u.com | www.673066.com | www.30601.cc | www.031079.com | www.890702.com | www.69998.cc | www.88266l.com | www.808390.com | www.5091a.com | www.90305b.com | www.717885.com | www.3478l.cc | www.43131m.com | www.502135.com | www.hc2988.com | www.39957g.com | www.87668z.com | www.612212.com | www.fan03.com | www.51331b.com | www.88858c.com | www.623190.com | www.mody8.com | www.23579b.com | www.77114w.com | www.406577.com | www.xcw866.com | www.087wy.com | www.54400k.com | www.84499h.com | www.502892.com | www.899495.com | www.78gcw.com | www.15355y.com | www.41518x.com | www.155782.com | www.550164.com | www.847568.com | www.gczj9.com | www.5095i.com | www.61233x.com | www.52303l.com | www.160883.com | www.406577.com | www.638262.com | www.902257.com | www.hx6686.com | www.999hy.cc | www.9311c.com | www.50064f.com | www.21202hh.com | www.60007n.com | www.80075b.com | www.115779.com | www.260929.com | www.627012.com | www.550254.com | www.602582.com | www.648689.com | www.hcw823.com | www.757988.com | www.799243.com | www.807266.com | www.572699.com | www.802865.com | www.795917.com | www.731996.com | www.629012.com | www.526093.com | www.346411.com | www.178593.com |