sybase函数学习

作者:duketian 日期:2008-04-17 10:34:40

字体大小: 小中大

1. db_name 返回指定数据库的名称

它和db_id正好相反

例如：select db_name() 当前数据库的名称

Select db_name(4) ID为4的数据库的名称

2.floor 返回小于或等于指定值的最大整数

例如：select floor(123.24) 结果：123

Select floor(-123.24) 结果：-124

Select floor($123.45) 结果：123.00

注意：对于数字和小数表达式，其结果的精度与该表达式的精度相同，标度为0

3. getdate 返回当前系统日期和时间

例如：select getdate() 结果：当前日期，包括日期和时间

Select datepart(month,getdate()) 结果：12

Select datename(month,getdate()) 结果：December

4.host_id 返回当前Adaptive Server客户端机操作系统进程ID,

host_name 返回当前Adaptive Server客户端机操作系统进程名称

例如：select host_name(),host_id()

结果：ylzhang，1365

Ylzhang是计算机名，1365是Adaptive Server客户端进程的进程ID

5.identity_burn_max 跟踪给定表的identity burn最大值，此函数只返还只而不进行更新。

例如：select identity_burn_max(‘tablename’)

注意：返回的是自增列的最大ID，如果这个表没有自增列，则返回为null

6.index_col 返回指定表或视图中带索引的列的名称。

7.index_clolrder 返回列的顺序

8.isnull 当expression求值为null时，用expression中的值替代它。

例如：select isnull(name,’zhang’) from titles 结果：name列为null值的替换为zhang

9.is_sec_service_on 安全服务启用时返回1；否则返回0

is_sec_service_on(sevurity_service_nm)

其中：sevurity_service_nm是安全服务的名称。

查找安全服务的有效名称，用select * from syssecmechs

例如：select is_sec_service_on(“unifiedlogin”)

10.left 返回字符串最左侧指定数目的字符。

left(character_expression,integer_expression)

例如：select left(‘123456789’,5) 结果：12345

select left(‘123 456789’,5) 结果：123 4

返回名字的前5个字符，select left(name,5) from user

11.len 返回指定字符串表达式（不包括尾随空白）的字符数（而不是字节数）

len(string_expression)

例如：select len(‘中国’) 结果：2

注意： char_length，char，len之间的区别

12.lower 返回指定表达式的等值小写表达式（就是把大写字符变成小写）

例如：select lower(‘12FEC张’) 结果：12fec张

13．ltrim 返回指定的表达式，其中删去了前导空白。

例如：select ltrim(‘ aa’) 结果：aa

select ltrim(‘aa ’)+’cc’ 结果：aa cc

select ltrim(‘a a’) 结果： a a

注意：只删去了前导空白

14.max 和 min 返回列中最大值和最小值

例如：select max(price) from computer

select min(price) from computer

15.month 返回一个整数，该整数表示月份。

例如：select month(getdate()) 结果：12

同理: select day(getdate()) 结果：15

select year(getdate()) 结果：2006

16．mut_excl_roles 返回有关两个角色之间互斥性的信息。

mut_excl_roles是一个系统函数。如果系统安全员将role1定义为与role2互斥的角色，或直接有role2所包含的角色，则mut_excl_roles返回1，如果不是则返回0。

17.newid 根据提供的参数生成两种不同格式的、人工可读的全局唯一ID

Newid([optionflag])

例如：select newid()

select newid(0)

select newid(0x0)

select newid(1)

可以通过newid()来参数随机器数

Select id from tablename order by newid()

这时你会发现，每次执行，排序都不一样。

18. next_identity 检查下一个insert可用的下一个标识值。（就是下一个自增的ID）

Next_identity(tablename)

例如：select next_identity(‘tbl_zone’) 结果：返回tbl_zone表中下一个要自增的id

注意：如果这个表不是自增，则返回null

19.object_id 返回指定对象的对象ID，object_name是返回对象ID的对象名称。

Obeject_di(object_name)

object_name是数据库对象（表、视图、过程、触发器、缺省值或规则）的名称。

例如：select object_id(‘TBL_ZONE’) 结果：437573566

同样 select object_name(437573566) 结果：TBL_ZONE

注意：对象ID存储在sysobjects的ID列中。

平均得分

(0 次评分)

文章来自: cnblog

标签:

评论: 18 | 查看次数: 947

共有 18 条评论

游客 [2008-11-26 11:53:00]

婚庆
北京搬家
北京搬家公司
楼梯
绗缝机
拓展
拓展训练
保洁
保洁公司
脱发
脂溢性脱发
货架
Google排名
汽车网
亚克力
有机玻璃
写字楼

货架
翻译公司
北京翻译公司
礼品
木制展柜
网站设计
Google排名
网页设计
网站制作
保洁
保洁公司
货架
显示屏
Led显示屏
电子显示屏
婚庆
北京婚庆
婚庆公司
管道疏通
管理咨询
猎头
北京猎头
猎头公司
北京猎头公司
搬场公司
上海搬场公司
上海搬家公司
搬家公司
条码机
条码打印机
hfer

游客 [2008-11-25 13:49:53]

Nmljdf11 Eugene0811 国家明确医生教师吃回扣以受贿罪论处
brogame
wow gold
wow gold
wow power leveling
buy wow accounts
wow accounts
world of warcraft account
wow account
buy wow account
留学韩国
留学韩国
苏州朗阁
苏州朗阁
韩国留学
韩国留学
苏州留学
苏州留学
苏州留学中介
苏州留学中介
留学荷兰
留学荷兰
荷兰留学
荷兰留学
韩国留学
留学韩国
韩国留学
苏州留学中介
苏州留学中介
苏州朗阁
苏州朗阁
苏州留学
苏州留学
留学荷兰
留学荷兰
荷兰留学
荷兰留学
荷兰留学

游客 [2008-11-14 15:08:53]

EP1-OX1114
EP1-OXMAN
wow gold
wow power leveling
wowmine.com
brogame
brogame
oofay
oofay.com
oofay
隔膜泵
隔膜泵
隔膜泵
空调
空调
空调
螺杆泵
螺杆泵
螺杆泵
真空泵
真空泵
真空泵
留学新加坡
留学新加坡
留学新加坡
新加坡留学
新加坡留学
新加坡留学
上海水泵
上海水泵
上海水泵
上海新加坡留学中介
上海新加坡留学中介
上海新加坡留学中介
上海新加坡留学
上海新加坡留学
上海新加坡留学
上海水泵
留学新加坡
上海新加坡留学
空调
螺杆泵
真空泵
隔膜泵
新加坡留学
　

游客 [2008-11-14 14:11:00]

bprgcya
纸袋
切割折除
墙体切割
塑料袋
玻璃钢
纸袋
数据采集器
包装盒
弯管机
碳素
称重仪表
自由行
国旅

包装盒
塑料袋
混凝土静力直线切
hdpe波纹管
墙锯切割
钢筋混凝土切割
水钻排孔
效果图设计
北京塑料制品
pvc板
pvc管
英格索兰气动工具
液晶监视器
DID拼接墙
超声波探伤仪

澳洲旅游
海岛游
四合院
婚纱摄影
效果图
股骨头坏死
画册印刷
不干胶印刷
手提袋印刷
涂层测厚仪
粗糙度仪
超声波测厚仪
红外测温仪
粗糙度仪
红外测温仪
红外测温仪
变压吸附制氮机
变压吸附制氧机
超声波探伤仪
板材雕刻加工
板材雕刻切割
亚克力展示架
英达生态园
小汤山温泉度假村
昌平温泉度假村
超声波测厚仪
无线上网卡
卷板机
婚纱摄影
PDU
机柜插座
北京四合院
北京四合院
剪板机
折边机
铣边机
北京效果图
效果图制作
效果图公司
北京展览公司
东空气动工具
北京SEO
炭化木
深度炭化木
巴劳木地板
航空箱
航空箱
北京航空箱
航空箱
设备箱
分水器
线号机
打号机
展厅设计
科技馆设计
博物馆设计
规划展厅设计
北京展厅设计
企业展厅设计
涂层测厚仪
超声波测厚仪
变压吸附制氮机
变压吸附制氧机
出境游
北京印刷
有机玻璃加工
石墨

游客 [2008-11-14 02:21:46]

货架
翻译公司
北京翻译公司
婚庆
脱发
脂溢性脱发
楼梯
楼梯
亚克力
亚克力
有机玻璃
有机玻璃
Google排名
汽车网
北京搬家
北京搬家公司
拓展
拓展训练
保洁
保洁公司
写字楼
光盘制作
光盘印刷
光盘刻录

货架
礼品
保洁
保洁公司
搬场公司
上海搬场公司
上海搬家公司
搬家公司
货架
北京婚庆
婚庆公司
Led显示屏
电子显示屏
管道疏通
网站设计
Google排名
网页设计
网站制作
管理咨询
猎头
北京猎头
猎头公司
北京猎头公司
北京长途搬家
北京长途搬家公司
海淀搬家公司
中关村搬家公司
猎头公司
北京猎头公司
条码机
条码打印机
显示屏
Led显示屏
电子显示屏

游客 [2008-11-07 11:49:37]

cheap wow power leveling Beyond knowing your limitations. HDRO gold it's important to be able to size up opponents lecteur mp3 at a glance. level wow Knowing their class is the first step, understanding. lord of rings online gold your places in a rock-paper-scissors scenario. lotro gold More important, however, is the estimation .lotro gold of gear. mp3 As much as skill and class
balance . mp3 mp4 player plays a part in the outcome . mp3 mp4 player of combat, gear is a major differentiator that makes up for shortcomings in other areas. mp3 mp4 player In fact, with . mp3 player kaufen the introduction of Resilience, gear more than mp4 ever plays a more substantial part in PvP. power level In an Arena match, the very first thing we . power level scope out is gear. wow level Through quick tab-selection viewing .wow leveling of character portraits, we generally wow lvl have a good idea of the classes we're up against if they keep their helm graphic on. wow lvl If they are wearing Season 3 shoulders, then we know . wow lvl 60 their relative experience. wow lvl 70 This is why the visual i.wow power leveling mpact of Arena shoulders is so important.wow powerlevel It immediately gives you a general idea of how tough the match will be. wow powerlevel Players in full S3 will likely have over 10k hp and over. wow powerleveling 400 Resilience, depending on the class and spec. A full S3 SL/SL Warlock, for example, will easily have. about 12-13k hp and over 400 Resilience. Identifying weapons is slightly more . difficult but will also give a general idea of an enemy's strength. Season 1 and 2 weapons share the same graphics, so it's harder to identify. Season 3 weapons, on the other hand, are distinctive and share models with Black Temple and Mount Hyjal weapons. which 最新免费网络游戏 have relatively the same power. A review of Brutal Gladiator weapons will come in handy because these will be the most common way to identify opponents of relative skill. With the new mechanics. in place for Arenas, Season 4 will more or less weed out the chaff from the grain.

游客 [2008-11-07 11:44:41]

mp3 8GB MP3 PLAYER A couple of people . apple ipod have posted about the Shattered Sun Peacekeepers slacking off on their jobs lately. buy cheap wow gold quite possibly thanks . canon digital camera to something Blizzard fed them . cheap world of warcraft gold in PatchIn their reports, they complain about Peacekeepers. digital camera attacking them for no reason, sometimes not even in retaliation for attacking (or defending yourself against). digital cameras a member of the opposing faction. dvd player I can actually empathize with this as. eve isk I encountered the ill-placed wrath of the Peacekeepers myself when I rezzed my wife's toon in front of . ipod the Staging Area. ipod nano Without having done anything other. ipod shuffle than rezz, the Peacekeepers promptly charged . ipod touch and made short work of me. ipods In my experience, I have found 网游 that the Peacekeepers around . mp3 the Shattered Sun Staging Area have . mp3 player been slacking off. mp3 players In fact, my wife's toon was ganked right in front . mp4 of the building and the so-called Peacekeepers . portable dvd players did absolutely nothing. world of warcraft buy gold Sensing a bug, my wife . wow wrote a ticket and got a somewhat rude e-mail response saying that -- you guessed it -- it was working as intended. wow gold An Alliance . wow gold guild on my server seemed to be aware of the fact and exploited it to full effect, killing solo players who could seek no refuge under the apathetic -- or even hostile -- Peacekeepers. wow leveling According to reports, it's a known bug -- one player even . wow powerleveling made a video to document it -- but so far Blizzard . zubehoer mp3 player has turned a blind eye to it. I got a more sympathetic response 网络游戏 from my GM who at least. mentioned he'd look into the situation. An in-game GM even reset the Peacekeepers in order to see if it would change anything (it didn't). I don't mind gankage

4GB MP3 PLAYER My wife is a shrewd little fox. Bluetooth Headset She knows just how much I love the fact. Bluetooth Headsets that she plays the game with me so sometimes, when we have our little domestic arguments, she makes sure. cell phone accessories to cancel her WoW account just to drive home a point. des po wow Of course, it doesn't mean much since we're both paid up for the next few months, but the message is clear -- "we make up (or you see things my way). digital camcorder or I'm quitting the game!" Of course, we don't reconcile merely because I'll be losing my . digital camcorders favorite playing partner, but I have to confess that it doesn't make . dvd players me happy one bit. free online games For parents, World of Warcraft can be a . free online war games useful bargaining chip for their kids with the parental . gold wow controls feature. gold wow It's easy enough to control WoW time if kids aren't doing their homework, floundering in school, or simply not. mp3 mp4 player doing their chores. mp3 player Conversely, a friend . mp3 player accessories of mine gave his son a WoW subscription when . mp3 player accessory he did well in school. mp3 player kaufen World of Warcraft can be so. online games much fun and addicting that it's . play war games often used as a social tool, and it's often upsetting when our. po wow friends quit playing the game. portable dvd player How many of us have . wow europe had friends whose significant others have "allowed" them to. wow geld play the game after, say, a wonderful date. wow gold verkaufen I'm not sure if it only applies to me, but . wow level service because I play the game with many of my RL friends . wow leveling service and my family, I use the lure of WoW . to full effect. I once had my brother do a specific task for . the promise of an upgrade to The Burning Crusade. A little before he finished what I asked him to do, I secretly upgraded his account. so he could免费网络游戏 finally make his Blood Elf Priest. Kind of manipulative, I know, but we did end up having . a lot of fun leveling our alts together. How about you. How much a part of your life is WoW and has it .最新网游 ever been used as a bargaining . chip in your social life.

游客 [2008-11-07 11:44:25]

2GB MP3 PLAYER Remember the WoW account hacking. 4GB MP3 PLAYER If you're a WoW player. buy wow gold you couldn't have missed . buying gold world of warcraft any of the articles posting this issue. cell phones Well, as it turns out, an article posted by . phones cell grimwell says that someone might have found the problem behind all the . cheap cell phones account hacking, stealing and selling even 5 year's worth items. cheap wow gold A piece of the BBC news article says:"Analysis [. cheap wow gold cheap wow gold cheapest wow gold ] showed that. eve isk it lay dormant on a victims . mp3 players machine until . portable mp3 player they ran World of Warcraft (WoW) at which point it captured login data and sent it to. portable mp3 players the hacking group. sell wow gold The group's enthusiastic use of the cursor flaw suggests it is trying to . world of warcraft gold do the same again. wow The online fantasy game . wow gold now has more than eight million active players around the world. wow gold Research by security firm Symantec . wow gold suggests that the raw value of a WoW account is now higher. wow gold than a credit card and its associated verification data. wow gold "Normally, as a WoW player, you'd know about the risks involved when creating an online account, yet some were . wow gold lazy enough not to check on their accounts every once in a while, thus resulting in their items . wow gold kaufen and WoW currency being stolen. wow gold kaufen Everyone knows that . stuff like that happen, some. even managed to hack the Superbowl website and use it . to host code for spyware, so monitor the hell out of your computer!In an article I wrote yesterday. about hackers seeing 游戏 console users as the new target, there is a comment 魔兽 coming from Stefana Muller.

游客 [2008-11-05 13:39:48]