Sql Server Interview Questions and Answers
1) SQL Server query to split the Field into 2 Column. This query the developer can use when the name consists of numeric value like Ram1, Ram2 SELECT Left(Lastname, 3) As characters, Right(Lastname, 1) As numbers FROM [Amatya].[dbo].[tblUsers] Note – First 3 Character will be… Continue reading