Xfigs16

B00

'ublishing - Microsoft Developer Studio - [reptq3 : Stored Procedurę (pubs)]

dl File Edit View insert Project		Build Jools Window Help .1191x1
I # Pil A ! Si €)	m	^ y i		O ^ Q -	IG	pS ■§* % Phone jJ	<p+Q

_l*

B-tj^l PubDB

i--® pubs (PENTIUM)

B |_] Database Diagrams ffl P~1 Tables B O Views & Stored Procedurę; B ^ byroyalty B ^ reptq1 B ^ reptq2 B ^I~reptq3]

^ sp_adduserob

B

sp_checkprop

sp_droppropei

sp_droppropei

sp_dropuserot

sp_dropuserot

sp_getobjwith|

sp_getproperti

sp_getproperti.

CREATE PROCEDURĘ reptq3 @lolimit money, @hilimit money,

@type char(12)

AS

select pub_id, type, title_id, price from titles

where price >@lolimit AND price <@hilimit AND type = @type OR ty

Run Stored Procedurę

OK

int dbo.reptq3

TYPE	NAME	VALUE
money	@lolimit	15.00
money	@hilimit	20.00
j char	@type	business

Cancel

Help

E

ii

■ 5 Cl...| &Ś|R... | «] Fil ) D... -J In... |	M I		Jj
2£l Running dbo. reptq2 . _<] type pub_id title_id	au_ord Name	ytd_sales
business 073S BU2075 (1 row(s) affected)	1 Green	18722
4 | [*ug Find in Files 1 Find in Files2	Results / SQL Debugging / || 4 \

Ready

2:11 PM

r:. m...

eys-

ilw..

RJ7ML.

0 A...

E1K...

®®P...

fiFr...