Forwarded from Parsa
شماره a رو گرفتم ۱۰
و شماره b رو گرفتم ۱۱
و شماره b رو گرفتم ۱۱
Forwarded from Parsa
Create function ss
(
@p1 nvarchar (10)
)
Returns nvarchar (3)
As
Begin
Declare @rs nvarchar (3)
If exists (
Select PID from Part where Pname = @p1) set @rs = 'YES' else set @rs = 'NO'
Return @rs
End
(
@p1 nvarchar (10)
)
Returns nvarchar (3)
As
Begin
Declare @rs nvarchar (3)
If exists (
Select PID from Part where Pname = @p1) set @rs = 'YES' else set @rs = 'NO'
Return @rs
End
Forwarded from Parsa
Create Trigger sp
On [dbo].[part]
After insert, update
As
Begin
If exists (
Select PID from Part where color = N'قهوه ای' and city not like N'مادرید')
Rollback transaction;
End
On [dbo].[part]
After insert, update
As
Begin
If exists (
Select PID from Part where color = N'قهوه ای' and city not like N'مادرید')
Rollback transaction;
End
Forwarded from Parsa
جزوه و نمونه سوال امتحان مهندسی کامپیوتر
Photo
Create procedure dd
(
@p1 int ,
@p2 int ,
@p3 int
)
As
Begin
If (@p3 < 100)
Insert into Shipment (SID , PID , QTY) values (@p1 ,@p2 ,@p3);
End
(
@p1 int ,
@p2 int ,
@p3 int
)
As
Begin
If (@p3 < 100)
Insert into Shipment (SID , PID , QTY) values (@p1 ,@p2 ,@p3);
End