How is easy to work with JSON in SQL SERVER 2016 ?
If you are a developer then surely you might have used JSON (JavaScript Object Notation) but, if not then don’t...
2017-03-28
1,518 reads
If you are a developer then surely you might have used JSON (JavaScript Object Notation) but, if not then don’t...
2017-03-28
1,518 reads
To understand RLS (ROW LEVEL SECURITY) let’s understand the different problems first.Problem 1 Suppose, you have a Multi-tenant e-commerce website...
2017-03-27
949 reads
Data security is always one of the important points which can not be ignored. Nowadays if you are working for...
2016-11-27
890 reads
In the series of SQL SERVER 2016, this is a new post. in this post, we will discuss DATEDIFF_BIG and...
2016-10-22
801 reads
In the Series of SQL SERVER 2016, this is another post. Before Jumping in detail just think if you have...
2016-10-22
929 reads
This is another article in the series of SQL SERVER 2016 Journey . I am pretty much sure you might aware...
2016-10-16
1,502 reads
In the Series of SQL SERVER 2016 journey, this is our new article. In this article, we are sharing a...
2016-10-15
1,108 reads
Although, I know I am bit late to share this thing on our blog but it says in Indian proverb...
2016-10-11
661 reads
2016-03-29
481 reads
This is one the articles in the series of step by step SSIS tutorial. In this post, we are going...
2015-12-20
824 reads
By DataOnWheels
Hey data friends! This one comes from my personal vault (aka backlog of drafts...
Data's the new oil, and SQL is your refinery. It's still the go-to language...
You can’t just exec DROP ROLE your_role_name; if it’s granted perms or other roles...
Comments posted to this topic are about the item Why you should avoid Implicit...
Comments posted to this topic are about the item Creating a Linked Server in...
Comments posted to this topic are about the item Dates and Languages
The string, listopad, translates to a month name in different languages. If I were to run this code, what values are returned?
DECLARE @yourInputDate NVARCHAR(32) = '28 listopad 2018'; SET LANGUAGE Polish; SELECT CONVERT(DATE, @yourInputDate) AS [SL_Polish]; SET LANGUAGE Croatian; SELECT CONVERT(DATE, @yourInputDate) AS [SL_Croatian]; SET LANGUAGE English;See possible answers