技术备忘记录
lairiwei
努力工作中
展开
-
ShowModeldDalog 用法
<br />基本介绍: <br /> showModalDialog() (IE 4+ 支持)<br /> showModelessDialog() (IE 5+ 支持)<br /> window.showModalDialog() 方法用来创建一个显示HTML内容的模态对话框。<br /> window.showModelessDialog()原创 2011-02-16 14:43:00 · 125 阅读 · 0 评论 -
自动增长列
<br />如果数据表本身并不内含自动地增编号的字段时,要怎么做才能够让SELECT 查询结果如图表1所示,额外增加自动递增序号呢?我们提供下列五种方法供您参考:<br /><br />USE 北风贸易;<br />GO<br />/* 方法一*/<br />SELECT 序号= (SELECT COUNT(客户编号) FROM 客户 AS LiMing<br />WHERE LiMing.客户编号<= Chang.客户编号),<br />客户编号, 公司名称<br />FROM 客户 AS Chang O原创 2011-04-19 17:31:00 · 259 阅读 · 0 评论 -
增加排序字段
<br />select<br />ROW_NUMBER() OVER(ORDER BY Convey_Fee desc) as z,<br />rank() OVER(ORDER BY Convey_Fee desc) as z,<br />DENSE_RANK() OVER(ORDER BY Convey_Fee desc) as z,<br />NTILE(4) OVER(ORDER BY Convey_Fee desc) as z, <br />(select sum(1) from Consign原创 2011-04-18 15:35:00 · 207 阅读 · 0 评论 -
网页中使用iframe
<br /> <iframe id="iFrame1" name="iFrame1" width="100%" onload="this.height=iFrame1.document.body.scrollHeight" scrolling="no" frameborder="0" src="main.aspx"><br /></iframe><br />关键就在于onload="this.height=iFrame1.document.body.scrollHeight"!原创 2011-04-29 16:56:00 · 150 阅读 · 0 评论 -
金钱转大写,数字转大写
<br />CREATE FUNCTION CapitalRMB(@ChangeMoney numeric(15,2)) <br />RETURNS VarChar(100) AS <br />BEGIN <br /> Declare @String1 char(20)<br /> Declare @String2 char(30)<br /> Declare @String4 Varchar(100)<br /> Declare @Strin原创 2011-04-29 18:07:00 · 1251 阅读 · 0 评论 -
金额转大写
<br />CREATE FUNCTION CapitalRMB(@ChangeMoney numeric(15,2)) <br />RETURNS VarChar(100) AS <br />BEGIN <br /> Declare @String1 char(20)<br /> Declare @String2 char(30)<br /> Declare @String4 Varchar(100)<br /> Declare @Strin原创 2011-04-29 18:11:00 · 216 阅读 · 0 评论 -
C#泛型
<br />using System; <br />using System.Collections; <br />using System.Configuration; <br />using System.Data; <br />using System.Linq; <br />using System.Web; <br />using System.Web.Security; <br />using System.Web.UI; <br />using System.W原创 2011-04-29 18:12:00 · 180 阅读 · 0 评论 -
Sqlhelper
1.using System; 2.using System.Collections.Generic; 3.using System.Text; 4.using System.Collections; 5.using System.Data; 6.using System.Data.SqlClient; 7.using System.Configur转载 2012-02-28 15:15:47 · 184 阅读 · 0 评论