Rounds the value of the number n by using the precision p. Use positive values of p to round on the right side of the decimal point and use negative values to round on the left side. An optional p,[t]) parameter t causes n to be truncated. Examples: SELECT ROUND(5.4567,3) = 5.4570 SELECT = 350.0000 SELECT = 340.0000 Returns the number of rows that have been affected by the last Transact-SQL ROWCOUNT_BIG statement executed by the system. The return of this function has the BIGINT data type. Returns the sign of the value as a n number (+1 for positive, for –1 SIGN(n) negative, and 0 for zero). Example: SELECT SIGN(0.88) = 1 Calculates the sine SIN(n) of n. n and the resulting value
p,[t]) Rounds the value of the number n by using the precision p. Use positive values of p to round on the right side of the decimal point and use negative values to round on the left side. An optional parameter t causes n to be truncated. Examples: SELECT ROUND(5.4567,3) = 5.4570 SELECT = 350.0000 SELECT = 340.0000 ROWCOUNT_BIG Returns the number of rows that have been affected by the last Transact-SQL statement executed by the system. The return of this function has the BIGINT data type. SIGN(n) Returns the sign of the value n as a number (+1 for positive, –1 for negative, and 0 for zero). Example: SELECT SIGN(0.88) = 1 SIN(n) Calculates the sine of n. n and the resulting value
1.0%20SQL-SERVER_Notes.docx