What is difference between STUFF and REPLACE in SQL Server?...

In SQL forums, one of the memebers asked this question. "In the table a varchar column has values like '2.2020 30 4.0000', '2.20200 30 4.00', etc. When I pass a parameter with the value '2.202 30 4.0' , the above value should be returned as output. How ...

Consider the following two statements --Query 1 select name, dateadd(day,datediff(day,0,create_date),0) as date_only from sys.objects where date_only>getdate()-100 --Query 2 select name, dateadd(day,datediff(day,0,create_date),0) as...

ManagementStudio & Visual Studio: press [Ctrl+KC] to comment code (works also on selected lines), but comment out only whole lines. press [Ctrl+KU] to uncomment code (works also on selected lines), but comment out only whole lines. but for VS, at HT...

Few hours before I was checking the special features, fixes, and builds of MS SQL Server. I got a great blog...So interesting....This contains unofficial build chart lists all of the known KB articles, hotfixes and other builds of MS SQL Server 2012, 20...

My editor just notified me that the book is ready to move to copy editing early next week....

Recently i received a question in SQL Server, "Which is faster Union or Union All?"...

I just learn from mvc tutorial That we can comment code in Razor view engine also This is syntax for comment code Single line @* single line comment. *@ Multiline @* Line1 Line2 Line3 *@ Thank You...

AWE (address windowing support) is no longer available for SQL Server 2012. Today, I attempt to highlight the requirements & behaviour around 64-bit editions of SQL Server/operating systems....

Which TCP/IP port does SQL Server run on?...