Our focus is to deploy our ASP.Net MVC app built using new Visual Studio 2015 MVC template to AppHarbor via GitHub.
When working with MS SQL Server sometimes you need to find a stored procedure in the databases and all that you know is the name of the stored procedure that your teammate told you that he had used but couldn't remember in which database it was. All the information about the stored procedures created is saved in the … Continue reading How to Find a Stored Procedure in all the Databases?
Few days back I came across a requirement to fetch the records from the table having all lowercase letters. This was interesting scenario. The SQL Server database by default is set for case-insensitive. But, I need to do case-sensitive search. Case sensitive search in SQL Server can be achieved in two ways. Either by using COLLATE or by using BINARY_CHECKSUM(). COLLATE is the T-SQL clause … Continue reading Searching Lowercase data in MS SQL Server