Developers still get errors calling stored procedures like functions. Here are two correct ways to pass parameters to the stored procedure, with an example.
How to Add Column at Specific Location in Table? – Interview Question of the Week #126
Question: How to Add Column at Specific Location in Table?
Answer: Order of the column in the table should not matter.
SQL SERVER – How to Install SSMS From Command Line? Error: The Specified Value for Setting ‘MEDIALAYOUT’ is Invalid.
How to install SSMS from command line? A client’s silent install failed: the specified value for setting MEDIALAYOUT is invalid. Here is the fix.
SQL SERVER – Unable to Change “Shared Feature Directory” Under Feature Selection
SQL Server 2014 setup would not let a reader change the Shared Feature Directory: the textbox and browse button were greyed out. The cause and the fix.
Why SELECT HOST_NAME() Returns Empty String? – Interview Question of the Week #119
Question: Why SELECT HOST_NAME() Returns Empty String while connected from certain .net application?
SQL SERVER – Management Studio Missing – SSMS 2014 not Installed with SQL Server 2014
SSMS 2014 not installed after a SQL Server 2014 setup? The Management Tools feature was never selected. Here is how the discovery report showed it.
SQL SERVER – DBCC SHRINKFILE: Page 1:26423878 Could not be Moved Because it is a Work Table Page – TempDB Files
Shrinking TempDB kept failing: DBCC SHRINKFILE said the page could not be moved because it is a work table page. Here is the workaround that helped.