![](https://img-blog.csdnimg.cn/20201014180756925.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
数据库
Janyue
这个作者很懒,什么都没留下…
展开
-
sqlserver中的函数(积累中)
系统函数:select suser_sname() --当前登录人select suser_sid() --ID常用函数:select len(你好啊),substring(你好a,1,2),ascii(啊)--返回 3 你好 176 select ch原创 2008-05-15 15:56:00 · 555 阅读 · 0 评论 -
sqlserver游标体验
if exists (select * from dbo.sysobjects where id = object_id([dbo].[TableSpace]) and OBJECTPROPERTY(id, IsUserTable) = 1)drop table [dbo].[TableSpace]gocreate table TableSpace( TableName varchar(原创 2008-05-13 18:48:00 · 484 阅读 · 0 评论 -
Sql + rollup + cube
--临时表创建create table #t(a int,b int,c int,d int,e int)insert into #t values(1,2,3,4,5)insert into #t values(1,2,3,4,6)insert into #t values(1,2,3,4,7)insert into #t values(1,2,3,4,8)insert转载 2008-06-06 10:55:00 · 625 阅读 · 0 评论