QA Practices

LO1: Creating the Tables LO2: Enforcing Primary and Foreign Key Prerequisite: Creating a Database Creating Tables You can create a table by two ways. By Graphically : Expand the Database in Object Explorer and right click on Tables folder and click on New Table Give the Column Name, Data Type and check Allow Nulls. Column Name: This is going to be your column name and this column name should be unique in the table. Data Type: For which type of data will be contained in the column. For example int, nvarchar, float, image etc. Allow Nulls: This is a check box which tells us that the column will contain null values or not. Primary Key allows you to uniquely identify the row in the table and it does not allow null. Must Remember: Primary key can be applied to one single column or group of the column to uniquely identify a record/row in the table but only one primary key allows in the table. To make the primary key graphically y...

This is a post for manual test.

LO1: Creating, Altering and Dropping a Database Prerequisite:   Connecting to SQL Server using SSMS After connecting to the database through SSMS first we need to create the database on which different queries will run. Let’s start with creating a Database. A SQL Server Database can be Created, Altered or Dropped in two ways: Graphically using SQL Server Management Studio or Using SQL Query Graphically using SQL Server Management Studio: Within the Object Explorer, right-click on Database folder and select the New Database. When clicked on New Database a new dialog box will open. Here you need to provide the database name and when clicking on OK, SQL Server run the query internally and will create the new database for us. When you expand the database folder then you will see the Sample database here Creating Database Using Query: We can also create the database by executing the query in the query editor. For creating a...

LO 1: Connecting to SQL Server using SSMS (Sequel Server Management Studio) LO 2: Know about SQL Server Management Studio LO 3: Different authentication mode to connect to SQL Server Connecting to SQL Server using SSMS (Sequel Server Management Studio):    Install SQL Server (I have installed SQL Server 2008)   To Start SQL, Go to Start and here you should find folder name “Microsoft SQL Server 2008 R2” and now you will see “SQL Sever Management Studio” Click on it and this will open the SSMS window. Once the window is opened, you will see a Connect to SQL pop up. This is information required by the SQL server to connect to the database. SSMS and Sequel Server database are two different things.  A database server typically contains all the data that is all the rows or any data base objects like triggers, store procedure, views etc and connect to that database the client tool we generally used is SSMS (Sequel Server Management Stud...