DevSocial Blogs · SQL Server blogs

JSON stands for JavaScript Object Notation. JSON is a lightweight format which is used for storing and interchange the data. JSON uses standard javascript function to convert JSON data into native javascript objects. The main purpose of using FOR JSON is used to create new JSON objects.

Kapil Singh KumawatJul 19, 201811,578250

Do a small change on database and on your query to make it faster.

Jefferson S. MottaJul 19, 201816,507250

Stuff is a function in SQL Server used to perform special operations on a string value.

Karthikeyan SekarJul 18, 20187,370250

In Single Procedure, we will write multiple SQL operations. Based on the request the corresponding SQL operations will execute.

Do you know the type of views ,how to create them and their uses. In this blog I will tell you about views , how you can use them practically. Before that I want to tell you that this is my third blog on Learn Oracle pl/sql if you have not read earlier blog on VARIABLES & tABLES kindly read them.

Prashant GoswamiJun 21, 20186,196250

Ranking functions returns a ranking value for each row either in a partition, or not. We can produce the very same result for all functions, but they have different purpose.

Jignesh KumarJun 20, 2018147,562250

In this post, we will learn about how to get all tables records count from the selected database. Here we are using sys.objects and sys.partitions for getting the record count. Here we are using join sys.objects with sys.partitions from sys.partitions we can get row count of table and sys.objects will return the name of a schema (table name).

Hardik DeshaniJun 6, 2018292,211250

Transfer database from SQL Server 2008 to 2014 using different migration techniques with the help of this article.

Andrew JacksonJun 6, 201837,194250

In this blog we will discuss how to remove duplicate record from a table using CTE. Without using TOP, MAX. There is a table name Employee and three columns like EmpId, EmpName, Salary.

Sanjib BarikJun 6, 20187,944250

This article explains how to implement simultaneous data queue processing using SQL Server. In many of our enterprise applications, we have the design to handle incoming request coming from multiple sources by putting them into the queue (MSMQ or SQL Server table) and then processing those stored requests from SQL table by multiple app engines simultaneously running the in-app farm.

Jeeva SubburajMay 24, 201815,017250

In this blog, I will demonstrate how to find the highest number of employees in a particular department using SQL server 2014.

Farhan AhmedMay 1, 201886,920250

This blog shows some primary issue which puts a serious limitation on SQL Server MONEY data type.

Bohdan StupakMay 1, 20185,870250

In this blog, we will discuss the way to submit the data of a model list to SQL Server to save all records of the list at once. We can do this by converting the model list to XML and then that XML can be submitted to SQL Server through Store Procedure. We can read the XML in SQL Server to use the data for SQL queries. I hope this will be helpful in the situations where we need to save multiple records of same entity or model by looping the list.

Ruchi SharavatMay 1, 201819,998250

In this blog, we are going to learn how to get a stored procedure encrypted.

Farhan AhmedApr 11, 20188,505250

I had a SSAS Tabular Model project and I had few developers making changes on the fly without telling me. My biggest problem was I couldn't track the changes and my client had lots of requirements that I needed to design and provide.

Shahriar NikkhahApr 10, 201811,812250

It's been a long time and I see that everyone is still using old SSIS packages from 2005 up to 2012, but I generally don't see new techniques or approaches being used. So, I decided to write a blog about it.

Shahriar NikkhahApr 10, 20186,332250

In this article, I’ll explain how to insert data from XML Sheets using SQL server.

Nikunj SatasiyaMar 24, 2018103,952250

Today, I am going to share some useful and tricky SQL queries that have helped me a lot.

Harinder KumarMar 12, 20187,748250

Often as a developer, we come upon a situation where we want to store some intermediate results temporarily. So in such cases, Sql Server provides us with a feature called temporary tables which can be created in run time and used to store the data temporarily.

A scenario-based SQL interview queries with the schema which is equally meaningful for new students as training material.

Israr AliMar 7, 2018104,436250

I consider myself fairly good at SQL Server but couldn't answer a question.

Nitin SontakkeFeb 26, 20187,625250

In this post, we will be discussing an alternative to using a SQL “IN” condition, where many values need to be parsed to the SQL query through the use of a User Defined Data Type to get exact records back based on a list of ID's.

Surinder BhomraFeb 20, 201868,899250

The word “Manipulation” means to play with the data, not only retrieve or fetch the data. We can include retrieve, store, modify, delete, insert, update and copy operations in DML.

Dharmraj ThakurFeb 15, 201826,756250

Today, I am going to discuss about retrieving the records based on the values in a specific column in SQL database using "IN CLAUSE".