5:17
Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.
0 Comments
Suggested Videos
| Title | Views | Activity |
|---|---|---|
| Dealing with Dates: Data Types and String Conversions (SQL Server) | 318 | |
| SQL - Creating a Table | 127 | |
| Query data with no SQL code (1) | 44 | |
| Query data with no SQL code (9) | 16 |
Data can be kept in different media, Sometimes, the data need to be extracted, transformed or loaded in different ways.
For this article, I'm going to demonstrate some of the popular ways of importing JSON data into MS SQL Server.
- Node.js
- Powershell
- Java
- C#
- PHP
- Microsoft SQL Server, Python, JSON, Golang, SSIS
With the introduction of AlwaysOn Availability Group (AAG) in SQL Server 2012, log shipping seems to be less widely used than before. AlwaysOn Availability Group provides real-time log shipping as transactions are committed/applied to the primary da…
