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.
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.
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.
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.
In this post we will learn step by step how to create user login using SQL Server Management Studio GUI (Graphical User Interface)
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 Earlier in How to Export SQL Server Table to Access Database post we learned how to export SQL Server table to Access…
In this article, we will learn how to export SQL Server table data to MS Access Database using SQL Server Management Studio.
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.
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.
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.
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.
In this article, we will learn how to restore a full database backup using SQL Server Management Studio Graphical User Interface.
In this article, we will learn how to take a full database backup using SQL Server Graphical User Interface.
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.