Temporary Table and Table Variables in SQL Server
Temporary Table The following code demonstrates how to create a temporary table.Syntax : [code:sql] CREATE TABLE #TempEmployee(employeeID int,employeeName varchar(100));[/code] This table is automatically dropped…
Coldfusion Wrapper for jquery Autocomplete
For one of my project I required autocomplete box. I know coldfusion has its own autocomplete but has lots of limitation. I wanted autocomplete…
Virtual Fix Table Header JQuery
There are so many ways to fix table header. We can fix table header row and rest of content of table will have overflow…
Visitor’s Browser Window Display Area
To know the available display area in a visitors browser excluding the pixels occupied by the toolbars and other add-ons on the users browser…
List All Databases, Objects, Tables by A Simple Single Line Query.
Try below query and see all databases and objects get listed in sql server. [code:sql]sp_msforeachdb ‘select "?" AS db, * from [?].sys.tables’;[/code]
SQL Server Read Excel Sheet
Today we had a requirement to insert data into database from excel sheet. I used POI Utility to read data from excel sheet and…
Clear Values of All Form Elements Using jQuery
I always wanted to have one common function to reset all form elements. Please have a look at jQuery code that does the same…
Correct Method to check if a Javascript function is Exists or not
Hi everyone, Sometime you might want to call a function in Javascript but check whether the function exists or not before calling it. You…
ColdFusion And AJAX File Upload
I have created simple jquery plugin for file upload. I have used multiple file upload in Ajax but it’s not possible to upload file…
MsSQL – Copy Data from One Table to Another Existing Table
Today, there was a need to insert data from one table to another table. There are many ways to insert data from one to…
Random Salt Password Encryption
Random Salt Password Encryption Technique[code:js]/* Client Side */function encryptPassword(){var salt = #session.salt#;var passField = document.getElementById(‘txtPassword’);// Submit this password value while submitting form.return md5(md5(passField.value) +…
Find Longest Executing Queries in SQL Server (2005,2008)
I have been working with queries today and wanted to find some queries which was very high on its execution time. There was a…