Triggers & Store Procedures Testing

[ipaddress0]

define a parameter debug_fl bit =0


if debug_fl=1

write data so when u test u can pass parameters and pass debug_fl=1 which will print the data

mayya konchem layman terms lo explain sey plz :(

[ZuniorVentiyar]

mayaa nuvvu confusse avuthunavu .. SP and triggers ni kalapakunda okasari google chesi chudu .. u get an idea

thanks mayya... normally sp create sesi vatini trigger dwara invoke seathara?

 

[ipaddress0]

mayaa nuvvu confusse avuthunavu .. SP and triggers ni kalapakunda okasari google chesi chudu .. u get an idea

ok mayya ippude sustha

[king420]

sarvanasam esukoni pothav ra...sarvanasam esukoni pothav ra...

[king420]

sarvanasam esukoni pothav ra...sarvanasam esukoni pothav ra...

[king420]

sarvanasam esukoni pothav ra...sarvanasam esukoni pothav ra...

[king420]

sarvanasam esukoni pothav ra...sarvanasam esukoni pothav ra...

[ipaddress0]

sarvanasam esukoni pothav ra...sarvanasam esukoni pothav ra...

emaindi mayya...ninn evvar em annar :(

[dotnetrockz]

mayya konchem layman terms lo explain sey plz :(

neeku stored proc ne test cheyyalante  query analyzer lo oka option untadhi just plugin the parameters and it will display the results but in realtime scenarios.......ur stored proc will be like 2000-4000 lines alantappudu expected results ravalante every data manipulation (updates) and deletes and select(ateast important vi) capture cheyyali..so daani kosam nee proc defintion lo paramters untayi kadha add extra param named debug_fl ..idhi bit value and default 0 pettu 

 

so when u want to see important updates and deletes

 

write code in ur sp like 

 

if @debug_fl=1

select @value1 as 'current value'

 

 

if @debug_fl=1

select 'deleting emp data'

select @@rowcount as 'rowsdeleted'

 

 

hope u understood

[king420]

sarvanasam esukoni pothav ra...

[king420]

sarvanasam esukoni pothav ra...sarvanasam esukoni pothav ra...

[king420]

sarvanasam esukoni pothav ra...

[king420]

sarvanasam esukoni pothav ra...

[king420]

sarvanasam esukoni pothav ra...

[ipaddress0]

neeku stored proc ne test cheyyalante query analyzer lo oka option untadhi just plugin the parameters and it will display the results but in realtime scenarios.......ur stored proc will be like 2000-4000 lines alantappudu expected results ravalante every data manipulation (updates) and deletes and select(ateast important vi) capture cheyyali..so daani kosam nee proc defintion lo paramters untayi kadha add extra param named debug_fl ..idhi bit value and default 0 pettu

so when u want to see important updates and deletes

write code in ur sp like

if @debug_fl=1
select @value1 as 'current value'


if @debug_fl=1
select 'deleting emp data'
select @@rowcount as 'rowsdeleted'


hope u understood

thanks mayya ippud ardam aindi... adi SQL developer tho cheyinchali anukunta kada?