asp.net core docker Replacing cursors using joins in sql server Part 64

Text version of the video
http://csharp-video-tutorials.blogspo...

Slides
http://csharp-video-tutorials.blogspo...

All SQL Server Text Articles
http://csharp-video-tutorials.blogspo...

All SQL Server Slides
http://csharp-video-tutorials.blogspo...

All Dot Net and SQL Server Tutorials in English
https://www.youtube.com/user/kudvenka...

All Dot Net and SQL Server Tutorials in Arabic
https://www.youtube.com/c/KudvenkatAr...


In Part 63, we have discussed about cursors. The example, in Part 63, took around 45 seconds on my machine. Please watch Part 63, before proceeding with this video. In this video we will re-write the example, using a join.

Update tblProductSales
set UnitPrice =
Case
When Name = 'Product - 55' Then 155
When Name = 'Product - 65' Then 165
When Name like 'Product - 100%' Then 10001
End




from tblProductSales
join tblProducts
on tblProducts.Id = tblProductSales.ProductId
Where Name = 'Product - 55' or Name = 'Product - 65' or
Name like 'Product - 100%'

When I executed this query, on my machine it took less than a second. Where as the same thing using a cursor took 45 seconds. Just imagine the amount of impact cursors have on performance. Cursors should be used as your last option. Most of the time cursors can be very easily replaced using joins.

To check the result of the UPDATE statement, use the following query.
Select Name, UnitPrice from
tblProducts join
tblProductSales on tblProducts.Id = tblProductSales.ProductId
where (Name='Product - 55' or Name='Product - 65' or
Name like 'Product - 100%')

asp.net core docker Replacing cursors using joins in sql server Part 64
328 Likes	328 Dislikes
100,740 views views	524K followers
Education	Upload TimePublished on 13 Jan 2013

Related keywords

wcf vs web api,ado.net core,sql server management studio,webkinz,webadvisor,craigslist nj,wcf one piece,asp.net core 3,ajax players,performance hall ankara,weber grill parts,webtoon,tutorials by hugo,csharp corner,mvc design pattern,asp.net machine account,servers for minecraft,asp.net core dependency injection,ado.net tutorial,performance art,services angular,performance bond nedir,ajax ontario,performance power akülü vidalama,asp.net mvc tutorial,asp.net cos'è,csharp assembly,tutorialspoint python,sql server 2008 r2 service pack,sql server 2008 r2 download,sql join,services briefcase,asp.net core web api,ajax jquery,wccftech,craigslist ny,performance power l tipi promo akülü vidalama,asp.net zero,csharp foreach,server memes,sql date format,services online,chase,performance power,serverless architecture,server resume,wcf c#,server books,tutorialspoint javascript,mvcc connect,ado.net mysql,services technologies gps,ajax deadpool,server jobs,cvs,website,mvc tutorial,costco hours,wcf service application,tutorialspoint spring,serverless,wcf soap,wcf cat,cool math games,wcf test client,performance test 9,services & training hse colombia sas,servicestack,citibank,sql server 2008 management studio,asp.net core identity,sql union,ajax parking,sql database,asp.net core logging,mvconnect,cunyfirst,sql server 2008 service pack 1,asp.net guida,sql server 2008 service pack 2,wcf nba,csharp download,sql server 2008 service pack 3,wcfi foundation,csharp online,wcf authentication,tutorials near me,http://asp.net,server 2019,chernobyl,ado.net descargar,web of dreams,serverminer,ajax cleaner,ado.net visual studio 2019,webassign,ado.net vs entity framework,ado.net visual studio 2017,csharp list,sql like,asp.net mvc,asp.net core tutorial,sqlite,wcfm,ajax roster,performance jant,mvc architecture,performance lastik,http://ado.net,sql server 2008 r2 iso,asp.net core mvc,ajax soccer,server hosting,wcfi,ajax dish soap,capital one,sql server 2008 r2 full,server rack,tutorialspoint html,csharp interface,performance maximizer,craigslist,webroot,tutorialspoint reactjs,ajax request,wcf dragon ball,sql server 2008 r2 service pack 4,asp.net core 2.2,tutorialspoint python 3,sql developer,webster,services transmission company sas,sql group by,asp.net core signalr,services manager,mvc framework,ajax paving,mvc near me,performance evaluation,sql server 2008 express r2 64 bits mandatory prerequisite was not correctly installed,tutorialspoint spring boot,mvc map,csharp online compiler,asp.net download,sql between,ado.net c# pdf,services tag dell,wcf 2019 nba,csharp switch,ado.net ventajas y desventajas,csharpstar,performance task,wcf tutorial,tutorialspoint,ajax meaning,csharp-video-tutorials.blogspot,tutorials dojo,central park 5,csharp string format,performance test,ado.net c#,asp.net core github,server status,ajax fc,server jobs nyc,asp.net core swagger,sql formatter,credit karma,services group,server error in '/' application,services windows,asp.net core 3.0,sql injection,performance ne demek,tutorialspoint c#,wcf ria services,calculator,ado.net entity data model,sql insert,tutorialspoint tableau,services google play apk,sqlyog,asp.net core 3 release date,sql server,sql server 2008 r2 windows 10,server job description,tutorials by a,servicenow,performance bond,webcam,mvc hours,webmd symptom,csharp array,csharp enum,ajax call,sql server 2008 r2 management studio,asp.net core 2. guida completa per lo sviluppatore,asp.net core,server pro,server status ffxiv,cheap flights,webcrims,sql server 2008 r2 standard,asp.net core hosting,services sas,sql server 2008 express r2,tutorialspoint java,sql server 2008 full,tutorialspoint java compiler,webmd,csharp to json,sql server 2008 download,college football,ado.net dataset,csharp dictionary,cnn,website builder,tutorialspoint sql,asp.net web api,server side rendering,weber grills,performance task metu,sql server 2017,tutorialspoint spark,mvc nj,ado.net oracle,asp.net core download,csharp to vb.net,webster bank,performance management,webstaurant,tutorialsystems,ajax post,services fms publish announcement,services.msc no abre,ajax jersey,csharp operator,asp.net core razor pages,server duties,asp.net core environment variables,csharp random,century 21,services consultores,services consulting,mvcsd,services.msc,mvcsc,ado.net pdf,asp.net core configuration,ajax marvel,performance marketing,sql server 2008 r2 sp2,sql server 2008 r2 sp3,sql update,asp.net tutorial,mvc medical,sql server 2008 r2 sp1,ado.net entity data model visual studio 2019,performance power matkap,wcfs international curriculum,performance hall,mvc2,ado.net entity data model visual studio 2017,chase online,wcf api,costco,server jobs near me,webex,sql meaning,sql tutorial,sql commands,sql server 2008 r2,ado.net entity framework,ajax tavern,tutorialsteacher,ajax javascript,services desk,ajax greek,csharp tutorial,mvc pattern,ado.net sql server,ado.net connection,asp.net identity,mvcu,asp.net core middleware,wcf web service,mvc webadvisor,web store,mvcc,webmail,mvci,mvctc,