Sql Server 基础知识: http://blog.csdn.net/t6786780/article/details/4525652 Sql Server 语句大全: http://www.cnblogs.com/yubinfeng/archive/2010/11/02/1867386.html 原文:http://www.cnblogs.com/mingmingruyuedlut/p/3197377.html
1.下载Microsoft Drivers for PHP for SQL Server 扩展包 它分为2.0和3.0版本。(本人使用的是2.0版本)这个扩展包对电脑的操作系统有要求,对应的系统使用对应的版本。3.0 所支持的操作系统Windows Server 2008 R2 SP1Windows Vista SP2Windows Server 2008 SP2Windows 7 SP12.0 所支持的操作系统Windows Server 2003 Service Pack 1Windows XP Service Pack 3Windows Vista Service Pack 1 or laterWindows Server 2008Windows S...
1. 前言 3 2. 报警信息 3 3. NFR的检测 4 4. 协议分析 8 5. 漏洞说明 15 6. 漏洞分析 18 7. 小结 20 1. 前言 NFR(Network Flight Recorder)是一个老牌的商业网络IDS产品,最初由Firewall的牛人Marcus J. Ranum创建,是作为一个通用的网络流量分析和记录软件来实现的,为了最大限度地发挥分析工具的灵活性,NFR提供了完善强大的N-Code脚本语言,在很多的评测中表现出色。虽然L0pht为NFR提供过数百个签名库,但是缺...
PHP4.0.6以上可以在 Win32 平台中访问 COM 和 DCOM 对象。这里借用ASP思想访问一下SQLServer。当然你也可以用mssql系列函数。如果是一个ASP Coder,你会觉得下面代码非常眼熟,习惯----无他,但PHP强尔~_~://Author: erquan//Date: 2003-3-4//City:郑州 $dbConn=new COM ("ADODB.Connection") or die("创建COM失败"); $ADO="Provider=sqloledb;Data Source=localhost;Initial Catalog=myTest;User Id=sa;Password...
//在PHP中处理日期非常不方便,比如求两个日期之间相差的月份?该怎么办呢? //文件名:date.inc.php3 //在使用这两个函数前,要先将日期或日期时间转换成timestamp类型。 //如: //$today=mktime(0,0,0,date("m"),date("d"),date("Y")); /****模拟sqlserver中的dateadd函数******* $part 类型:string 取值范围:year,month,day,hour,min,sec 表示:要增加的日期的哪个部分 $n 类型:...
通过ODBC连接的SQL SERVER实例一 $connection = odbc_connect("mydata","userid","passwd"); $query = "select * from tab_1 where no>0" ; $result = odbc_do($connection,$query) ; print ""; while(odbc_fetch_into($result,&$fields)) { print "\n"; for ($i = 21; $i print ""; } } print ""; odbc_close($connection); ?>
$id=@mssql_connect("ddy","sa"," ") or die("连接不上"); $db=mssql_select_db("ddy",$id); $query="select * from lr00 order by lr0012 desc"; $result=mssql_query($query); if($result): if($tt==""){ $nopa=0;} else $nopa=$tt; $gg=mssql_num_rows($result); echo $gg; $k=0; $i=0; $dd=mssql_fetch_array($result); if(!$dd){echo '到底了';} while($dd&&$nopaif($nopa>=$gg) $nopa=$gg; @mssql_data_seek($result,$nopa);...
require "config.php"; dl("extensions/php_mssql70.dll"); if (!isset($page)) { $page=1; } if ($page $db=mssql_connect($local,$user,$pass); mssql_select_db($name,$db); $query=mssql_query("select count(*) as date from news",$db); $query=mssql_fetch_array($query); $pages=ceil($query[0]/$userperpage); if ($page>$pages) { $page=$pages;} if ($query[0] $dangqian=($page...
//文件名:date.inc.php3//在使用这两个函数前,要先将日期或日期时间转换成timestamp类型。//如://$today=mktime(0,0,0,date("m"),date("d"),date("Y"));/****模拟sqlserver中的dateadd函数*******$part 类型:string取值范围:year,month,day,hour,min,sec表示:要增加的日期的哪个部分$n 类型:数值表示:要增加多少,根据$part决定增加哪个部分可为负数$datetime类型:timestamp表示:增加的基数返回 类型:timestamp********...
USE Northwind;2 GO3 4 IF exists (select * from dbo.sysobjects where id =object_id(N‘[dbo].[sp_name]‘) and OBJECTPROPERTY(id, N‘IsProcedure‘)= 1)5 BEGIN --判断数据库中是否已经存在该存储过程6 DROP PROCEDURE sp_name;7 END8 GO9 CREATE PROCEDURE sp_name
10 AS
11 BEGIN
12 SELECT * FROM Employees
13 END
14 EXEC sp_name;View Code
二.带输入参数1 IF exists (select * from dbo.sysobjects where id =o...
orderid, YEAR(orderdate) AS orderyear
FROM Sales.Orders
WHERE orderyear > 2006;这是错误的,WHERE子句中并不能识别orderyear别名,应该改为:SELECT orderid, YEAR(orderdate) AS orderyear
FROM Sales.Orders
WHERE YEAR(orderdate) > 2006;
关于WITH TIES选项
先看下面这段代码:SELECT TOP (5) orderid, orderdate, custid, empid
FROM Sales.Orders
ORDER BY orderdate DESC, orderid DESC;执行查询结果如图:
加上WITH ...
E.empid, E.firstname, E.lastname, O.orderid
FROM HR.Employees AS EJOIN Sales.Orders AS OON E.empid = O.empid; 另一种写法:SELECT E.empid, E.firstname, E.lastname, O.orderid
FROM HR.Employees AS E, Sales.Orders AS O
WHERE E.empid = O.empid; 上面这种写法类似于交叉联接。
外联接
在外联接中,要把一个表标记为“保留的”表,可以在表名之间使用关键字LEFT OUTER JOIN、RIGHT OUTER JOIN,以及FULL OUTER JOIN,其...
orderyear, COUNT(DISTINCT custid) AS numcusts
FROM (SELECT YEAR(orderdate), custidFROM Sales.Orders) AS D(orderyear, custid)
GROUP BY orderyear;公用表表达式
公用表表达式(CTE,Common table expression)是用WITH子句定义的,一般格式为:WITH USACusts AS
(SELECT custid, companynameFROM Sales.CustomersWHERE country = N‘USA‘
)
SELECT * FROM USACusts; 和派生表一样,一旦外部查询完成,CTE的生命期就结束了。...
country, region, city FROM HR.Employees
UNION ALL
SELECT country, region, city FROM Sales.Customers;UNION DISTINCT集合运算
UNION DISTINCT会删除重复行。SELECT country, region, city FROM HR.Employees
UNION
SELECT country, region, city FROM Sales.Customers;INTERSECT DISTINCT集合运算SELECT country, region, city FROM HR.Employees
INTERSECT
SELECT country, region, city FROM Sales.Customers; 注意一点,集...
empid,SUM(CASE WHEN custid = ‘A‘ THEN qty END) AS A,SUM(CASE WHEN custid = ‘B‘ THEN qty END) AS B,SUM(CASE WHEN custid = ‘C‘ THEN qty END) AS C,SUM(CASE WHEN custid = ‘D‘ THEN qty END) AS D
FROM dbo.Orders
GROUP BY empid;
使用T-SQL PIVOT运算符进行透视转换。SQL Server 2005引入了一个T-SQL特有的表运算符PIVOT,PIVOT运算符同样涉及三个逻辑处理阶段(分组、扩展和聚合)。注意,一般不直接把PIVOT运...