Question: How to Round Up or Round Down Number in SQL Server?
SQL SERVER – Alternate to AGENT_DATETIME Function
Sometimes back I posted about interesting function AGENT_DATETIME functions which will convert integers into datetime values. Someone commented that there might be some permission issues using this function which is only available in msdb database. So I write this post to give you alternate method without using any such functions.
Why SELECT HOST_NAME() Returns Empty String? – Interview Question of the Week #119
Question: Why SELECT HOST_NAME() Returns Empty String while connected from certain .net application?
What is the Difference between TRUNCATE and DELETE in SQL Server? – Interview Question of the Week #118
Question: What is the Difference between TRUNCATE and DELETE in SQL Server?
How to Get Random Records from Table? – Interview Question of the Week #105
Question: How to Get Random Records from Table?
How to Find Number of Times Function Called in SQL Server? – Interview Question of the Week #104
Question: How to Find Number of Times Function Called in SQL Server?
SQL SERVER – CREATE OR ALTER Supported in Service Pack 1 of SQL Server 2016
There are many enhancements which were introduced in Service Pack 1 of SQL Server 2016. If you are a developer, then you can easily understand this productivity improvement. Does below code looks familiar to you? Let us learn about CREATE OR ALTER Supported in Service Pack 1 of SQL Server 2016.