43 热度

存储过程——公用表表达式(CTE)

公用表表达式(Common Table Expression) 是SQL Server2005版本的引入的一个特性。CTE可以看组是一个临时的结果集,可以再接下来来的一个select,insert,update,delete,merge语句中多次引用。使用公用表达式CTE可以让语句更加清晰简练。

收录时间: 2020-05-16
分类: SQL Server
贡献者: Rector
93 热度

SQL Server数据库如何向一个已存在的数据表中添加带有默认值的列/字段呢?

在SQL Server数据库中,如何向一个已存在的数据表中添加带有默认值的列/字段呢?

收录时间: 2020-04-30
分类: SQL Server
贡献者: Rector
114 热度

SQL Server数据库如何将一个表的某个/某些字段的数据更新成另一个表的某个/某些字段的数据呢?

在SQL Server数据库中,需要根据一个表(表B)的某个或者某些字段的数据更新另一个表(表A)中某个或者某些字段的值,使用SQL脚本应该如何实现呢?

收录时间: 2020-04-29
分类: SQL Server
贡献者: Rector
65 热度

Deleting Lost Transactions in MS SQL Server (Part 2)

In the first part, we presented the general algorithm for deleting open transactions that are not completed from a SQL Server database and considered the process of creating a table to record incomplete transactions. Now, let’s look at the process of creating a CRUD stored procedure to find and delete active transactions in SQL Server.

收录时间: 2020-04-21
分类: SQL Server
贡献者: Rector
62 热度

SQL Agent Job Generator: Scheduling A Job

In this last entry in the initial series of posts on building a SQL Agent Job Generator, I am going to add the ability to schedule the jobs that we generated in the previous post. The code that is available here in github: https://github.com/drsqlgithub/SSISDeployTool/tree/e8c44505bba6b3c764531c8b489101b39b5c27a7, is likely sufficient for some smaller organization’s needs with jobs. (Future entries will handle triggering jobs, validating the Json, capturing performance history, Finding differences between Json and actual jobs. SSIS jobs and deployments. (the name of the github repository is SSISDeploy for a reason)), etc).

收录时间: 2020-04-18
分类: SQL Server
贡献者: Rector
67 热度

SQL Server数据库中如何使用SQL脚本快速生成一个数据表对应的C#实体类呢?

如题,在SQL Server数据库中,如何将数据库中定义好的一个数据表生成对应的C#实体对象呢?这里说的生成并不是指通过ORM(EF)等生成的方式,而是比ORM更直接的方式,应该如何操作呢?比如现在有...

收录时间: 2020-04-17
分类: SQL Server
贡献者: Rector
AD 友情赞助
181 热度

Improvements to machine learning capabilities in SQL Server 2019

Many organizations seek to do more with their data than pump out dashboards and reports. Applying advanced analytical approaches such as machine learning is an essential arena of knowledge for any data professional. While database administrators (DBAs) don’t necessarily have to become data scientists, they should have a deep understanding of the machine learning technologies at their disposal and how to use them in collaboration with other domain experts.

收录时间: 2019-12-18
分类: SQL Server
贡献者: Rector
143 热度

Tools and commands for running SQL Server 2019 on Linux

Organizations that embraced the option to run Microsoft SQL Server 2017 on Linux have been looking forward to the release of SQL Server 2019. Regardless of which operating system (OS) you choose, it’s the same SQL Server database code, and includes even more of the same features and services as the Windows release. This introductory blog post about running Microsoft SQL Server 2019 on Linux provides basic information database professionals need to know before upgrading or migrating SQL Server onto Linux.

收录时间: 2019-12-12
分类: SQL Server
贡献者: Rector
168 热度

What’s new with SQL Server 2019 Linux features

With SQL Server 2017, Microsoft entered the world of multi-OS platform support for SQL Server. For many technical professionals, the ability to run SQL Server on the same open source operating system as the rest of the application stack is not just a goal, but a dream that Microsoft made come true. With the release of SQL Server 2019, the inclusion of Linux now includes new features, support, and capabilities.

收录时间: 2019-12-05
分类: SQL Server
贡献者: Rector
258 热度

SQL Server Management Studio 18.4 and sqlpackage v18.4 generally available

Today we’re announcing the release of SQL Server Management Studio (SSMS) 18.4. This update has full support for SQL Server 2019 capabilities as well as some bug fixes. You can download SQL Server Management Studio 18.4 today and review SQL Server Management Studio release notes for details.

收录时间: 2019-11-06
分类: SQL Server
贡献者: Rector
216 热度

SQL Server 2019新功能披露:为企业带来改进的智能数据体验

SQL Server 2019 正式版的发布进度有些缓慢,微软先是在 8 月份推出了候选发布(RC),然后经过了一个多星期才推送了稍微更新后的版本。好消息是,在今日召开的 Ignite 2019 大会上,该公司终于谈论了 SQL Server 2019 的大量新功能,以帮助用户更有效地从不同格式 / 来源的数据中获得见解。

收录时间: 2019-11-05
分类: SQL Server
贡献者: Rector
158 热度

SQL Server 2019 is now generally available

As you saw from our launch announcementearlier today, over a year ago at Microsoft Ignite we announcedour first preview of SQL Server 2019 and today our latest releaseis now generally available.You have told us that in today’s demanding world of massive data, wide variety of data sources, and expect...

收录时间: 2019-11-05
分类: SQL Server
贡献者: Rector
263 热度

SQL Server Management Studio is as Relevant as Ever

SQL Server Management Studio is as Relevant as EverAfter fifteen years of heavy usage by developers and DBAs, it might seem like Microsoft’s free tool, SQL Server Management Studio, is about to go out of style. SSMS is no longer the cool new kid on the block: Microsoft has shown consistent effort to...

收录时间: 2019-09-26
分类: SQL Server
贡献者: Rector
334 热度

SQL Server Management Studio 18.3 is now generally available

Today we’re announcing the release of SQL Server Management Studio (SSMS) 18.3. For this update, while we added some features, our focus was primarily on fundamentals such as stability, reliability, and performance.

收录时间: 2019-09-24
分类: SQL Server
贡献者: Rector
351 热度

Understanding SQL Server Deadlocks

This is a continuation of a series of articles I've written on SQL Server concepts.When you work with SQL Server long enough on a database with enough traffic, you're eventually going to encounter deadlocks.This article discusses what deadlocks are, how to interpret deadlock graphs, and some options...

收录时间: 2019-09-13
分类: SQL Server
贡献者: Rector
AD 友情赞助
263 热度

Released: General Availability of Microsoft.Data.SqlClient 1.0

We have released for general availability Microsoft.Data.SqlClient 1.0. This .NET Data Provider for SQL Server provides general connectivity to the database and supports all the latest SQL Server features for applications targeting .NET Framework and .NET Core. To try out the new package, add a NuGet reference to Microsoft.Data.SqlClient in your application.

收录时间: 2019-08-30
分类: SQL Server
贡献者: Rector
288 热度

Release: SQL Server Migration Assistant (SSMA) v8.3

SQL Server Migration Assistant (SSMA) for Oracle, MySQL, SAP ASE (formerly SAP Sybase ASE), DB2, and Access allows users to convert a database schema to a Microsoft SQL Server schema, upload the schema, and then migrate data to the target SQL Server (see below for supported versions).

收录时间: 2019-07-31
分类: SQL Server
贡献者: Rector
343 热度

SQL Server Management Studio 18.2 is now generally available

We are excited to announce the release of SQL Server Management Studio (SSMS) 18.2. For this update, while we added some features, our focus was dedicated to fundamentals such as stability, reliability, performance, etc.

收录时间: 2019-07-28
分类: SQL Server
贡献者: Rector
290 热度

SQL Server 2019 community technology preview 3.2 is now available

We’re excited to announce the monthly release of SQL Server 2019 community technology preview (CTP) 3.2. With this release of SQL Server 2019 community technology preview 3.2, we are announcing the public preview of Big Data Clusters for SQL Server 2019. Big Data Clusters for SQL Server enables big data analytics within SQL Server. It brings HDFS and Apache Spark™ into SQL Server for scale out compute and storage....

收录时间: 2019-07-25
分类: SQL Server
贡献者: Rector
286 热度

SQL: Using CROSS APPLY to replace multi-column predicate look-ups in T-SQL

SQL: Using CROSS APPLY to replace multi-column predicate look-ups in T-SQL...

收录时间: 2019-07-23
分类: SQL Server
贡献者: Rector
AD 友情赞助