Towards tech
Uncategorized
SQL Server : Finding row with special characters
02 weeks ago
by Rishi
in Uncategorized
Recently I had an requirement in which I need to get all the rows which has the special characters. I wrote the below query, please let me know if that works. Also tip me if there are any other solutions
SELECT
Col1,
Col2
FROM
testtable
WHERE
col2 LIKE '%[^0-9a-zA-Z ]%'
Please try and let me know if it works for all.
Rishi
Related Posts:
Siri rival Google Now comes to iPhone and iPad
3 weeks ago
by Rishi
in Uncategorized
Google’s most awaited Google Now is finally arrived for iPhone and iPad users today which offers completely new way to get information as it required.
For iPhone users if you already have installed Google Search App than you will get the update and user have to just update it. And for those who have not installed Google Search than search in App Store and install the app with which user will also get latest Google Now.
Google Now presents information through a series of flip-through cards which are visible once you open the app and each card represents different information. When I installed one of the card information was my train schedule for my office, to my surprise was correct. I have just updated the app and it correctly recognized where I go for work.
There are some missing Google Now cards compared to which are available in Android and which I am expecting to be added soon.
User can download the app from Apple App Store as a part of Google Search. The latest version of Google Search app also contains enhanced voice search with text streamed on the fly as well as faster results according to Huey’s post.
Related Posts:
Windows 8 tip: Skip Password screen during boot process
1 month ago
by Rishi
in Uncategorized
Many windows users are not of habit to insert password every time PC is booted. So to avoid the password screen every time you start the Windows 8 follow the below steps.
- Go to Windows Start Screen
-
Type “netplwiz”, click/tap the application.
- Uncheck the checkbox “Users must enter a user name and password to use this computer”.
- Click OK button to save the changes.
- Next time when Windows 8 is booted it won’t ask for any password.
Hope you all like this tip.
Rishi
Related Posts:
Registration for Google I/O is now open
2 months ago
by Rishi
in Uncategorized
Google has started accepting the registration for its annual Developer conference i.e. Google I/O.
For student and academic community the sign fee is $300 and all other attendees have to pay thrice the price i.e. $900. Conference venue is at Moscone Center, San Francisco from May 15-17 2013 and will have mix of keynotes, technical sessions, code labs and news related to Google products and services.
Interested user can buy else will sell out in a day.
Related Posts:
Ubuntu Phone OS announced [Video]
4 months ago
by Rishi
in Uncategorized
There was quite a bit excitement about Ubuntu as there was a special announcement today at 8AM ET. There were some rumors regarding touch-based operating system, but today they announced its new smartphone OS i.e. Ubuntu Phone OS.
Ubuntu is very well the best Linux OS in the market and enjoys the largest market within the Linux. And since it’s a open-source user gets chance to enjoy various variant of Ubuntu. So it was really great to see Ubuntu coming in the smartphone market.
Launched a while back, and demonstrated by Canonical / Ubuntu founder Mark Shuttleworth in a dedicated event, and from the video which I had seen OS is definitely very impressive. At this point; no smartphone manufacturers have signed up to run with Ubuntu, and Shuttleworth also adds that an Ubuntu-toting handset is still the best part of a year away.
Particularly UI looks very impressive and its very clean and simple, and looks very promising in the early stage. And now with Ubuntu Phone OS smartphone market will be very competitive and since Ubuntu phone is open-source it might give tough competition to Android.
