SQL
暖暖爸爸
要想得到从没得到的,就要做从没做过的!
展开
-
SQLServer身份证号或手机号字段隐藏某几位显示
--身份证号隐藏11到14位REPLACE(B.SFZH,SUBSTRING(B.SFZH,11,4),'****') AS SFZH--手机号隐藏4到7位REPLACE(B.LXDH,SUBSTRING(B.LXDH,4,4),'****') AS LXDH原创 2021-04-16 23:38:16 · 1554 阅读 · 0 评论 -
通过身份证号获得年龄
if len(@idcard) = 15 OR len(@idcard) = 18 begin set @var1='' if LEN(@idcard)=15 begin set @var1 =SUBSTRING(@idcard,15,1) set @birthday='19' +SUBSTRING(@idcard,7,2)+'-' +SUBSTRING(@idcard,9,2) +'-' +SUBSTRING(@idcard,11,2) end else...原创 2020-11-25 09:34:26 · 145 阅读 · 0 评论 -
SELECT INTO 和 INSERT INTO SELECT 两种表复制语句
1.INSERT INTO SELECT语句语句形式为:Insert into Table2(field1,field2,...) select value1,value2,... from Table1要求目标表Table2必须存在,由于目标表Table2已经存在,所以我们除了插入源表Table1的字段外,还可以插入常量。示例如下:insert into t_test_bak(name) select name from t_test where id=1;2.S...原创 2020-10-13 12:25:57 · 299 阅读 · 0 评论 -
TSQL2012练习示例
TSQL2012数据库脚本下载链接:https://pan.baidu.com/s/1OkzZM8vJEL1hEsVUU1Jxhg1、查询表Sales.Orders,返回每月最后一天的订单use TSQL2012;select orderid,custid,empid,orderdatefrom Sales.Orderswhere MONTH(DATEADD(day,1,orde...原创 2020-01-07 15:54:03 · 474 阅读 · 0 评论 -
2单表查询
示例:use TSQL2012;select empid,YEAR(orderdate) as orderyear,COUNT(*) as numordersfrom Sales.Orderswhere custid=71group by empid,YEAR(orderdate)having count(*) >1order by empid,orderyear;1、...原创 2019-12-29 15:58:59 · 168 阅读 · 0 评论 -
1创建表和定义数据完整性
1、创建表use TSQL2012;if object_id('dbo.Employees','U') is not null drop table dbo.Employees;create table dbo.Employees( empid int not null, firstname varchar(30) not null, lastname varchar(30) ...原创 2019-12-29 08:14:53 · 461 阅读 · 0 评论 -
SQL语句类别
1、数据定义语言(Data Definition Language,DDL):用于处理对象的定义。CREATEALTERDROP2、数据操作语言(Data Manipulation Language,DML):用于查询和修改数据。SELECTINSERTUPDATEDELETETRUNCATEMERGE3、数据控制语言(Date Control Language,DCL):用...原创 2019-12-25 09:38:40 · 80 阅读 · 0 评论