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)
-
▼
February
(15)
- SQL_VARIANT datatype and behaviour changes
- SQL Server Conference in Italy
- Madison and SSAS?
- Updated Wiki: HowToUseCodePlex
- New Comment on "HowToUseCodePlex"
- Find Alphanumerals only
- Implementing Real Analysis Services DrillDown in a...
- SQLBits IV Registration Open!
- PASS European Conference 2009 and Analysis Service...
- SQLBits IV voting now open
- Speeding up the Query Parameters Dialog in the SSR...
- Fact dimension relationships
- Updated Wiki: Home
- Updated Wiki: Home
- Updated Wiki: Home
-
▼
February
(15)