The Queries in this page solved at the library database. It is a sample database generated by randomly records. You can download it from the link. You will see more than 500 examples in the future. You can filter from the search panel above by selecting sql statements. I hope you will like it

# SQL Declare Examples

##### 1-) Calling a Stored Procedure To Add Two Numbers With Input Output Parameters Example

Solution 1)

``````Create Procedure AddTwoNumber(@p1 int,@p2 int,@Result int output)
as
Begin
Set @Result = @p1+ @p2
End
--To Execute The Procedure
Declare @r int
Select @r as Result``````

ETİKETLER

- -
##### 2-) The Stored Procedure That Selects Random Number Between the Two Numbers Entered as Parameters In Sql

Solution 1)

``````Create Procedure Sp_Random_Value
@first int,
@second int,
@result int output
As
Begin
Set @result =Floor(RAND() * (@second-@first))+@first
End
--To Execute the Procedure
Declare @r int
Execute Sp_Random_Value 20,30,@r output
Select @r``````

ETİKETLER

- -
##### 3-) Generate Unique Random Numbers In Sql With Stored Procedure

Solution 1)

``````Create procedure randomGenerate(@unit int,@min int,@max int)
as
Begin
Declare @numbers table(number int)
Declare @i int = 0
Declare @number int
while (@i<@unit)
Begin
Set @number = floor(rand()*(@max-@min+1))+@min
if(not exists(Select * from @numbers where number = @number))
begin
insert into @numbers values(@number)
Set @i = @i + 1
end
end
Select * from @numbers order by 1
End
--To Execute Stored Procedure
Execute randomGenerate 5,20,30``````

ETİKETLER

- - - -
##### 4-) Calculating Factorial of Given Number with Stored Procedure

Solution 1)

``````Create procedure factor(@number int)
as begin
Declare @i int = 1,@result int=1
while (@i<=@number)
Begin
Set @result = @result * @i
Set @i += 1
End
Select @result
End``````

ETİKETLER

- -
##### 5-) Create A Stored Procedure Calculate Power Of A Number In Sql

Solution 1)

``````Create Procedure myPower(@num int,@pow int, @result int output) As
Begin
Declare @i int = 0;
Set @result = 1
while(@i<@pow)
Begin
Set @result = @result * @num
Set @i += 1
End
End``````

ETİKETLER

- -
##### 6-) Finding The Sum Of The Three Numbers With Stored Procedure

Solution 1)

``````Create Procedure sumThree
@n1 int,
@n2 int,
@n3 int,
@result int output as
Begin
Set @result = @n1+@n2+@n3
End
--To Execute The Procedure
Declare @result int
Execute sumThree 5,30,12,@result output
Select @result``````

ETİKETLER

- -
##### 7-) Stored Procedure To Find A Number Is Prime In Sql

Solution 1)

``````Create Procedure sp_isPrime (@number int,@result bit output) as
Begin
Set @result = 1
Declare @i int = 2
While (@i<@number)
Begin
if(@number % @i = 0)
Begin
Set @result = 0
break
End
Set @i += 1
End
return @result
End
--To Execute The Stroed Procedure
Declare @result bit
Execute sp_isPrime 11,@result output
Select @result``````

ETİKETLER

- -
##### 8-) Stored Procedure To Divide Numbers And Get Divided Value And Remaining Value

Solution 1)

``````Create Procedure sp_Devide(@n1 int,@n2 int,@division int output,@remaining int output) as
Begin
SEt @division = 0
While(@n2<=@n1)
Begin
Set @n1 = @n1-@n2
Set @division+=1
End
Set @remaining = @n1
End
--To Execute the Stored Procedure
Declare @d int,@r int
Execute sp_Devide 34,7,@d output,@r output
Select @d Division,@r Remaining``````

ETİKETLER

- -
Library Database