34,593
社区成员
发帖
与我相关
我的任务
分享
select datepart(month,getdate())
-----------
无列名
12
declare @TestChar varchar(50)
set @TestChar = 'the world is beautiful!'
select Left(@TestChar,5)
------------------
无列名
the
declare @TestChar varchar(50)
set @TestChar = 'the world is beautiful!'
select charindex('world',@TestChar)
----------------
无列名
7
declare @TestChar varchar(50)
set @TestChar = 'the world is beautiful!'
select upper(@TestChar)
-----------------
无列名
THE WORLD IS BEAUTIFUL!