GL SOFT INDIA
Fusion of Web, Mobile & Desktop Applications.
Showing posts with label
sql 2005
.
Show all posts
Showing posts with label
sql 2005
.
Show all posts
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...
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...
›
Home
View web version