Monday, December 5, 2011

Test Stored Procedure Manually in MS SQL

Write a stored procedure  eg :  sp_Insert_Client_info

Now on New Query window  execut it with stored procedure's required value,

 like this  sp_Insert_Client_info'Age','India','phone',10101

Above sp will take 3 arguments/values :

  1. Age  or text value
  2. India or Text vale
  3. 10101  or integer value


Another example:

 sp_Insert_Client_Info'Jhon','sharma',87


No comments:

Post a Comment