|
|
-
Alpesh Patel learned 5 Months ago through Blogs
In this post, we see that temporary tables allow the use of only 116 characters out of a possible 128. How are temporary tables named, and what happens to the restricted length of 12 characters? What is the naming logic for temporary tables?...
|
|
|
-
Alpesh Patel Liked 5 Months ago through Blogs
If you reference URLs to TFS defects/work items/enhancements, a Sharepoint page or a blog citation in your T-SQL code, ensure that the "Enable single-click URL navigation" switch is checked so that you can navigate to the URL via a simple key & mouse cl...
|
-
Alpesh Patel Liked 5 Months ago through Blogs
In this post, I walk you through how to restore broken file associations using the SQL Server Management Studio (SSMS) for SQL 2012....
|
-
Alpesh Patel Liked 5 Months ago through Blogs
What do you do when you need help on a DBCC command without using the Books On Line? You can use the DBCC HELP command to get syntax/parameter related help for the documented DBCC commands....
|
|
|
|
|
|
|
-
Alpesh Patel Liked 6 Months ago through Blogs
How can connection strings be used to change the behaviour of an application? In this post, we explore the use of the system function APP_NAME(), which returns the application name for the current session if set by the application....
|
-
Alpesh Patel Liked 6 Months ago through Blogs
I experienced in issue with SELECT while used for variable assignment with in the stored procedures. I have captured that moment and had post for the same. Here i want to give you some demo for the SELECT and SET using with variable assignment. Below ar...
|