https://blog.youkuaiyun.com/newforestskyzh-cnhttps://blog.youkuaiyun.com/https://blog.youkuaiyun.com/newforestsky/article/details/85123552https://blog.youkuaiyun.com/newforestsky/article/details/85123552newforestskyThu, 20 Dec 2018 15:35:37 +0800https://blog.youkuaiyun.com/newforestsky/article/details/6914242https://blog.youkuaiyun.com/newforestsky/article/details/6914242newforestskyFri, 28 Oct 2011 14:04:03 +0800https://blog.youkuaiyun.com/newforestsky/article/details/6158837https://blog.youkuaiyun.com/newforestsky/article/details/6158837newforestskySat, 22 Jan 2011 17:56:00 +0800https://blog.youkuaiyun.com/newforestsky/article/details/6124351https://blog.youkuaiyun.com/newforestsky/article/details/6124351newforestskySat, 08 Jan 2011 16:56:00 +0800   这几天学习一下《Microsoft+SQL+Server+2005技术内幕：T-SQL查询》一书，突然看到top with ties ，以前都是用top来取查询结果集排序后去前几条记录，查了一下资料，原来它的用法如下。
   WITH TIES 指定从基本结果集中返回额外的行，对于 ORDER BY 列中指定的排序方式参数，这些额外的返回行的该参数值与 TOP n (PERCENT) 行中的最后一行的该参数值相同。只能在 SELECT 语句中且只有在指定了 ORDER BY 子句]]>https://blog.youkuaiyun.com/newforestsky/article/details/6092296https://blog.youkuaiyun.com/newforestsky/article/details/6092296newforestskyWed, 22 Dec 2010 17:34:00 +0800
declare @t varchar(255),@c varchar(255)
declare table_cursor cursor for select a.name,b.name
from sysobjects a,syscolumns b ,systypes c
where a.id=b.id and a.xtype='u' and c.name
in ('char', 'nchar', 'nvarchar', 'va]]>https://blog.youkuaiyun.com/newforestsky/article/details/5894892https://blog.youkuaiyun.com/newforestsky/article/details/5894892newforestskySun, 19 Sep 2010 16:25:00 +0800--先向表中插入数据.
insert into dbo.EmployerInfo(name,age,sex) values('孔新林',25,'男')
insert into dbo.EmployerInfo(name,age,sex) values('孔新林',25,'男')
insert into dbo.EmployerInfo(name,age,sex) values('董永',25,'男')
insert into dbo.EmployerInf]]>