240个国外SQL Server高手的博客集萃
Aaron Bertrand
Adam Machanic
All Things SQL Server
Allen Kinsel - SQL DBA
Allen White
Amit Bansal writes...
Andrew Fryer's Blog
Andrew Kelly
Andy Leonard
Anything and Everything IT
Arcane Code
Arnie Rowland: Ramblings of a Harried Technogeek
B.I. for the SQL Guy
Bart Duncan's SQL Weblog
belle's sql musings
Benchmark IT Consulting
Benjamin Wright-Jones
BI Polar
BI Thoughts and Theories
Bill Ramos on SQL Server
Bluedog67
Bob Beauchemin's Blog
Bob Duffy's Blobby Blog
Boyan Penev on Microsoft BI
Brad M McGehee
Brent Ozar - SQL Server DBA
Brian Knight
Brian Knight
Carpe Datum
Carter's Dad - Parker's Dad Too!
Chadhoc.net
Chris Randall's SQL Blog
codegumbo
Conor Cunningham's Blog
Craig Freedman's SQL Server Blog
Cristian's Blog
Dan Guzman's Blog
Dangling On The Shoulders Of Giants
Dan's Blog
Darren Gosbell [MVP] - Random Procrastination
Data Dude
Dave does Data
DavidM
DBA Field Notes
DBA Will
Dejan Sarka: Posts
Denis Gobo
Dinesh's Blog :::: Being Compiled ::::
Dirty Reads ...
Donald Farmer: Foraging in the Data Forest
DotNetKicks.com - Stories tagged with SQL
DotNetShoutout - Latest published stories in SQL
Dougbert.com
Elizabeth Vitt
Eugene Asahara
Exploring SQL...
facility9
Gemini Team Blog
Glenn Berry's SQL Server Performance
Greg A. Johnson's Blog
Greg Larsen's Blog
Have Data Will Travel
Home of the Scary DBA
I want some Moore
ILIKESQL.COM blog
In Recovery...
http://blogs.msdn.com/isaac/default.aspx
It's A Musing
Jack
Jamie's Junk
Jason Massie
Jeff's SQL Server Blog
Jessica M. Moss
Jimmy May, Aspiring Geek: SQL Server Performance, Best Practices, Productivity, etc.
Joe Sack's SQL Server WebLog
Joe Webb
John Gallardo's Weblog
Jorg Klein
Josef Richberg
Journey to SQL Authority with Pinal Dave
Kalen Delaney
Keep It Simple and Fast
Kendal Van Dyke
Kevin Kline
Kimberly L. Tripp: Improving *my* SQL skills through your questions!
La bodeguita de Nacho
Latest SQL-Server-Performance.com Articl
相关文档:
PL/SQL块
declare
begin
--SQL语句
--直接写的SQL语句(DML/TCL)
--间接写execute immediate <DDL/DCL命令字符串>
--select 语句
<1>必须带有into子句
......
1。如果装sql server中未出现异常的话,且一些自选参数,账户,密码等没有错误的话。一旦出现诸如socket建立不起,连接不上等问题。最有效的解决方法是打补丁,其中sp4:http://www.microsoft.com/downloads/details.aspx?DisplayLang=zh-cn&FamilyID=8e2dfc8d-c20e-4446-99a9-b7f0213f8bc5,sp3a:http://www.microsof ......
先来一段代码:
WITH OrderedOrders AS
(SELECT *,
ROW_NUMBER() OVER (order by [id])as RowNumber --id是用来排序的列
from table_info ) --table_info是表名
SELECT *
from OrderedOrders
WHERE RowNumber between 50 and 60;
在windows server 2003, sql server 2005 CTP,P4 2.66GHZ,1GB 内存下测试,执行时 ......