yicha的博客

CREATE function getIp3 (@ip varchar(300),@count int ) RETURNS varchar(255) AS BEGIN declare @Index int declare @Part varchar(6) select @Inde...

create table A( stuName varchar(10), stuClass varchar(10), stuScroe float,)insert into A (stuName,stuClass,stuScroe)values('张三','数学',80)insert into A (stuName,stuClass,stuScro...

declare @tablename varchar(100) declare @sql nvarchar(4000) declare @Num int declare tb_cursor scroll cursor for select name from sysobjects where xty...

create table #tableNames(TableName varchar(255)) create table #aaa (num int ) declare @n int declare @dataTable varchar(255) insert into #tableNames(TableName) select...

[code="java"]declare @n intdeclare @name varchar(255)declare @sql varchar(255)begincreate table #tablename(name varchar(255))insert into #tablenameselect name from tempdb..sysobjects...

取n到m行1. select top m * from tablename where id not in (select top n id from tablename order by id asc/*|desc*/) 2. select top m * into 临时表(或表变量) from tablename order by columnname -- 将top ...

declare @tablename varchar(100) declare @sql nvarchar(4000) declare @Num int declare tb_cursor scroll cursor for select name from sysobjects where xty...

create table #tableNames(TableName varchar(255)) create table #aaa (num int ) declare @n int declare @dataTable varchar(255) insert into #tableNames(TableName) select...