临冰听雪丶

摘要： 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 阅读全文