为了美化页面，防止列表中字数过多。在SQL语句中根据字符长度判断，如果字符超常，则显示为有限字符加”…”。select Case when Len(ShowFiled)>50 then Substring(ShowFiled,1,50)+’…’ else ShowFiled End as ShowFiled from Table
/******* 导出到excel EXEC master..xp_cmdshell ‘bcp SettleDB.dbo.shanghu out c:\temp1.xls -c -q -S”GNETDATA/GNETDATA” -U”sa” -P”"‘ /*********** 导入Excel Select * FROM OpenDataSource( ‘Microsoft.Jet.OLEDB.4.0′, ‘Data Source=”c:\test.xls”;User ID=Admin;Password=;Extended properties=Excel 5.0′)…xa...
1、OpenVideoPlayer：http://openvideoplayer.sourceforge.net/ 全平台播放器。这个很猛，使用AS3.0编写。另外还有Silverlight、HTML5和iOS版本的播放器； 2、FryPlayer：http://fryplayer.net/ HTML5播放器。是个JQuery插件。俄国人作品； 3、Mooplay：http://mooplay.challet.eu/ HTML5播放器。FREE。基于Mootools1.2，demo很简洁，一...
int a = 12345678;//格式为sring输出Label1.Text = string.Format("asdfadsf{0}adsfasdf",a);Label2.Text = "asdfadsf"+a.ToString()+"adsfasdf";Label1.Text = string.Format("asdfadsf{0:C}adsfasdf",a);//asdfadsf￥1,234.00adsfasdfLabel2.Text = "asdfadsf"+a.ToString("C")+"adsfasdf";//asdfadsf￥1,234.00adsfasd...
--导入数据插入标识列，ID重复则替换，旧表中没有的列用'abc' as Field进行插入
SET IDENTITY_INSERT NetCMS.dbo.NT_channel_video ON
insert into NetCMS.dbo.NT_channel_video(Id,title,ch_videourl,Author,Souce,CreatTime,[Content],NaviContent,ChID,ClassID,OrderID,
isdelpoint,isHTML,isConstr,ConstrTF,TitleITF,TitleBTF,ContentProper...
- «
- 1
- ...
- 14
- 15
- 16
- 17
- 18
- 19
- 20
- ...
- 22
- »