In this article, we will learn how to find and remove duplicate records in SQL.
In this article, we will learn about how to get the Connection String from SQL Server using Visual Studio.
In this article, we will learn how to create a user in SQL.
To create a user for a database, we first have to create a new login for the server or we can use an existing one.
In this article, we will learn how to create a login in SQL.
In this article, we will learn how we can generate script(s) of our database with existing data, in SQL Server.
Once database script(s) are generated, the result will give you an insert query with other queries so that the data also will get inserted in your new database.
In this article, we will learn how to export data from SQL to excel file.
In this article, we will learn how to import excel file in the SQL table.
In this article, we will learn how to Concat columns in SQL.
In this article, we will learn how to use the Server Profiler in SQL Server.
Microsoft SQL Server Profiler is a graphical user interface for tracing, recreating, and troubleshooting problems in MS SQL Server, Microsoft’s relational database management system.
In this article, we will learn how to use the Date Formats in SQL.
SQL Server has many built-in Date Formats.
