Manipulating Stored Procedures in Microsoft SQL Server

Stored Procedures 

To fully and robustly manipulate a given stored procedure in SQL via the use of queries we will initiate the latter in creating a dummy database by using the following command: 

USE AdventureWorks2014 GO 

The above command will generate a database for us a demo database which we can use to enter records and to change rows and columns. In our instance we are using Microsoft SQL server 2014 via the Management Studio tools. Once the above database has been created we can now generate rows and columns via the following code snippet: 

Use    Adventureworks2014 Go CREATE TABLE dbo.person ( PersonID    int PRIMARY KEY NOT NULL, FirstName varchar( 25 ) NOT NULL, LastName varchar( 25 ) NOT NULL, ResAddress text NULL,) Go 

In our database we have created 4 data columns that will predominantly house the every record that we may enter into the system now. To proceed to our stored procedure exercise we will add records for each of these criteria’s using the following details: 

PersonID – This will a unique identifier for each record and will serve as the primary key for our database. 

First Name – Since the database houses names of individuals the First Name field is a char (variable character) field. 

Last Name – Using the same parameters as the first name, the last name too is a char field. 

ResAddress – The stored residential address of the database which acts as a text field. 

All the above fields, once created are to be updated using the query menu that can be called with specific SQL commands to fill our database with sample input we utilized the following snippet of code to provide ourselves with a set of demo data. 

Use    Adventureworks2014 Go --    Standard    Syntax INSERT dbo.person ( PersonID ,    FirstName ,    LastName ,    ResAddress ) VALUES ( 00001 ,    'WAQAS' ,    'AHMED' ,    '25 CLOVER LANE BOSTON' ) GO INSERT dbo.person ( PersonID ,    FirstName ,    LastName ,    ResAddress ) VALUES ( 00002 ,    'BILAL' ,    'UBAID' ,    '18 DOWNING STREET' ) Go INSERT dbo.person ( PersonID ,    FirstName ,    LastName ,    ResAddress ) VALUES ( 00003 ,    'DAVE' ,    'SMITH' ,    '22 BOSTON BOULEVARD' ) Go INSERT dbo.person ( PersonID ,    FirstName ,    LastName ,    ResAddress ) VALUES ( 00004 ,    'MICHEAL' ,    'SCOTT' ,    '02 ORANGE COUNTY' ) Go INSERT dbo.person ( PersonID ,    FirstName ,    LastName ,    ResAddress ) VALUES ( 00005 ,    'JEREMY' ,    'ONG' ,    '26 DOWN TOWN AVENUE' ) Go 

Once the records have been successfully added they can be called upon using the FROM command which prints out the rows and columns as per the provided screen capture from the SQL database. 

SELECT PersonID ,    FirstName ,    LastName ,    ResAddress FROM dbo.person Go 

NoSQL Couch base Install 

To successful install the NoSQL couch base server a user must initially run the installed executable file as administrator. Once the executable runs fully the system will prompt the user with the following screen message: 

Very simply the user has to click on the next button to proceed to the main screen for couch base server and from there onwards the actual installation would begin. Please note that couch base also prompts the user to select any given installation directly as it fundamentally installs the latter based on the IIS settings in the system by default. 

The above screen is followed by a representation of the minimum system requirements are needed to make the couch base function optimally. If the system detects hardware that is capable of supporting the application it will just simply prompt the user to press next as implied in the latter screen: 

If there are no hindrances to the installation process the system will install couch base server on the user’s computer and from henceforth the settings on the server can be accessed by going into any IIS supported browser and typing localhost:8091 to retrieve the settings.