数据库
yicha
这个作者很懒,什么都没留下…
展开
-
Ip截取
CREATE function getIp3 (@ip varchar(300),@count int ) RETURNS varchar(255) AS BEGIN declare @Index int declare @Part varchar(6) select @Inde...2009-08-13 14:32:16 · 148 阅读 · 0 评论 -
sql
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...原创 2010-07-07 13:52:55 · 95 阅读 · 0 评论 -
sql
declare @tablename varchar(100) declare @sql nvarchar(4000) declare @Num int declare tb_cursor scroll cursor for select name from sysobjects where xty...原创 2010-07-07 13:53:32 · 91 阅读 · 0 评论 -
sql2
create table #tableNames(TableName varchar(255)) create table #aaa (num int ) declare @n int declare @dataTable varchar(255) insert into #tableNames(TableName) select...原创 2010-07-07 13:54:12 · 121 阅读 · 0 评论 -
drop
[code="java"] declare @n int declare @name varchar(255) declare @sql varchar(255) begin create table #tablename(name varchar(255)) insert into #tablename select name from tempdb..sysobjects ...原创 2010-06-30 11:41:57 · 184 阅读 · 0 评论 -
n-m
取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 ...原创 2010-06-30 11:44:16 · 136 阅读 · 0 评论 -
sqlserver查看表是否有数据
declare @tablename varchar(100) declare @sql nvarchar(4000) declare @Num int declare tb_cursor scroll cursor for select name from sysobjects where xty...原创 2010-06-30 11:49:29 · 442 阅读 · 0 评论 -
sybase查看表是否有数据
create table #tableNames(TableName varchar(255)) create table #aaa (num int ) declare @n int declare @dataTable varchar(255) insert into #tableNames(TableName) select...原创 2010-06-30 11:50:10 · 506 阅读 · 0 评论