How to Excecute Store Procedure in Sql Server

Introduction: In this post I will explain we can Excecute the Store procedure in Sql Server.

Description:

In the last article i have explained Check Password case sensitive in Asp.net using Sql server during Login and Sql Server Queries with Example

use TEST_APPLICATION

exec dbo.DISPLAY_USERS

OR

exec dbo.DISPLAY_USERS

Here TEST_APPLICATION is the name of Database and dbo.DISPLAY_USERS name of store procedure. Execute it, display the output of store procedure.