一：SqlServer中的 CEILING函数和 FLOOR函数以及ROUND() - LUCKY-y一：SqlServer中的 CEILING函数和 FLOOR函数以及ROUND() - LUCKY-y
例如
1.ROUND() 格式为ROUND(y1,y2,y3)
y1：要被四舍五入的数字 y2：保留的小数位数
y3：为0，可以不写,y1进行四舍五入，不为0则y1不进入四舍五入，如果y1有值就直接根据y2保留小数
SELECT ROUND(10.45,0)&nb...[2018/12/18]
SQLServer之创建Transact-SQL游标SQLServer之创建Transact-SQL游标
什么是游标
结果集，结果集就是select查询之后返回的所有行数据的集合。
游标则是处理结果集的一种机制吧，它可以定位到结果集中的某一行，多数据进行读写，也可以移动游标定位到你所需要的行中进行操作数据。
一般复杂的存储过程，都会有游标的出现，他的用处主要有：
定位到结果集中的某一行。
对当前...[2018/12/18]
Failure sending mail: The user or group name 'xxx\xxxx' is not recognized.Mail will not be resent
一批Reporting Service报表的订阅突然报如下错误： Failure sending mail: The user or group name ''xxx\xxxx'' is not recognized.Mail will not be resent...[2018/12/17]
Failure sending mail: The user or group name 'xxx\xxxx' is not recognized.Mail will not be resent
一批Reporting Service报表的订阅突然报如下错误： Failure sending mail: The user or group name ''xxx\xxxx'' is not recognized.Mail will not be resent...[2018/12/17]
Failure sending mail: The user or group name 'xxx\xxxx' is not recognized.Mail will not be resent
一批Reporting Service报表的订阅突然报如下错误： Failure sending mail: The user or group name ''xxx\xxxx'' is not recognized.Mail will not be resent...[2018/12/17]
Failure sending mail: The user or group name 'xxx\xxxx' is not recognized.Mail will not be resent
一批Reporting Service报表的订阅突然报如下错误： Failure sending mail: The user or group name ''xxx\xxxx'' is not recognized.Mail will not be resent...[2018/12/17]
SqlServer如何给表添加新的字段以及字段注释
语法：
USE 数据库名 ALTER TABLE 表名 ADD 字段名 类型 默认值 是否为空; EXEC sp_addextendedproperty N''MS_Description'', N''注释内容'', ...[2018/12/17]
SQLServer之ISO游标使用
什么是游标
结果集，结果集就是select查询之后返回的所有行数据的集合。
游标则是处理结果集的一种机制吧，它可以定位到结果集中的某一行，多数据进行读写，也可以移动游标定位到你所需要的行中进行操作数据。
一般复杂的存储过程，都会有游标的出现，他的用处主要有：
定位到结果集中的某一行。
对当前...[2018/12/17]
Failure sending mail: The user or group name 'xxx\xxxx' is not recognized.Mail will not be resent
一批Reporting Service报表的订阅突然报如下错误： Failure sending mail: The user or group name ''xxx\xxxx'' is not recognized.Mail will not be resent...[2018/12/17]
Failure sending mail: The user or group name 'xxx\xxxx' is not recognized.Mail will not be resent
一批Reporting Service报表的订阅突然报如下错误： Failure sending mail: The user or group name ''xxx\xxxx'' is not recognized.Mail will not be resent...[2018/12/17]
Failure sending mail: The user or group name 'xxx\xxxx' is not recognized.Mail will not be resent
一批Reporting Service报表的订阅突然报如下错误： Failure sending mail: The user or group name ''xxx\xxxx'' is not recognized.Mail will not be resent...[2018/12/17]
Failure sending mail: The user or group name 'xxx\xxxx' is not recognized.Mail will not be resent
一批Reporting Service报表的订阅突然报如下错误： Failure sending mail: The user or group name ''xxx\xxxx'' is not recognized.Mail will not be resent...[2018/12/17]
Failure sending mail: The user or group name 'xxx\xxxx' is not recognized.Mail will not be resent
一批Reporting Service报表的订阅突然报如下错误： Failure sending mail: The user or group name ''xxx\xxxx'' is not recognized.Mail will not be resent...[2018/12/17]
Failure sending mail: The user or group name 'xxx\xxxx' is not recognized.Mail will not be resent
一批Reporting Service报表的订阅突然报如下错误： Failure sending mail: The user or group name ''xxx\xxxx'' is not recognized.Mail will not be resent...[2018/12/17]
Failure sending mail: The user or group name 'xxx\xxxx' is not recognized.Mail will not be resent
一批Reporting Service报表的订阅突然报如下错误： Failure sending mail: The user or group name ''xxx\xxxx'' is not recognized.Mail will not be resent...[2018/12/17]
sql语句修改字段类型和增加字段
1 /*修改字段类型*/
2 alter table 表名 ALTER COLUMN 列名 nvarchar(500)
3 go
4 /*增加字段和说明*/
5 alter table 表名 add 列名 nvarchar(50)
6 EXECUTE sp_addextendedproper...[2018/12/17]
[SQL Server] 时间处理:获取今天的00:00:00/获取今天的23:59:59
获取今天的00:00:00
SELECT CONVERT(DATETIME,CONVERT(VARCHAR(10),GETDATE(),120))
获取今天的23:59:59
1、SELECT DATEADD(SS,-1,DATEADD(DD,1,CONVERT(DATE...[2018/12/17]
SQLServer之多表联合查询
多表联合查询简介
定义：连接查询是关系型数据库最主要的查询，通过连接运算符可以实现多个表连接数据查询。
分类：内连接，外连接，全外连接。
内连接
定义
内联接使用比较运算符根据每个表的通用列中的值匹配两个表中的行。
语法
select 表1.*,表2.* from 表1 as a [wtih...[2018/12/17]
Failure sending mail: The user or group name 'xxx\xxxx' is not recognized.Mail will not be resent
一批Reporting Service报表的订阅突然报如下错误： Failure sending mail: The user or group name ''xxx\xxxx'' is not recognized.Mail will not be resent...[2018/12/14]
Failure sending mail: The user or group name 'xxx\xxxx' is not recognized.Mail will not be resent
一批Reporting Service报表的订阅突然报如下错误： Failure sending mail: The user or group name ''xxx\xxxx'' is not recognized.Mail will not be resent...[2018/12/14]
Failure sending mail: The user or group name 'xxx\xxxx' is not recognized.Mail will not be resent
一批Reporting Service报表的订阅突然报如下错误： Failure sending mail: The user or group name ''xxx\xxxx'' is not recognized.Mail will not be resent...[2018/12/14]
Failure sending mail: The user or group name 'xxx\xxxx' is not recognized.Mail will not be resent
一批Reporting Service报表的订阅突然报如下错误： Failure sending mail: The user or group name ''xxx\xxxx'' is not recognized.Mail will not be resent...[2018/12/14]
SQL Server系统表sysobjects介绍
SQL Server系统表sysobjects介绍
sysobjects 表结构：
列名
数据类型
描述
name
sysname
对象名,常用列
id
int
对象标识号
xtype
char(2)
对象类型。常用列。xtype可以是下列对象类型中的一...[2018/12/14]
SQLServer之创建数据库快照
创建数据库快照注意事项
语法：set transaction isolation level snapshot;
指定事务中任何语句读取的数据都将是在事务开始时便存在的数据的事务上一致的版本。 事务只能识别在其开始之前提交的数据修改。 在当前事务中执行的语句将看不到在当前事务...[2018/12/14]
SQLServer之创建事务序列化
创建事务序列化注意事项
语法：set transaction isolation level serialize;
序列化会指定下列内容：
语句不能读取已由其他事务修改但尚未提交的数据。
任何其他事务都不能在当前事务完成之前修改由当前事务读取的数据。
在当前事务完成之前，其他...[2018/12/14]
Failure sending mail: The user or group name 'xxx\xxxx' is not recognized.Mail will not be resent
一批Reporting Service报表的订阅突然报如下错误： Failure sending mail: The user or group name ''xxx\xxxx'' is not recognized.Mail will not be resent...[2018/12/13]
Failure sending mail: The user or group name 'xxx\xxxx' is not recognized.Mail will not be resent
一批Reporting Service报表的订阅突然报如下错误： Failure sending mail: The user or group name ''xxx\xxxx'' is not recognized.Mail will not be resent...[2018/12/13]
Failure sending mail: The user or group name 'xxx\xxxx' is not recognized.Mail will not be resent
一批Reporting Service报表的订阅突然报如下错误： Failure sending mail: The user or group name ''xxx\xxxx'' is not recognized.Mail will not be resent...[2018/12/12]
Failure sending mail: The user or group name 'xxx\xxxx' is not recognized.Mail will not be resent
一批Reporting Service报表的订阅突然报如下错误： Failure sending mail: The user or group name ''xxx\xxxx'' is not recognized.Mail will not be resent...[2018/12/12]
Failure sending mail: The user or group name 'xxx\xxxx' is not recognized.Mail will not be resent
一批Reporting Service报表的订阅突然报如下错误： Failure sending mail: The user or group name ''xxx\xxxx'' is not recognized.Mail will not be resent...[2018/12/12]
Failure sending mail: The user or group name 'xxx\xxxx' is not recognized.Mail will not be resent
一批Reporting Service报表的订阅突然报如下错误： Failure sending mail: The user or group name ''xxx\xxxx'' is not recognized.Mail will not be resent...[2018/12/12]
Failure sending mail: The user or group name 'xxx\xxxx' is not recognized.Mail will not be resent
一批Reporting Service报表的订阅突然报如下错误： Failure sending mail: The user or group name ''xxx\xxxx'' is not recognized.Mail will not be resent...[2018/12/12]
Failure sending mail: The user or group name 'xxx\xxxx' is not recognized.Mail will not be resent
一批Reporting Service报表的订阅突然报如下错误： Failure sending mail: The user or group name ''xxx\xxxx'' is not recognized.Mail will not be resent...[2018/12/12]
Failure sending mail: The user or group name 'xxx\xxxx' is not recognized.Mail will not be resent
一批Reporting Service报表的订阅突然报如下错误： Failure sending mail: The user or group name ''xxx\xxxx'' is not recognized.Mail will not be resent...[2018/12/12]
Failure sending mail: The user or group name 'xxx\xxxx' is not recognized.Mail will not be resent
一批Reporting Service报表的订阅突然报如下错误： Failure sending mail: The user or group name ''xxx\xxxx'' is not recognized.Mail will not be resent...[2018/12/12]
Failure sending mail: The user or group name 'xxx\xxxx' is not recognized.Mail will not be resent
一批Reporting Service报表的订阅突然报如下错误： Failure sending mail: The user or group name ''xxx\xxxx'' is not recognized.Mail will not be resent...[2018/12/12]
Failure sending mail: The user or group name 'xxx\xxxx' is not recognized.Mail will not be resent
一批Reporting Service报表的订阅突然报如下错误： Failure sending mail: The user or group name ''xxx\xxxx'' is not recognized.Mail will not be resent...[2018/12/12]
Failure sending mail: The user or group name 'xxx\xxxx' is not recognized.Mail will not be resent
一批Reporting Service报表的订阅突然报如下错误： Failure sending mail: The user or group name ''xxx\xxxx'' is not recognized.Mail will not be resent...[2018/12/12]
Sql基础(零基础学数据库_SqlServer版)Sql基础(零基础学数据库_SqlServer版)
刚开始学C#时候的笔记,只是些基础的语句如有错误请批评指正,谢谢,(使用SqlServer2012以上)
一. 数据库概述 SQI全称 structrued Query Language
1、数据：能被计算机识别存储处理的符号的集合。包括：数字、符号、图片、声音、视频。 ...[2018/12/12]
SQLServer之创建不可重复读
创建不可重复读注意事项
语法：set transaction isolation level repeatable read。
指定语句不能读取已由其他事务修改但尚未提交的行，并且指定，其他任何事务都不能在当前事务完成之前修改由当前事务读取的数据。
对事务中的每个语句所读取的全部数据都设置了共...[2018/12/12]
浅谈SQL Server内部运行机制
对于已经很熟悉T-SQL的读者，或者对于较专业的DBA来说，逻辑的增删改查，或者较复杂的SQL语句，都是非常简单的，不存在任何挑战，不值得一提，那么，SQL的哪些方面是他们的挑战 或者软肋呢？
那就是sql优化。然而，要向成为一个好的Sq...[2018/12/12]
经验首页