|
|
|
|
|
|
-
Nirav Gandhi Liked 10 Months ago through Syndicated Blogs
This blog about the practical solutions for the problems that SQL server DBA face in their day to day work...
|
-
Nirav Gandhi Liked 10 Months ago through Just Learned
Normally, people uses PARSENAME fuction to retrieve Server,Database,Owner and Object from four part query.
Here is another use of same to remove decimal points
SELECT PARSENAME('$12,345.00',2) -- $12,345...
|
-
Nirav Gandhi Learned 10 Months ago through Just Learned
Normally, people uses PARSENAME fuction to retrieve Server,Database,Owner and Object from four part query.
Here is another use of same to remove decimal points
SELECT PARSENAME('$12,345.00',2) -- $12,345...
|
-
Nirav Gandhi Liked 10 Months ago through Just Learned
Normally, people uses PARSENAME fuction to retrieve Server,Database,Owner and Object from four part query.
Here is another use of same to remove decimal points
SELECT PARSENAME('$12,345.00',2) -- $12,345...
|
-
Nirav Gandhi Learned 10 Months ago through Just Learned
Normally, people uses PARSENAME fuction to retrieve Server,Database,Owner and Object from four part query.
Here is another use of same to remove decimal points
SELECT PARSENAME('$12,345.00',2) -- $12,345...
|
-
Nirav Gandhi Liked 10 Months ago through Tutorials
In this chapter, we learn about the anatomy of a SQL Trace and how the SQL Server Profiler integrates into the SSMS, Query editor and the Activity Monitor....
|
-
Nirav Gandhi refreshed 10 Months ago through Blogs
One of the most common mistakes that all developers make is to pass parameters to a procedure based on the expected (ordinal) position and not the expected parameter name. Can you change the parameter sequence within your stored procedure without breaki...
|
|
|