ISNUMERIC (Transact-SQL)
Posted by Jayceooi
What is ISNUMERIC in Transact-SQL? It is used to determine that the value is numeric or not. It will return ’1′ when the value is numeric. Else it will return ’0′.Example,DECLARE @temp nvarchar(100);
SELECT @temp = ’100′;
SELECT ISNUMERIC(@temp);The returned result is ’1′.[...]
Continue ReadingSELECT @temp = ’100′;
SELECT ISNUMERIC(@temp);The returned result is ’1′.[...]
Table (NOLOCK) (Transact-SQL)
Posted by Jayceooi
What does Table (NOLOCK) in Transact-SQL mean? NOLOCK is equivalent to READUNCOMMITTED. It is mean that dirty reads are allowed. No shared locks are issued to prevent other transactions from modifying data read by the current transaction, and exclusive locks set by other transactions do not block the current transaction from reading the locked data.See SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED / READ COMMITTED / REPEATABLE READ / SNAPSHOT / SERIALIZABLE (Transact-SQL) too.[...]
Continue ReadingOne moment listen please
Posted by Jayceooi
The Moment you are in Tension
You will lose your Attention
Then you are in total Confusion
And you will feel Irritation
Then you will spoil personal Relation
Ultimately, you won’t get Co – Operation
Then you will make things Complication
Then your blood pressure may raise Caution
And you may have to take Medication
Instead, understand the Situation
And try to think about the Solution
Many problems will be solved by Discussion
This will work out better in your Profession
Don’t think it’s my free Suggestion
It’s only for your Prevention
If you understand my Intention
You will never come again to Tension- Bill Gates[...]
Continue ReadingYou will lose your Attention
Then you are in total Confusion
And you will feel Irritation
Then you will spoil personal Relation
Ultimately, you won’t get Co – Operation
Then you will make things Complication
Then your blood pressure may raise Caution
And you may have to take Medication
Instead, understand the Situation
And try to think about the Solution
Many problems will be solved by Discussion
This will work out better in your Profession
Don’t think it’s my free Suggestion
It’s only for your Prevention
If you understand my Intention
You will never come again to Tension- Bill Gates[...]
REPLACE (Transact-SQL)
Posted by Jayceooi
What is REPLACE in Transact-SQL? It will replace all occurrences of a specified string value with another string value.The REPLACE syntaxREPLACE (searchedString, foundString, replacedString)Example,SELECT REPLACE(‘abcdefghicde’,'cde’,'xxx’);
GOThe returned result is “abxxxfghixxx”. Basically, it replaced all the ‘cde’ with ‘xxx’.[...]
Continue ReadingGOThe returned result is “abxxxfghixxx”. Basically, it replaced all the ‘cde’ with ‘xxx’.[...]
LEN (Transact-SQL)
Posted by Jayceooi
What is LEN in Transact-SQL? It will returns the number of characters of the specified string expression, excluding trailing blanks.For example,DECLARE @temp varchar(60);
SET @temp = ‘ABCDEF ‘;
SELECT LEN(@temp);The returned result is ’6′. It returns the count of 6 characters “ABCDEF”.[...]
Continue ReadingSET @temp = ‘ABCDEF ‘;
SELECT LEN(@temp);The returned result is ’6′. It returns the count of 6 characters “ABCDEF”.[...]
The Cloud knock out Fast Connnect free Wi-Fi tool for iPhone/o2 customers
Posted by Wirefresh
If you’re an iPhone-toting o2 customer on the look out for free hotspots, Wi-Fi provider The Cloud has made the job a lot easier with the launch of their new...[...]
Continue ReadingLoveable Google Chrome videos show off Extensions and Translate features
Posted by Wirefresh
We’re growing to really like Google’s quirky and engaging promo videos, and two more gems have just been released that are well worth watching. The first one shows off some...[...]
Continue ReadingGoogle Maps Navigation 4.1.1 offers free satnav to UK Android phones
Posted by Wirefresh
Rather unexpectedly, UK Android owners have been gifted free turn-by-turn navigation with voice directions, courtesy of Google Maps Navigation. The 4.1.1 Beta app has now been released in the UK,�...[...]
Continue ReadingAsus EeeKeyboard PC finally up for pre-order in the US
Posted by Wirefresh
It’s been on its way for well over a year, but Asus’s intriguing EeeKeyboard is finally available for US customers to pre-order on Amazon, with shipping scheduled for the end...[...]
Continue ReadingBlackberry OS 6.0 screenshots emerge, BlackBerry 9670 unveiled
Posted by Wirefresh
An assemblage of screenshots and details about RIM�s upcoming Blackberry OS 6.0 platform and photos of the forthcoming BlackBerry 9670 clamshell handset have been leaked by tech site, The Boy...[...]
Continue Reading
No comments:
Post a Comment