|
|
-
5
Liked
|
2
Asked
|
1 Comments
|
|
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...
|
|
-
7
Liked
|
5
Learned
|
4 Comments
|
|
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...
|
|
-
9
Liked
|
7
Learned
|
1 Comments
|
|
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....
|
|
-
5
Liked
|
1
Asked
|
1 Comments
|
|
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....
|
|
-
5
Liked
|
1
Asked
|
5 Comments
|
|
Which TCP/IP port does SQL Server run on?...
|
|