DevSocial Articles · SQL Server articles

Today, we will learn how to find a Primary Key, Unique Key, or a Foreign Keys in a table using SQL and how to delete a primary key, unique key, or a foreign key from a table using SQL.

Code AloneDec 21, 202244,1491,000

In this article, you will learn how to prevent SQL Injection.

Saurav MisraDec 21, 202257,3291,000

In SQL Server, we usually come across queries, tables, views, stored procedures and functions. People often wonder what are the real differences between User Defined Functions (UDF) or simply functions and stored procedures or just procedures. There are two types of functions: Built-in and user defined. Built-in functions cannot be modified where as you can create and modify your own UDF. To utilize the full advantage of these features, we should understand their capabilities and what we can do with them and what we cannot. I am going to explain this in terms of SQL Server.

Dennis ThomasDec 20, 202273,7851,000

In this article we are going to see what Data Flow Transformations in SSIS are and the list of controls that are provided in the data flow transformations followed by a series about each control including their usage.

Karthikeyan AnbarasanDec 20, 202239,2041,000

In this article, we’ll learn to give READ and WRITE permission to user after creating their login in SQL Server.

Abhishek YadavDec 19, 2022358,1851,000

Grant SQL statement grants permissions on an object to a user. Revoke removes permissions on an object. In this article, learn about Grant and Revoke in SQL Server.

Deepak MiddhaDec 18, 2022200,5031,000

In this article we will learn about SELECT statements in SQL Server.

Harpreet SinghDec 18, 202228,3491,000

How do you get the data from the table? How do you create or drop the table? How do you display the different records? Do you want to? You can easily do all of this by writing a simple SQL query.

Rajesh GamiDec 17, 202260,5911,000

Simplify complex joins and subqueries using SQL Server Common Table Expressions or CTEs. It also provides a way to query hierarchical data. This article provides a complete overview of CTEs, types of CTEs, benefits, drawbacks, and how to use them with SQL Server.

Rajesh GamiDec 15, 202243,0381,000

Do you wonder the difference between nvarchar vs varchar? This article discusses the differences between CHAR, VARCHAR, NCHAR and NVARCHAR data types. CHAR vs VARCHAR, NCHAR vs NVARCHAR, difference between char and varchar, difference between nchar and nvarchar.

Pradeep ShetDec 9, 2022905,0811,000

In this article, you will learn about 50 Important Queries in SQL Server. EXEC sp_helpdb, exec sp_helptext, EXEC sp_updatestats, EXEC sp_MSforeachtable, SQL query for version name of SQL Server, Enable a SQL Trigger, Disable a SQL Trigger, EXEC sp_recompile, sql query for First Date of Current Month, Swap two column values in SQL, Remove all stored procedures, Remove all views from database, Drop all tables.

Pankaj Kumar ChoudharyDec 8, 2022834,6811,000

This article helps you to create a stored procedure in SQL Server and learn how to use a stored procedure in an ASP.NET application.

Know the SQL server maintenance plan best practices with scripts & without scripts. This guide has the best SQL server maintenance solution in simple tasks for users.

Anurag SharmaDec 7, 202221,9881,000

We will learn how to Format Date and Time in SQL Server Using FORMAT Function.

Deepak TewatiaDec 4, 202238,3881,000

Learn to migrate SQL server to new server without errors. This guide has the best four solutions to migrate SQL server database to another server smartly.

Anurag SharmaDec 4, 202222,6031,000

Trying to reconnect Log File to MDF File? Read and try the method given in the article.

Mukesh NailwalNov 4, 20223,0131,000

If you want to reset SA password in SQL Server, simply read this blog as we have mentioned simple manual method to reset forgotten System Administrator password.

Mukesh NailwalOct 31, 202225,7011,000

In this article, we have mentioned few points to Bring Database Online from Suspect Mode in SQL Server.

Mukesh NailwalOct 27, 202214,7491,000

Searching a string in all the tables available in the SQL Server database

Mukesh SagarOct 20, 202224,2121,000

In this article, you will learn about T-SQL - Pivoting And Unpivoting data.

Tural SuleymaniSep 20, 20227,6841,000

In this article, you will learn about Derived Tables Vs Common Table Expressions.

Tural SuleymaniAug 28, 20227,8001,000

In this article, you will learn how to Clone Tables In SQL.

Uday DodiyaAug 25, 202220,0931,000

In this article, you will learn about triggers in SQL Servers.

Jignesh KumarAug 19, 20227,3321,000

In this article, you will learn how to restore SQL Server Database Backup using two methods.

Vishal YelveAug 18, 20225,8471,000

In this article, you will learn how to rename database objects in SQL Server.

Anupam MaitiAug 17, 20229,5221,000

This article will discuss the ways to get ConnectionString from different sources.

GeorgeAug 13, 2022181,2461,000

In this article, you will learn about ORM vs Stored Procedures in Programming.

Munib ButtAug 10, 20229,2381,000

In this article, I collected interview questions on data types. I participated in many interview calls and I was asked about (sometimes I asked the interviewee) many times the below interview questions .

Tural SuleymaniJul 31, 20225,5491,000

In this article, you will learn about Identity vs NewSequentialId vs NewId.

Tural SuleymaniJul 31, 20228,0811,000