- 博客(0)
- 资源 (4)
- 收藏
- 关注
SQL 获取字符串中大写字母或小写字母
if exists(select * from sys.objects where name='GetUpper')
drop function dbo.GetUpper
go
CREATE function GetUpper(@words varchar(16))
returns varchar(8000)
as
begin
DECLARE @s VARCHAR(MAX)= @words --待截取字符串
DECLARE @temp VARCHAR(MAX)='' --临时变量
SELECT @temp=@temp+SUBSTRING(ch, sv.number, 1)
FROM (SELECT @s AS ch) t
CROSS APPLY [master].dbo.spt_values AS sv
WHERE sv.type = 'P'
AND sv.number BETWEEN 1 AND LEN(ch)
AND ASCII(SUBSTRING(ch, sv.number, 1)) BETWEEN ASCII('A') AND ASCII('Z')
return @temp
end
go
2019-05-04
C# Program PPT
定义一个Person类
using System;
public class Person
{
private string name;
private int age;
private long ID;
public Person(string n, int a, long i)
{
name = n;
age = a;
ID = i;
}
public virtual void Display()
{
Console.WriteLine(“Name : {0}” , name);
Console.WriteLine(“Age : {0}” , age);
Console.WriteLine(“ID : {0}” , ID);
}
}
2014-08-18
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人