分页: 1/318 第一页11121314151617181920212223242526272829... 318下页最后页[ 显示模式: 摘要 | 列表 ]

Interesting Stuff - Week 9

[ 2017-03-09 05:13:01 | by 店小二05 ]
05 Mar 2017 in categories: roundup tags: data science SQL Server Microsoft R Se ...
Question:Why to Use SQL Server Configuration Manager Over Services applet (services.msc)? Answe ...
什么是PL/SQL?PLSQL语法游标存储过程/存储函数异常触发器。结构化查询语言(Struc ...
Sql语句如下USE goSET ansi_nulls ONgoSET quoted_identifier ONgoALTER PROCEDURE . @tb ...
SQL99是什么(1)是操作所有关系型数据库的规则(2)是第四代语言(3)是一种结构化查询语言(4)只需发出合 ...
SQLServer截取字符串数组,获取字符串指定值,截取字符串:例如 qweqe,1231423,werwer;qweqe,1231423,werwe ...
SQL Server 将JDE日期格式转换成常见日期格式JDE日期格式:JDE所有的日期字段在DB存储时用的是Julia date格 ...
SQL语言,是结构化查询语言(Structured Query Language)的简称。SQL语言是一种数据库查询和程序设计语言,用 ...
Today we’re going to talk about SQL Server instance stacking. Blasphemy!! Right, in product ...
This is one of the common question which is asked via emails to me. “How to apply the patch in Alwa ...

Friday Reading 2017-03-03

[ 2017-03-08 14:33:02 | by 店小二05 ]
I’m Andrew Pruski and I am a SQL Server DBA with 5 years experience in database development and adm ...

SQL Server 2016 Developer’s Guide

[ 2017-03-08 14:34:02 | by 店小二05 ]
I can proudly announce that it is already possible to preorder the SQL Server 2016 Developer’s Gui ...
Step 1. Run sp_Blitz and look for urgent warnings.sp_Blitz is one of the free scripts in our First ...

Blog Challenge: I am watching you!

[ 2017-03-07 21:25:01 | by 店小二04 ]
I decided to accept Grant’s (TheScaryDBA) challenge found here- http://www.scarydba.com/2017/03/02 ...
In this blog post we will discover how to fix an Add Failover Cluster Node Fails With Error. If you ...
Alex Kuznetsov wrote: Resilient T-SQL code is code that is designed to last, and to be safely ...
If you have ever tried to debug a program that used the TSql Script Dom to parse some T-SQL you will ...

Loading to Azure from On-Prem SSIS

[ 2017-03-07 08:20:01 | by 店小二03 ]
Tim Mitchell Tim Mitchell is a business intelligence consultant, author, trainer, and Microsof ...

SQL Server Backup and Restore Primer

[ 2017-03-07 08:21:01 | by 店小二04 ]
― by Lori Brown @SQLSupahStah Back it up!! …. BEEP! BEEP! BEEP! … Oh wait! Not that kind ...

SQL Server Permissions Database Roles

[ 2017-03-07 08:22:01 | by 店小二03 ]
EZ PZ Permission Squeezee Given the critical level of importance related to permissions, one m ...

Random Blog Post Challenge

[ 2017-03-07 08:24:01 | by 店小二04 ]
The Scary DBA I have twenty+ years experience in IT. That time was spent in technical support, ...
In this puzzle we’re going to learn how to find the person whose birthday, among others, is in the ...
1、创建表 CREATE TABLE SC(Sno int,Qno int,primary key(Sno),foreign key(Qno) references Course(Cno)); ...
SQL-一条SQL插入多条数据MySQL insert all into RAW_AMORT_SCHEDULE(BOND_CODE,AMORTIZE_DATE, ...
SQL-to_char()保留小数,千位分隔符SELECT to_char(999999999999.99, 'FM999,999,999,999,999.000') AS QTY_ ...
分页: 1/318 第一页11121314151617181920212223242526272829... 318下页最后页[ 显示模式: 摘要 | 列表 ]