SQL – Rahul Satasia

Change Default Database in SQL Server Management Studio

imsatasia March 18, 2013 0 Comments

Change your login name and database name and Execute following SP: Exec sp_defaultdb @loginame='imsatasia\Rahul', @defdb='DBName' OR Go to "Object Explorer > Security > Logins" Right click your Login and click…

SQL

Format Phone Number – SQL Server Function

imsatasia October 10, 2012 0 Comments

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…

SQL Tutorials

Change Default Database in SQL Server Management Studio

Format Phone Number – SQL Server Function

You Missed

Change Default Database in SQL Server Management Studio

Format Phone Number – SQL Server Function

Download Bootcamp 4 – drivers for Windows 8 Consumer Preview

iPhone 5 – Are you getting one?