Let's have a look at the difference in performance between a cursor and the merge statement. ![]() It's usually faster to work with a set of records instead of 'walking through' a table, one row at a time. Their use is discouraged because they tend to perform poorly. ![]() Today we'll have a look at Microsoft SQL Server programming and specifically the CURSOR and MERGE statements.Ī cursor can be used to loop through a set of rows programmatically.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |