<rt id="bn8ez"></rt>
<label id="bn8ez"></label>

  • <span id="bn8ez"></span>

    <label id="bn8ez"><meter id="bn8ez"></meter></label>

    allen
    專注于java ee技術,包括struts,jsf,webwork,spring,hibernate,ibatis
    posts - 7,  comments - 9,  trackbacks - 0
    ?Create?? Proc?? proc_insert?? (@tablename?? varchar(256))????
    ??? as?????????????????????????????????????????????? --?? 表名稱??
    ? begin????
    ????? set?? nocount?? on??
    ????????? Declare?? @sqlstr???? varchar(4000),??
    ????????????????????????? @sqlstr1?? varchar(4000),??
    ????????????????????????? @sqlstr2?? varchar(4000)??
    ???
    ??????????? Select?? @sqlstr='select?? ''Insert?? '+@tablename????
    ???
    ??????????????? Select?? @sqlstr1=?? '?? Values?? (?? ''+',?????? @sqlstr2='?? ('??
    ???
    ??????????????? Select?? @sqlstr1=@sqlstr1+col+'+'',''+'?? ,@sqlstr2=@sqlstr2+name?? +','?? from(Select?? case????
    ???
    ? --?????????? when?? a.xtype?? =173?? then?? 'case?? when?? '+a.name+'?? is?? null?? then?? ''NULL''?? else?? '+'convert(varchar('+convert(varchar(4),a.length*2+2)+'),'+a.name?? +')'+'?? end'??
    ???
    ??????????????? when?? a.xtype?? =104?? then?? 'case?? when?? '+a.name+'?? is?? null?? then?? ''NULL''?? else?? '+'convert(varchar(1),'+a.name?? +')'+'?? end'??
    ???
    ??????????????? when?? a.xtype?? =175?? then?? 'case?? when?? '+a.name+'?? is?? null?? then?? ''NULL''?? else?? '+'''''''''+'+'replace('+a.name+','''''''','''''''''''')'?? +?? '+'''''''''+'?? end'??
    ???
    ??????????????? when?? a.xtype?? =61???? then?? 'case?? when?? '+a.name+'?? is?? null?? then?? ''NULL''?? else?? '+'''''''''+'+'convert(varchar(23),'+a.name?? +',121)'+?? '+'''''''''+'?? end'??
    ???
    ??????????????? when?? a.xtype?? =106?? then?? 'case?? when?? '+a.name+'?? is?? null?? then?? ''NULL''?? else?? '+'convert(varchar('+convert(varchar(4),a.xprec+2)+'),'+a.name?? +')'+'?? end'??
    ???
    ??????????????? when?? a.xtype?? =62???? then?? 'case?? when?? '+a.name+'?? is?? null?? then?? ''NULL''?? else?? '+'convert(varchar(23),'+a.name?? +',2)'+'?? end'??
    ???
    ??????????????? when?? a.xtype?? =56???? then?? 'case?? when?? '+a.name+'?? is?? null?? then?? ''NULL''?? else?? '+'convert(varchar(11),'+a.name?? +')'+'?? end'??
    ???
    ??????????????? when?? a.xtype?? =60???? then?? 'case?? when?? '+a.name+'?? is?? null?? then?? ''NULL''?? else?? '+'convert(varchar(22),'+a.name?? +')'+'?? end'??
    ???
    ??????????????? when?? a.xtype?? =239?? then?? 'case?? when?? '+a.name+'?? is?? null?? then?? ''NULL''?? else?? '+'''''''''+'+'replace('+a.name+','''''''','''''''''''')'?? +?? '+'''''''''+'?? end'??
    ???
    ??????????????? when?? a.xtype?? =108?? then?? 'case?? when?? '+a.name+'?? is?? null?? then?? ''NULL''?? else?? '+'convert(varchar('+convert(varchar(4),a.xprec+2)+'),'+a.name?? +')'+'?? end'??
    ???
    ??????????????? when?? a.xtype?? =231?? then?? 'case?? when?? '+a.name+'?? is?? null?? then?? ''NULL''?? else?? '+'''''''''+'+'replace('+a.name+','''''''','''''''''''')'?? +?? '+'''''''''+'?? end'??
    ???
    ??????????????? when?? a.xtype?? =59???? then?? 'case?? when?? '+a.name+'?? is?? null?? then?? ''NULL''?? else?? '+'convert(varchar(23),'+a.name?? +',2)'+'?? end'??
    ???
    ??????????????? when?? a.xtype?? =58???? then?? 'case?? when?? '+a.name+'?? is?? null?? then?? ''NULL''?? else?? '+'''''''''+'+'convert(varchar(23),'+a.name?? +',121)'+?? '+'''''''''+'?? end'??
    ???
    ??????????????? when?? a.xtype?? =52???? then?? 'case?? when?? '+a.name+'?? is?? null?? then?? ''NULL''?? else?? '+'convert(varchar(12),'+a.name?? +')'+'?? end'??
    ???
    ??????????????? when?? a.xtype?? =122?? then?? 'case?? when?? '+a.name+'?? is?? null?? then?? ''NULL''?? else?? '+'convert(varchar(22),'+a.name?? +')'+'?? end'??
    ???
    ??????????????? when?? a.xtype?? =48???? then?? 'case?? when?? '+a.name+'?? is?? null?? then?? ''NULL''?? else?? '+'convert(varchar(6),'+a.name?? +')'+'?? end'??
    ???
    ? --?????????? when?? a.xtype?? =165?? then?? 'case?? when?? '+a.name+'?? is?? null?? then?? ''NULL''?? else?? '+'convert(varchar('+convert(varchar(4),a.length*2+2)+'),'+a.name?? +')'+'?? end'??
    ???
    ??????????????? when?? a.xtype?? =167?? then?? 'case?? when?? '+a.name+'?? is?? null?? then?? ''NULL''?? else?? '+'''''''''+'+'replace('+a.name+','''''''','''''''''''')'?? +?? '+'''''''''+'?? end'??
    ???
    ??????????????? else?? '''NULL'''??
    ???
    ??????????????? end?? as?? col,a.colid,a.name??
    ???
    ??????????????? from?? syscolumns?? a?? where?? a.id?? =?? object_id(@tablename)?? and?? a.xtype?? <>189?? and?? a.xtype?? <>34?? and?? a.xtype?? <>35?? and???? a.xtype?? <>36??
    ???
    ??????????????? )t?? order?? by?? colid??
    ?????
    ??????????????? select?? @sqlstr=@sqlstr+left(@sqlstr2,len(@sqlstr2)-1)+')?? '+left(@sqlstr1,len(@sqlstr1)-3)+')''?? from?? '+@tablename??
    ?????
    ??????????????? exec(?? @sqlstr)??
    ???
    ??????????????? set?? nocount?? off??
    ???
    ? end??
    ???
    ?
    GO
    posted on 2007-03-06 15:41 robbin163 閱讀(525) 評論(0)  編輯  收藏

    只有注冊用戶登錄后才能發表評論。


    網站導航:
     

    <2025年5月>
    27282930123
    45678910
    11121314151617
    18192021222324
    25262728293031
    1234567

    常用鏈接

    留言簿(3)

    隨筆分類

    隨筆檔案

    文章分類

    文章檔案

    搜索

    •  

    最新評論

    閱讀排行榜

    評論排行榜

    主站蜘蛛池模板: 亚洲精选在线观看| 国产成人精品日本亚洲直接| 亚洲日本在线观看视频| 亚洲免费精彩视频在线观看| a级毛片在线免费看| 精品久久久久久久久免费影院| 亚洲AV蜜桃永久无码精品| 4444亚洲国产成人精品| 女人裸身j部免费视频无遮挡| 日本高清在线免费| 国产亚洲精品资在线| 亚洲videos| 日韩精品内射视频免费观看| 亚洲?V无码成人精品区日韩| 免费无码午夜福利片| 亚洲精品456播放| 美女被羞羞网站免费下载| 国产免费AV片在线播放唯爱网| 亚洲国产成人高清在线观看 | 亚洲精品无码久久久影院相关影片| 亚洲一卡二卡三卡四卡无卡麻豆| 曰批全过程免费视频播放网站| 国产aⅴ无码专区亚洲av麻豆| 久久精品国产亚洲AV电影网| 一个人看www在线高清免费看| 久久久亚洲精华液精华液精华液 | 日韩激情淫片免费看| 精品久久久久久亚洲精品| 大地资源二在线观看免费高清| 亚洲Av无码一区二区二三区 | 亚洲高清最新av网站| 久久精品国产亚洲AV| 国产中文在线亚洲精品官网| 伊人久久免费视频| 亚洲午夜精品久久久久久人妖 | 天堂亚洲免费视频| 无人在线观看免费高清| 亚洲日产乱码一二三区别| 免费毛片网站在线观看| 亚洲欧洲日产国码久在线| 亚洲伊人久久综合影院|