临冰听雪丶

摘要：C = CHECK 约束D = 默认值或 DEFAULT 约束F = FOREIGN KEY 约束L = 日志FN = 标量函数IF = 内嵌表函数P = 存储过程PK = PRIMARY KEY 约束（类型是 K）RF = 复制筛选存储过程S = 系统表TF = 表函数TR = 触发器U = 用户... 阅读全文

摘要：select * from sysobjects where xtype='U' 阅读全文

摘要：using System;using System.Collections.Generic;using System.Net;using System.IO;namespace HGFTP{ /// /// FTP客户端操作类 /// public class FTPTo... 阅读全文

摘要：SELECT * FROM (SELECT columns,ROWNUM AS RN FROM (SELECT DISTINCT columns FROM table WHERE 1=1)) T WHERE RN = '1'SELECT * from (SELECT columns,(ROW_NUM... 阅读全文

摘要：首先，创建一个windows服务项目 阅读全文

摘要：select * from (SELECT t.*,ROWNUM AS RN FROM AWARDISSUE_FOOTBALL t ORDER BY ID DESC) WHERE RN=2 阅读全文

摘要：/****** Object: StoredProcedure [dbo].[PRO_Pub_FenYe] Script Date: 08/04/2014 11:14:22 ******/SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGO/*--suc... 阅读全文

摘要：select top 5 * from books where id not in(select top (5*(5-1)) id from Books order by id) order by idselect top 2 * from Users where id not in(select ... 阅读全文

摘要：Create table T_ErrorLogTable_tb( ELTID int identity(1,1) primary key,--编号 ELTTime date,--错误发生日期 ELTAddress nvarchar(50),--错误发生地址 ELTMessage nvarchar(2... 阅读全文

摘要：Password=密码;User ID=ID;Data Source=(DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = ip地址)(PORT = 端口号)) ) (CONNECT_D... 阅读全文

摘要：代码 Code highlighting produced by Actipro CodeHighlighter (freeware)http://www.CodeHighlighter.com/-->using System;using System.Collections.Generic;usi... 阅读全文

摘要：// 获取程序的基目录。 System.AppDomain.CurrentDomain.BaseDirectory // 获取模块的完整路径。 System.Diagnostics.Process.GetCurrentProcess().MainModule.FileName // 获取和设置当前目... 阅读全文

摘要：code:j6stndb9tk72xfbhbqczcdqnjd8lyj466nnumber:882851ps：xs374ca 阅读全文

摘要：/// /// 根据页数分页 /// /// /// /// /// /// public static DataSet GetListByPage(int page, i... 阅读全文