DevSocial Blogs · SQL Server blogs

In this blog you will learn how to Delete all Duplicate Rows or Records From SQL Table.

Shubham KumarMar 18, 2019164,340250

In this blog, you will learn about how to call a Web Service from SQL Server, using SQL stored procedure.

Jeevan WijerathnaMar 18, 2019165,383250

In this blog, I will explain how to call web services through a stored procedure in the SQL database.

Talaviya BhavdipMar 18, 2019173,707250

In this blog, we will learn how to check if a particular column of a table is updated or not. If the column updates, the current record inserts into a trigger table using the trigger.

Amit MohantyMar 15, 201922,770250

This blog explains the process of how to convert CSV values into row values and vice-versa, using in-built and custom SQL queries.

Kalyan KondapuramFeb 24, 2019136,336250

Sometimes, we may want to encrypt a SQL Server column data, such as a credit card number. In this blog, let's learn how we can encrypt and decrypt SQL Server column data in the database itself.

Dinesh GabhaneFeb 22, 2019151,689250

Here, I will be giving a brief introduction to Indexes in SQL Server and why we need the indexing.

Gajanan ChavhanFeb 8, 20196,919250

Date of Birth can be used to calculate the age in years, months, and days.

Kalyan KondapuramJan 25, 201943,637250

This blog is about temporary tables in SQL, their types, and differences between them.

Aniket NarvankarJan 22, 201937,621250

In this blog, I will explain how to improve the performance of your SQL query. As a developer, we know any SQL query can be written in multiple ways but we should follow the best practices/techniques to achieve better query performance.

Talaviya BhavdipJan 17, 201913,656250

In this blog, we will understand how we can find employees hired last month or year. We will understand DATEDIFF function in SQL server. The DATEDIFF function is used to calculate the difference between two dates.

Farhan AhmedJan 15, 2019155,625250

In this blog, we will understand how to join two or more SQL tables without using a foreign key. We will also get an overview of Join and Keys in SQL.

Farhan AhmedJan 7, 201996,838250

In this blog, we will understand the usage of ASCII function in SQL Server and find ASCII values of capital and small alphabets.

Farhan AhmedJan 7, 201973,868250

How to delete duplicate records from a SQL data table using CTE (common table expression). Specifies a temporary named result set, known as a common table expression (CTE).

Farhan AhmedJan 3, 2019254,874250

Learn about know forensic analysis of SQL Log

Andrew JacksonJan 3, 20199,545250

This article demonstrates how to create and use a scalar function in the SQL Server database. In this blog, we won't go very far. We will perform only basic functions.

Yogesh KumarDec 28, 201811,857250

Database Logs are used for any modification/transaction on table production or during development from their Database Server.

Imran MunirDec 19, 20186,615250

Many times we come across null values within tables in SQL Server. Null values are the values with no data; that means the data is missing or unknown. In this article, initially we will understand the SQL Server IsNull function, then we will move towards extending the IsNull functionality using Coalesce function.

Priyanka SinghNov 26, 201869,912250

Here, we will discuss the full procedure to rebuild Master Database in SQL Server without unavailability of backup. Read the complete blog very carefully to get appropriate results.

Abrienne JonethanNov 18, 201830,701250

In this blog, we will learn about aggregate function in SQL Server. An aggregate function is used to calculate the given values and returns a single value.

Sanwar RanwaNov 16, 20187,738250

In this article we learn about Date and time functions in SQL Server.These functions are working on given date and time.These functions are SQL Pre defined functions.

Sanwar RanwaNov 14, 201833,575250

In this blog, we will discuss how to work with Stored Procedure and explain the concept with an example in a simple way. I hope this is very useful for beginners and intermediate to help them understand the basic concept.

Jitendra WaghaleNov 12, 201818,629250

In this blog. I will explain you how to find random record in SQL server. This is most common interview question. The CHECKSUM function returns the checksum value computed over a table row, or over an expression list. Use CHECKSUM to build hash indexes. A hash index will result if the CHECKSUM function has column arguments, and an index is built over the computed CHECKSUM value. This can be used for equality searches over the columns. SQL NEWID function is used for selecting random row from a result set in SQL Server databases. NEWID is use to assign a value to a variable declared as the uniqueidentifier data type.

Farhan AhmedOct 25, 201824,161250

In this post, we will learn how to calculate the time between two dates in years, months, and days format. There is a special function for getting a perfect year, month, and day count.

Hardik DeshaniOct 25, 201823,036250