Mail Merge in 5 minutes

How to Improve Improve the Performance of Your Computer - 3 times faster!

This video explain how you can improve the speed of your computer, making your computer 3times faster than normal.

How to Write Stored Procedure in SQL Server

How to Write Store Procedures in SQL Server
In this video, Kindson The Tech Pro explains how to write stored procedures in SQL Server in few minutes.
Personally I could not believe it when I learned how to write stored procedures in SQL Server. I was so easy to learn. Sometimes even  news DBAs find it difficult to get a starting point in writing stored procedure.
Once thing you need to remember is that stored procedures are simply sql queries that have been saved for resuse.
Items you would require include
• SQL Server Management Studio
• Some data to use for the test.
• Some knowledge of SQL Queries
So carefully follow the instructions below:
• Open SQL Server 2008. SQL Server 2008 R2, 2005 or 2014 would also work. This presentation is made using SQL Server 2008 R@
• Import the data you want to use into SQL Server ( Tasks – Import)
• Expand the database node
• Expand the Programability node
• Right-click on the Stored Procedures node and click on New Stored Procedure
• Erase Everything that appears so that you will have a bland space.
• Enter the code below:
• 
  
CREATE Stored procedure GetMembers
AS
SELECT * FROM tblMembers


• Click on the execute button on the toolbar to execute the stored procedure. (this assumes that you have a table named tblMembers)


How to Modify and Existing Stored Procedure
• Expand the Stored Procedure node
• Right-click on the Stored Procedure you want to alter
• Click on Modify( the Second item in the context menu). This opens the stored-procedure window
• Go ahead to make the needed modification an click on execute to save the changes.


To Create a Parameterized Stored Procedure, use the syntax below


CREATE Stored procedure GetMembers
@Firstname VARCHAR(50)
AS
SELECT * FROM tblMembers WHERE Firstname = @Firstname


Thank you for reading. If you have any issued, do leave a comment below.
• Knowledge of Writing SQL Queries(How To Write SQL Queries)

Do leave a comment below if you need me to explain more.

Get more on: Kindson The Tech Pro

How to Edit Video on Youtube Merge Two Videos Using Creator Studio

This presentation explains how to merge two videos using Youtube Creator Studio.

This is important because you may be a beginner and may not have the budget to buy a really good video editing software.

The Steps are.
1. Open YouTube (www.youtube.com)
2. Go to your channel
3. Click on your channel picture on the upper right corner.
4. Under your name (or your channel name) you will see 'Creator Studio), Click on it to open the Creator Studio dashboard
5. At the lower left corner of the window, Click on Create
6. Click on Video Editor to open the video editor window. The Video Editor Window has 3 sections: The Preview section, the Timeline and the Videos
7. Drag the two videos you will like to merge to the timeline
8. Enter the name of the new video in the Name Box above the Preview
9. Click on Create Video and wait for a while, you video would be created and thats all!

Writing SQL Queries in SQL Server and MS Access

TCP/IP Address and Subnetting: Part 1 - Converting Binary to Decimal

Introduction to KTTPro (Kindson The Tech Pro)