Change your login name and database name and Execute following SP:
Exec sp_defaultdb @loginame='imsatasia\Rahul', @defdb='DBName'
OR
SELECT dbo.CMN_FmtPhone('1234567891011')
Output: (123) 456-7891 Ext: 011
SELECT dbo.CMN_FmtPhone('1234567820')
Output: (123) 456-7820
CREATE FUNCTION CMN_FmtPhone
(
@PhoneNumber varchar(15)
)
RETURNS varchar (15)
AS
BEGIN
Declare @returnValue as Varchar(15)
SELECT @returnValue =
CASE
WHEN LEN(LTRIM(RTRIM(@PhoneNumber))) = 10
THEN '(' + SUBSTRING(@PhoneNumber, 1, 3) + ')'
+ ' ' + SUBSTRING(@PhoneNumber, 4, 3)
+ '-' + SUBSTRING(@PhoneNumber, 7, 4)
WHEN LEN(LTRIM(RTRIM(@PhoneNumber))) > 10
THEN '(' + SUBSTRING(@PhoneNumber, 1, 3) + ')'
+ ' ' + SUBSTRING(@PhoneNumber, 4, 3) + '-'
+ SUBSTRING(@PhoneNumber, 7, 4)
+ ' Ext: ' + SUBSTRING(@PhoneNumber, 11, 5)
END
RETURN @returnValue;
END
Here is how you can download and install Macbook Pro Drivers on Windows 8 Consumer Preview or Windows 7:
Source: NASA, Boeing
Credit: Christina Baird, Adam Cole, Nelson Hsu, Allison Lenz and Andrew Prince / NPR
Follow the instructions to enable multi-touch gestures for iPhon 3GS, iPhone 4, iPod Touch and iPad:
We will be editing 3 plist files in this tutorial. To edit and find .plist files use following application for Windows machine or Mac:
