IPGraySpace: Sql Server - How to create new user, data base in express 2017

IPGraySpace: SQL Server - How to create a new user, create a database with a new user and create a table in SQL server express 2017

This video shows How to create new user, create a database with new user and
create a table in SQL server express 2017

1. log in to SQL Server using SQL Server Management Studio
2. log in as windows authentication
3. After login right click on the root directory "properties"
4. Click "Security" from left navigation check "SQL Server and Windows Authentication Mode" click "OK"
5. Restart SQL server Service
6. If the service restart does not work - restart the computer itself
FYI: you can't create a user account on "windows authentication mode"
change it to "SQL Server and Windows Authentication Mode"

7. After restart open SQL Server Management Studio
8. log in as windows authentication
9. From the left panel right click on "Security" and "new" and "Login"
this will give you full access as windows authentication
10. Follow other steps in the video
11. Create a database
12. Create a table use the following script to create a table
13. Insert row
14. Select row

I personally prefer nvarchar instead of varchar, nvarchar supports uni code

CREATE TABLE Employee (
EmployeeID int not null,
LastName varchar(50),
FirstName varchar(50),
Street1 varchar(50),
Street2 varchar(50),
City varchar(50),
State varchar(50),
StateCode varchar(3),
Country varchar(50),
CountryCode varchar(3),
CONSTRAINT PK_Employee PRIMARY KEY (EmployeeID)
);

thanks for watching

Follow more IPGraySpace videos
-----------------
thank you for watching the IPGraySpace video
please share, subscribe, and comment

visit
www.ipgray.com
www.ipgrayspace.com
for more IT articles, documents, and videos