rss
twitter
facebook

Home

CONVERT and CAST SQL

DECLARE @value decimal (5, 2)
SET @value = 193.57
SELECT CAST(CAST(@value AS varbinary(20)) AS decimal(10,5)) +6.43

OR another

SELECT CONVERT(decimal(10,5), CONVERT(varbinary(20), @value ))
Read More

Ruby on Rails

Hello my friends :)

another Manual but this is Ruby on Rails



Read More

Filter Date

EnterParameters
@dt_Incio
@dt_fim

((@dt_inicio = @Nulldate and @dt_fim = @Nulldate) OR
((CAST(FLOOR(CAST( {EMAIL}.[Created_DateTime] as FLOAT)) AS DATETIME)) >= @dt_inicio AND
(CAST(FLOOR(CAST( {EMAIL}.[Created_DateTime] as FLOAT)) AS DATETIME)) <= @dt_fim))
Read More
 
Powered by Blogger