create proc P_QuerySplit
 @sqlscript varchar(20),         --表名/SQL语句
 @pageSize int,                  --每页记录数
 @pageIndex int,                 --当前页
 @totalCount int output,         --总记录数
 @totalPage int output        --总页数
as
  declare @v_sqlscript varchar(20)
  declare @v_PageSize int
  declare @v_PageIndex int
  declare @v_SQL_Count int
  declare @v_SQL varchar(4000)
  declare @v_StartIndex int
  declare @v_EndIndex int
 set @v_PageSize=@pageSize
 --每页记录数
if @v_PageSize=0
 set @v_PageSize=1
print @v_pageSize
--查询总记录数
select @v_SQL_Count=count(1) from stuInfo
set @totalCount=@v_SQL_C ......

//这是添加 
private void button1_Click(object sender, EventArgs e)
        {
            string s = "Persist Security Info=False;Integrated Security=SSPI;database=IIntegration;server=(local)";
            using (SqlConnection conn = new SqlConnection(s))
            {
                using (SqlCommand cmd1 = new SqlCommand("INSERT testxml VALUES(@ID, @XmlData)", conn))
                {
                    conn.Open();
                    cmd ......

//这是添加 
private void button1_Click(object sender, EventArgs e)
        {
            string s = "Persist Security Info=False;Integrated Security=SSPI;database=IIntegration;server=(local)";
            using (SqlConnection conn = new SqlConnection(s))
            {
                using (SqlCommand cmd1 = new SqlCommand("INSERT testxml VALUES(@ID, @XmlData)", conn))
                {
                    conn.Open();
                    cmd ......

MySQL:
SELECT column from table
ORDER BY RAND()
LIMIT 1
PostgreSQL:
SELECT column from table
ORDER BY RANDOM()
LIMIT 1
Microsoft SQL Server:
SELECT TOP 1 column from table
ORDER BY NEWID()
IBM DB2
SELECT column, RAND() as IDX
from table
ORDER BY IDX FETCH FIRST 1 ROWS ONLY
Thanks Tim
Oracle:
SELECT column from
( SELECT column from table
ORDER BY dbms_random.value )
WHERE rownum = 1
Thanks Mark Murphy
Feel free to post other example, variations, and SQL statements for other database servers in the comments. ......

MySQL:
SELECT column from table
ORDER BY RAND()
LIMIT 1
PostgreSQL:
SELECT column from table
ORDER BY RANDOM()
LIMIT 1
Microsoft SQL Server:
SELECT TOP 1 column from table
ORDER BY NEWID()
IBM DB2
SELECT column, RAND() as IDX
from table
ORDER BY IDX FETCH FIRST 1 ROWS ONLY
Thanks Tim
Oracle:
SELECT column from
( SELECT column from table
ORDER BY dbms_random.value )
WHERE rownum = 1
Thanks Mark Murphy
Feel free to post other example, variations, and SQL statements for other database servers in the comments. ......

MySQL:
SELECT column from table
ORDER BY RAND()
LIMIT 1
PostgreSQL:
SELECT column from table
ORDER BY RANDOM()
LIMIT 1
Microsoft SQL Server:
SELECT TOP 1 column from table
ORDER BY NEWID()
IBM DB2
SELECT column, RAND() as IDX
from table
ORDER BY IDX FETCH FIRST 1 ROWS ONLY
Thanks Tim
Oracle:
SELECT column from
( SELECT column from table
ORDER BY dbms_random.value )
WHERE rownum = 1
Thanks Mark Murphy
Feel free to post other example, variations, and SQL statements for other database servers in the comments. ......

//test.java
import java.io.BufferedOutputStream;
import java.io.DataOutputStream;
import java.io.FileOutputStream;
import java.io.IOException;
import java.io.InputStream;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
public class test {
 
 public static  void   main (String [] arge){
  try {
   Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver").newInstance();
   String url="jdbc:microsoft:sqlserver://127.0.0.1:1433;DatabaseName=TableName", user="username",
   password="password";
   Connection conn= DriverManager.getConnection(url,user,password);
   Statement stmt = conn.createStatement();
   ResultSet rs;
   String strSql  = "select name,photo from patient where name='name";
   InputStream &nbs ......

SQL Server 2005数据库备份和恢复特性
 
SQL Server 2000中存在的许多的备份和恢复特性都同样保留在了SQL Server 2005中，但是有一些新的提高同样值得我们关注。
镜像备份
SQL Server 2005让你可以创建镜像备份。镜像备份允许你为备份文件创建两个或者四个同样的拷贝，以防备其中的某一个集合损坏的情况。镜像具有同样的内容，所以你可以在某个文件被损坏的时候修复这个文件。
假设你有镜像集合1和镜像集合2，两个集合都有完全的备份和事务日志备份。如果镜像集合1的完全备份发生了损坏，你可以通过镜像集合2来进行恢复，然后对镜像集合1持续使用事务日志备份。
在线恢复
你还可以进行在线恢复，但是，不要太激动。从名字上看，似乎是你可以在恢复的同时，完全保持数据库启动、运行和保证用户登录到数据库中——但是实际情况不是的。在线恢复允许你在保持数据库在线的情况下恢复一个离线的文件组。所以你可以保障数据库的大部分在工作，但是你想要恢复的文件组必须是离线的。
注意:要运行这个特性，你必须使用SQL Server 2005企业版，并且主要的文件组不能是离线的。另外，你必须确保你的应用程序你可以使文件组离线，并且仍然可以起作用。通过仔 ......

SQL Server 2008 Administration Instant Reference

SQL Server 2005 数据库基础与应用技术

Microsoft SQLServer 2005 Integration Services Step by Step

SQLServer 2005 Bible

SQL Server 2005 数据库服务架构设计(Exam70-443)

SQL Server 2005 数据库实现与维护(Exam70-431)

A Developer's Guide to SQLServer 2005

Administrators Guide to SQLServer 2005

Professional SQLServer 2005 Integration Services

Sams Teach Yourself Microsoft SQLServer 2005 Express in 24 Hours

SqlServer 2005 Implementation And Maintenance(Exam70-431)

SQL Server 2000编程员指南

......