MS SQL Server

Combine Two Column in One - TSQL Query



Select S1, S2 ,

Isnull(S1,'') + Isnull(S2,'') as State

From State


Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest
Labels: Advance T-SQL Query
Newer Post Older Post Home

Blog Archive

  • ►  2016 (12)
    • ►  October (1)
    • ►  September (1)
    • ►  July (2)
    • ►  June (4)
    • ►  March (2)
    • ►  February (2)
  • ▼  2015 (24)
    • ►  November (1)
    • ►  October (1)
    • ►  August (3)
    • ►  July (4)
    • ▼  June (5)
      • Add Calculated Column Age
      • Trim Leading (First) Charcter - TSQL Query
      • Combine Two Column in One - TSQL Query
      • Split One Column to Three Column - SQL Query
      • Split One Column to 2 column - SQL Query
    • ►  April (10)

Popular Posts

  • SSRS Expression to convert Second to Hours
    Following Expression in SSRS will convert Second to Hours Minutes Second Format HH : MM : SS   =Floor(sum(Fields!Second.Value)/ 3600)...
  • Find Non Integer From SQL Column
    If you want to find Non-Integer from Column in SQL Server  that does not have Data Type integer , Use following SQL Query. Select *  Fr...
  • Add Default Constraint GetDate() to Existing Column
    Add constraint default getdate to existing column Alter table [dbo].[Child] Add Constraint DF_Last Default Getdate() For [LastUpdate]...
  • Phone Constraint in SQL
    To Add Constraint to Any SQL Table Phone Column use following Script.  ALTER TABLE [dbo].[Employee]   WITH CHECK ADD  CONSTRAINT [Ck_Pho...
  • In Built Function in T-SQL - Reverse
    Reverse - Returns the reverse of a character expression. REVERSE( character_expression ) For Eg. Select CompanyName , Reverse ( Co...
  • List all Default Constraints in Table
    Find Default Constraints with Default to in Particular Table in Database. SELECT       c . name AS ColumnName ,     d . n...
  • User Define Function When LTrim and RTrim not Working
    Ltrim and RTrim not always Working to remove white space from column because of the special character at end. It may be because user try to ...
  • In Built Function in T-SQL - Upper and Lower
    Upper - Returns a character expression with lowercase character data converted to uppercase. Lower  -   Returns a character expression afte...
  • Trim Leading (First) Charcter - TSQL Query
    Trim Leading (First) Character in T-SQL Query  using Left, Right, Len Function   Select N, LEFT(RIGHT(N, len(N)-1),len(N)-1) as Number F...
  • Find / Remove Duplicate From Table T-SQL Query
    Find Duplicate Record Query Select        MemberID,        Name,     ...

Followers

Powered by Blogger.