title: Right Shift And Left Shift Operator in SQL Server
body: <p>In SQL Server, shift operators are not present as per knowledge.</p>
  
  <p>If I have to achieve right shift and left shift, what will be the efficient way of doing it?</p>
  
  <ol>
  <li>With mathematical expressions which will give me the same output as shift operator must have given.</li>
  </ol>
  
  <p>OR </p>
  
  <ol start="2">
  <li>Will call CLR function to calculate the right shift and left shift because shift operators are available in C# which will give me the output what I am expecting.</li>
  </ol>
  
  <p>Please suggest which one will be the more efficient way of doing it.</p>