GL SOFT INDIA

Fusion of Web, Mobile & Desktop Applications.

Friday, January 15, 2010

Import from Excel Sheet into Sql Table with filtering

›
SELECT * FROM OPENROWSET('Microsoft.Jet.OLEDB.4.0', 'Excel 8.0;Database=C:\Data.xls', 'S...
Monday, June 15, 2009

SQL FUNCTION ExtractNumbers

›
SQL FUNCTION ExtractNumbers Create Function ExtractNumbers ( @str_passed varchar(max) ) Returns varchar(50) AS BEGIN     declare @val varch...
Thursday, May 21, 2009

RupeeMail

›
Invitation to join   Rupee Mail! Hi , I have something interesting for you, RupeeMail! It’s really amazing! You get paid to open & read ...
Monday, February 9, 2009

Scalar User Defined Functions and Computed Columns

›
Scalar User Defined Functions and Computed Columns Came across an interesting SQL problem where a customer has a table with a primary key an...

Scalar User Defined Functions and Computed Columns

›
Scalar User Defined Functions and Computed Columns Came across an interesting SQL problem where a customer has a table with a primary key an...
Wednesday, February 4, 2009

Javascript - Compare two Dates

›
Javascript - Compare two Dates function CompareDates() { var txtEffDt = document.getElementById("txtEffectiveDt").valu...
Tuesday, February 3, 2009

Javascript - Convert Number to words

›
Javascript - Convert Number to words link the script into the head of your page using the following code: The final step is to cal...
‹
›
Home
View web version

About Me

ss02
View my complete profile
Powered by Blogger.