|
|
-
Yogesh Kamble Liked 1 Years ago through Just Learned
In this very short tip I'd like to share my solution to a yesterday quesiton in MSDN forum - how to find the database the table belongs to. I use my favorite idea of dynamically constructing a query using INFORMATION_SCHEMA.TABLES view.
[code]
DECLA...
|
-
Yogesh Kamble Liked 1 Years ago through Just Learned
In this very short tip I'd like to share my solution to a yesterday quesiton in MSDN forum - how to find the database the table belongs to. I use my favorite idea of dynamically constructing a query using INFORMATION_SCHEMA.TABLES view.
[code]
DECLA...
|
-
Yogesh Kamble Liked 1 Years ago through Just Learned
Recently couple of times, I have a requirement of showing execution time to the users. Both times, I followed the approach of taking a starttime variable and stop time variable and calculating difference between those variables.
Today I saw an MSDN b...
|
-
Yogesh Kamble knew 1 Years ago through Just Learned
Recently couple of times, I have a requirement of showing execution time to the users. Both times, I followed the approach of taking a starttime variable and stop time variable and calculating difference between those variables.
Today I saw an MSDN b...
|
-
Yogesh Kamble Liked 1 Years ago through Just Learned
Recently couple of times, I have a requirement of showing execution time to the users. Both times, I followed the approach of taking a starttime variable and stop time variable and calculating difference between those variables.
Today I saw an MSDN b...
|
-
Yogesh Kamble knew 1 Years ago through Just Learned
Recently couple of times, I have a requirement of showing execution time to the users. Both times, I followed the approach of taking a starttime variable and stop time variable and calculating difference between those variables.
Today I saw an MSDN b...
|
-
Yogesh Kamble Liked 1 Years ago through Just Learned
SET PARSEONLY ON Examines the syntax of each Transact-SQL statement and returns any error messages without compiling or executing the statement.
[code]
SET PARSEONLY { ON | OFF }
[/code]
When SET PARSEONLY is ON, SQL Server only parses the stateme...
|
-
Yogesh Kamble Liked 1 Years ago through Just Learned
SET PARSEONLY ON Examines the syntax of each Transact-SQL statement and returns any error messages without compiling or executing the statement.
[code]
SET PARSEONLY { ON | OFF }
[/code]
When SET PARSEONLY is ON, SQL Server only parses the stateme...
|
-
Yogesh Kamble Liked 1 Years ago through Just Learned
While working on my recent project I need to avoid CASE WHEN in few cases so, I derived an alternate way and in this post I am going to demonstrate that.
To execute the demonstration, take a look at the following example.
SELECT CustomerName,Ad...
|
-
Yogesh Kamble knew 1 Years ago through Just Learned
While working on my recent project I need to avoid CASE WHEN in few cases so, I derived an alternate way and in this post I am going to demonstrate that.
To execute the demonstration, take a look at the following example.
SELECT CustomerName,Ad...
|