SET vs. SELECT – What’s the difference?

by

SET is the ANSI standard way of assigning values to variables, and SELECT is not. But you can use SELECT to assign values to more than one variable at a time. SET allows you to assign data to only one variable at a time. So that in performance is where SELECT will be a winner.

For more detail and examples refer to: Difference between SET and SELECT when assigning values to variables

More Related Contents:

  1. SET vs. SELECT – What’s the difference?
  2. Why is appending to a list bad?
  3. High-performance merging of ordered sets
  4. Google app script timeout ~ 5 minutes?
  5. What is the purpose of the EBP frame pointer register?
  6. Algorithm to calculate the number of divisors of a given number
  7. Why are difference lists more efficient than regular concatenation in Haskell?
  8. Analyzing Code for Efficiency?
  9. Apache Spark: map vs mapPartitions?
  10. Reading GHC Core
  11. CSS3 Transitions: Is “transition: all” slower than “transition: x”?
  12. Size of store buffers on Intel hardware? What exactly is a store buffer?
  13. Avoid stalling pipeline by calculating conditional early
  14. Android studio takes too much memory
  15. What is the fastest way to get the value of π?
  16. Most efficient list to data.frame method?
  17. Tools to measure MPI communication costs [closed]
  18. Has anyone actually implemented a Fibonacci-Heap efficiently?
  19. Why does the 2nd T-SQL query run much faster than the first when called by Reporting Services 2005 in a web-app
  20. Order of the code and performance
  21. latency vs throughput in intel intrinsics
  22. Why is putImageData so slow?
  23. how do numactl & perf change memory placement policy of child processes?
  24. What’s a fast way to space-out bits within a word?
  25. How can Google be so fast?
  26. Client-side logic OR Server-side logic?
  27. Trouble converting long list of data.frames (~1 million) to single data.frame using do.call and ldply
  28. Range() VS Cells() – run times
  29. Performance of bcp/BULK INSERT vs. Table-Valued Parameters
  30. MongoDB’s performance on aggregation queries

Leave a Comment