Function for Sorting in Sql

CREATE FUNCTION GetSortSql ( @SortBy nvarchar(100), @SortAscending BIT, @Default nvarchar(100) ) RETURNS nvarchar(max) AS BEGIN DECLARE @sortSql nvarchar(max) SET @sortSql = '' IF @SortBy = '' SET @SortBy = @Default…

Query to concatenate two column or row values in sql

1. Query to concatenate two column SELECT (CAST(Name1 AS varchar(50))+' '+CAST(Name2 AS varchar(50))) AS AliasName FROM Table Ex: SELECT  (CAST(FirstName AS varchar(50))+' '+CAST(LastName AS varchar(50))) AS Name FROM Table   1. Query to concatenate two row DECLARE @text NVARCHAR(MAX) SELECT @text= COALESCE(@text+ ',', '') + Name FROM Table //Name:Field Name SELECT UserNames = @name

Syntax for rename table or column name in sql

Syntax to rename column name in table SP_RENAME 'TableName.[OldColumnName]' , '[NewColumnName]', 'COLUMN' Ex: SP_RENAME 'UserInformation.[Name]' , '[ReName]', 'COLUMN' Syntax to rename table name SP_RENAME '[OldTableName]' , '[NewTableName]' Ex: SP_RENAME '[Name]' , '[ReName]'