Round() function in SQL Server
Round():-This function is used to round a numeric field to the number of decimals specified.
Syntax:-
ROUND ( numeric_expression , length [ ,function ]
numeric_expression...
2014-08-12
891 reads
Round():-This function is used to round a numeric field to the number of decimals specified.
Syntax:-
ROUND ( numeric_expression , length [ ,function ]
numeric_expression...
2014-08-12
891 reads
This function returns the distinct values from the left query that are not also found on the right query. For...
2014-08-12
786 reads
Last week on one of our production servers (version 2011.110.3373.0), we’ve encountered a strange issue which is relatively new (only...
2014-08-12
608 reads
On Saturday, September 13th, I’ll be presenting my 10 Ways To Abuse T-SQL session in Kansas City. If you haven’t...
2014-08-11
295 reads
Error : Database backup is getting fail with below reason. The backup of full-text catalog ‘FullTextCatalog’ is not permitted because it is not online. Check errorlog file for the...
2014-08-11
27 reads
More notes, hopefully not repeating any from previous posts!
Karla has used the chart showing registration growth as a way to...
2014-08-11
568 reads
You know, these 1 hour sessions that are at most SQL Saturdays are just too short sometimes – you just get...
2014-08-11
696 reads
As you can see the webpage has changed!
New features are:
– Syntax highlighting on code snippets (and easy copy/paste)
– Better readability
–...
2014-08-11
522 reads
It’s Monday time for this week’s weekly link round-up. If you want to catch these links “live” (so exciting), follow...
2014-08-11
408 reads
I just paused our first LinkedIn campaign, the one that was based on a functional area of IT in the...
2014-08-11
491 reads
By Steve Jones
semaphorism – n. a conversational hint that you have something personal to say on...
By James Serra
(This is the third post in a three-part series on how AI is changing...
Continuing with my takeaways from SQLCon and FabCon Europe in Barcelona, let’s talk about...
Comments posted to this topic are about the item Pay for Performance, which is...
Jl. PB.Sudirman No.40, Tekoan, Tanggul Kulon, Kec. Tanggul, Kabupaten Jember, Jawa Timur 68155
Jl. YOS Sudarso No.49, Dusun Kp. Baru, Jajag, Kec. Gambiran, Kabupaten Banyuwangi, Jawa Timur...
I have a table, dbo.bittest, where I am testing an application response. This has this structure:
CREATE TABLE [dbo].[BitTest] ( [insertdate] [datetime] NULL CONSTRAINT [DF__BitTest__insertd__300F11AC] DEFAULT (getdate()), [a] [bit] NULL ) ON [PRIMARY] GOMy application runs this code:
INSERT dbo.BitTest
(
insertdate,
a
)
VALUES
(DEFAULT, 'true')
GO
See possible answers