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 :
Another example:
sp_Insert_Client_Info'Jhon','sharma',87
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 :
- Age or text value
- India or Text vale
- 10101 or integer value
Another example:
sp_Insert_Client_Info'Jhon','sharma',87
No comments:
Post a Comment