.net resources
Thursday, 12 August 2010
SQL Server timestamp
›
Getting timestamp as yyyymmddhhmmSSsss DECLARE @sTime VARCHAR(255) SET @sTime=REPLACE(REPLACE(REPLACE(REPLACE(CONVERT(VARCHAR(23), GETDATE()...
Monday, 24 May 2010
How to attach a SQL Server database (.mdf file) with a missing log (.ldf) file.
›
Sometimes we receive .mdf file only no log file. If we use Attach command it gives error (something like "no log file found ") We ...
Monday, 26 April 2010
Delimited Text file To DataSet
›
Imports System Imports System.Data Imports System.IO Public Class TextToDataSet Public Sub New() End Sub ''' ...
Friday, 23 April 2010
›
Stored Procedure to search a string in 1. Tables like 2. In Columns (upto 9) CREATEPROCEDURE [dbo].[zz_spSearchForValueInColumns_And_TablesL...
Tuesday, 13 January 2009
Web Site Accessibility XHTML Validation
›
Web Site Accessibility: Guidelines http://www.w3.org/TR/WCAG10/full-checklist.html PDF version: http://www.w3.org/TR/WCAG10/checkpoint-list....
Thursday, 23 October 2008
extract email address from a string
›
Little quirky but worked fine. below call will return email address. dim email=getEmailAddress('Aslam M Iqbal , new read watson st, asla...
simple search for column name all tables in db
›
select * from information_schema.columns where column_name like '%column_name%'
›
Home
View web version