Sometimes when you import data from other system, you may need to clean the data by removing unwanted data. Consider you import data where you want to keep only those which are purely alphanumerals. Here is a way to find out declare @table table ( data...(read more)
A
New
Internet
Library: Add Your Website/Blog
or Suggest A Website/Blog to our Free Web Directory
http://anil.myfunda.net.
Its very simple, free and SEO Friendly. Submit Now....
Its very simple, free and SEO Friendly. Submit Now....
Blog Archive
-
▼
2009
(102)
-
▼
March
(23)
- Filling random passwords - Set based approach
- SQLBits IV
- SQL Solutions OLAP Heartbeat and OLAP Performance ...
- Splitting delimited data to columns - Set based ap...
- Return TOP N rows
- Export to EXCEL with column names
- SQL_VARIANT_PROPERTY function
- Time Calculation on Numbers
- Row_number() Function with no specific order
- Script of DDL triggers
- NULL on joined columns
- Happy New Year
- Compatibility Level of a database
- Find Alphanumerals only
- SQL_VARIANT datatype and behaviour changes
- Beware of the Usage of SET ROWCOUNT
- Which columns uniquely identify a row?
- Behavior Changes to Database Engine Features in SQ...
- BI Survey 8
- Query behaviour when you cross the LowMemoryLimit
- Analysis Services and the System File Cache
- Updated Wiki: Home
- Updated Wiki: Home
-
▼
March
(23)