try this:
SELECT (num % 1)
More Related Contents:
- I dont know sql syntax for my table [closed]
- How do I UPDATE from a SELECT in SQL Server?
- Get top 1 row of each group
- How to return only the Date from a SQL Server DateTime datatype
- How to calculate age (in years) based on Date of Birth and getDate()
- CROSS JOIN vs INNER JOIN in SQL
- Referring to a Column Alias in a WHERE Clause
- Convert Month Number to Month Name Function in SQL
- Function vs. Stored Procedure in SQL Server
- Multiple INSERT statements vs. single INSERT with multiple VALUES
- Limit on the WHERE col IN (…) condition
- Removing leading zeroes from a field in a SQL statement
- converting Epoch timestamp to sql server(human readable format)
- Getting result of dynamic SQL into a variable for sql-server
- How to get difference between two rows for a column field?
- How do I split a delimited string so I can access individual items?
- What’s the best way to select the minimum value from several columns?
- Counting DISTINCT over multiple columns
- SQL Server SELECT into existing table
- Is there a performance difference between CTE , Sub-Query, Temporary Table or Table Variable?
- Why use Select Top 100 Percent?
- How to check if a stored procedure exists before creating it
- Correct use of transactions in SQL Server
- How do I prevent a database trigger from recursing?
- What is the Null Character literal in TSQL?
- Aggregate function in an SQL update query?
- Executing SQL Server Agent Job from a stored procedure and returning job result
- how does SELECT TOP works when no order by is specified?
- SQL Server search using like while ignoring blank spaces
- Use variable with TOP in select statement in SQL Server without making it dynamic [duplicate]