Logiclabz - blog.logiclabz.com
General Information:
Latest News:
Case-sensitive check/search/match in T-SQL - Sql Server 2005 30 Nov -0001 | 12:00 am
Generally, SQL Server is not case-sensitive i.e SQL Server doesn't check,search or matching the values with case. Though there are ways to make them case-sensitive using collation at various levels i...
Facebook Login Error - Oauth2 specification states that 'perms' should now be called 'scope' 30 Nov -0001 | 12:00 am
As of December 13th, 2011, the JavaScript SDK now only supports OAuth 2.0 for authentication. The ability to enable OAuth 2.0 in the JS SDK was first introduced in July. All apps were given until Octo...
Selecting Random Rows from a Table in SQL Server 30 Nov -0001 | 12:00 am
Selecting random row in a small table in sql server can be achived by NEWID() function with much affect in performance. NEWID() generates a globally unique identifier (GUID) in memory for each row. s...
T-SQL to find Procedures used in Sql Server Jobs 30 Nov -0001 | 12:00 am
It becomes difficult to find a procedure from the huge cluster of Jobs through SQL Server Management Studio. So below is the T-SQL that can list all the procedures and commands that are used in Sql S...
Auto resize textarea using Javascript 30 Nov -0001 | 12:00 am
When there is requirement to bind some text content on the textarea then it becomes almost mandatory to re-size the textarea height depending the lines of the text content embedded. This auto resizin...
Perfect URL Encode Function in JavaScript 30 Nov -0001 | 12:00 am
When an URL or any special characters is to be sent through as querystring (GET) parameter it is mandatory to encode those parameters. The URL encode can be done through javascript with 3 different op...
Schedule Sql Server Job to run every 30 Seconds 30 Nov -0001 | 12:00 am
I got to situation today to run a SQL Server Job every 30 Seconds (i.e less than a minute). When I saw the Job Scheduler settings in Sql Server Management Studio, the minimum frequency of execution is...
