How To Change Schema Name in SQL Server
In this article, we will learn step by step how to change schema name in already created user by using SQL Server Graphical User Interface and by using T-SQL.
How To Create Database User In SQL Server
In this article, we will learn how to create database user in SQL Server and with a login and how to assign roles and permissions.
What is The Public Server Role in SQL Server
In this article, we will see What is the public Server Role in SQL Server and what we can do when assigned to a login created in the SQL Server.
How To Create SQL Server Login
In this post we will learn step by step how to create user login using SQL Server Management Studio GUI (Graphical User Interface)
How To Generate SQL Database Script With Data
In this article, we will learn how to generate SQL Database script with or without data using SQL Server Management Studio GUI (Graphical User Interface).
How to Import MS Access (.mdb) to SQL Database
How to Import MS Access (.mdb) to SQL Database Earlier in How to Export SQL Server Table to Access Database post we learned how to export SQL Server table to Access…
How to Export SQL Server Table To Access Database
In this article, we will learn how to export SQL Server table data to MS Access Database using SQL Server Management Studio.
How to Import Data From Excel (XLSX) to SQL Table
In this article, we will learn how to import data from excel(xlsx format) to SQL Server table using SQL Server Management Studio Import and Export Wizard.
How to Export SQL Table Data to Excel (XLSX)
In this article, we will learn how to export an SQL Server table to Excel (.xlsx) file using SQL Server Management Studio Import and Export Wizard.
How to Import Data From Text File to SQL Table
In this article, we will learn how to import data from a text file to an SQL Server table using SQL Server Management Studio Import and Export Wizard.
How to Export SQL Table Data To A Text File
In this article, we will learn how to export SQL Server table data to a text file using SQL Server Management Studio Import and Export Wizard.
How To Restore SQL Server Database From backup
In this article, we will learn how to restore a full database backup using SQL Server Management Studio Graphical User Interface.
How To Create SQL Server Full Database Backup
In this article, we will learn how to take a full database backup using SQL Server Graphical User Interface.
Cannot insert explicit value for identity column in table when identity_insert is set to OFF
In "Cannot insert explicit value for identity column in table when identity_insert is set to OFF" we learn how to insert values in Identity field explicitly.