Menu Bar

Home
Introduction to HTML Tables Elements and Attributes Lists Google Home Page Registration Form Forms_1 Forms_2
Introduction to CSS Three types of css Tables Forms(id,class,psuedo class) Backgrounds Periodic table Border in a table Margins and Padding Height,Width,Overflow
Introduction Basic Script Data types and Operators String methods and Arrays Functions and Objects Events Dialog boxes Conditions Loops Error Handling External JS Simple Calculator
Introduction SQL Installation and User creation SQL:Database and Table Creation SQL:Alter Constraints Select,Insert Delete Operators Functions Joins, Union, GroupBy Missing Items User Defined Functions Views Backup and Restore Company DB, Table and records Queries on Company DB Computer Business DB and Queries
Introduction Variables, Datatypes & Operators Conditional & Looping Statements Functions Pointers & Recursion Array & Files Patterns
Introduction Problems in C++
Configuration SQL server connection Introduction to PHP
Introduction VB.NET VB.NET Compilation & Run VB.NET Problems No link
Design Principles Stone Profit support page MasterLegacy MasterDev Work with Live System

SQL: Installation

Steps:

 Go to this link to download sql server express edition.
https://www.microsoft.com/en-ie/sql-server/sql-server-downloads



Double click on the setup file which is located in download folder.



Click on new sql server to install sql server.

































Now installation of sql server is completed.




Create a new user to sql server:

 Open sql server management studio.



Login using windows authentication.



Goto security -> login and right click on it then select new login.




Enter user name and password.
































Select permission.



Now login with user name and password in SQL server authentication


















Create new database:













Create a table:













Insert records into table:











Subscribe to: Posts (Atom)