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

Hadoop环境搭建

Hadoop环境搭建本文是采用VMwhere虚拟机进行搭建。用的ubuntn的linu系统主要是系统小好下载省事，还有许多搭建过程的链接，保证一看就会!

SQL脚本导入Excel

SQL脚本导入Excel

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); } }