SQL Server 2000 Exponent Operator
Posted on 2005-04-06
Is there no operator in SQL Server for exponent? For example, 2 the power of 5 = 32. Is there any way to calculate 2 to the 5th? It doesn't seem like there is.
SQL Server offers this COLUMNS_UPDATED() function, and I'm trying to use it to see if the nth, and only nth column of my table has been changed, but I want to do it dynamically, and my understanding is that it is bit wise, so I need to 'AND' COLUMNS_UPDATED() with the value of 2 to the 5th power, or 32. I can get my colorder dynamically, but I can't do 2 the power of the value of colorder.