Alvin 's Blog

Ms Sql 随机排序--作者：金建恩select * from [tablename] order by newid()

--Title:怎样让存储过程里对一个表 循环--Author: Alvin  (从http://dev.csdn.net/article/84/84029.shtm提取出来)--Date: 2006-4-17--Description: 怎样让存储过程里对一个表 循环--Environment: Sql2005--KeyWord: Sql2005  循环-- if exists (sel

drop table t1create table t1 ( id int, s1 int)Insert into t1 values(1,4)Insert into t1 values(2,5)Insert into t1 values(3,5)Insert into t1 values(4,4)Insert into t1 values(5,3)Insert into t1 values(

Create proc RegisterUser (@usrName varchar(30), @usrPasswd varchar(30),@age int, @PhoneNum varchar(20), @Address varchar(50) )asbegin//显示定义并开始一个事务begin traninsert into USER(userName,userPasswd) values