How to get current system date time in SQL Server?
SQL SERVER – 2008 – Find Current System Date Time and Time Offset
If you want to find current datetime in SQL Server I suggest to read the following post : SQL SERVER – Retrieve Current Date Time in SQL Server CURRENT_TIMESTAMP, GETDATE(), {fn NOW()} This post is related to new feature available in SQL Server 2008. In SQL Server 2008 there is…
Read MoreSQLAuthority News – Author BirthDay – SQL Server Birthday
It always suprise me how many people remember my birthday and take time from their busy life to call me, email me, wish me or send me their warm greetings. I would like to express my gratitude to them. Today is my birthday and I had decided to take a…
Read MoreSQL SERVER – SQL SERVER – Simple Example of Recursive CTE – Part 2 – MAXRECURSION – Prevent CTE Infinite Loop
Yesterday I wrote about SQL SERVER – SQL SERVER – Simple Example of Recursive CTE. I right away received email from regular reader John Mildred that if I can prevent infinite recursion of CTE. Sure! recursion can be limited. Use the option of MAXRECURSION. USE AdventureWorks GO WITH Emp_CTE AS…
Read MoreSQL SERVER – Simple Example of Recursive CTE
Recursive is the process in which the query executes itself. It is used to get results based on the output of base query. We can use CTE as Recursive CTE (Common Table Expression). You can read my previous articles about CTE by searching at http://search.SQLAuthority.com . Here, the result of…
Read MoreSQL SERVER – mssqlsystemresource – Resource Database
Just a day ago I received following email “Dear Pinal, While I was exploring my computer in directory C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data I have found database mssqlsystemresource. What is mssqlsystemresource? Thanks, Joseph Kazeka” Simple question like this are very interesting. mssqlsystemresource is Resource Database. It is read only database and…
Read MoreSQLAuthority News – Readers Selection – Readers Most Favorite Articles
I have been receiving many emails from my readers about their favorite article. Few days ago, I asked in one of my post SQLAuthority News – Updated My Personal Book Mark Pages, which articles are most favorite articles of my readers. I have received tremendous response to my question and…
Read More