Loading

Condition Check in Stored Procedure

Condition Check in Stored Procedure

Ramco Ramco

1y826SQL

Hi

In a stored procedure i want to check a condition through query if it is false only then the remaining part of S.P should gets executed.

Thanks

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Jaimin Shethiya1y ago
Accepted answer
Hello,

You can use simply if statement as below mentioned.
```
If (Condition)
Begin
......
......
End
```
If you want to use if else statement then you can use below example.
```
If (Condition)
Begin
....
....
End
Else
Begin
....
....
End
```
Thanks
0
Vijay Pratap Singh1y ago
Hi
You can achieve this by using an 'IF' statement in your stored procedure to check the condition and decide whether to proceed with the rest of the procedure.
For more info please visit below article
https://www.c-sharpcorner.com/UploadFile/rohatash/if-and-while-statement-in-sql-server-2012/

https://www.c-sharpcorner.com/UploadFile/65fc13/conditional-statements-in-mysql/

Thanks
+1