1)  declare @string varchar(100)='ab,cd,ef,'  set  @string=  reverse (stuff(reverse(@string), 1, 1, ''))  print @string 2) declare @string...

Just look at the below queries A : declare @t table(id int, data1 int, data2 int) declare @b table(id int, value1 int, value2 int) insert into @t(id,...

-------Merge---- --select * from city --now lets try to insert a new id...Let's do it by stored procedure alter procedure insertproc @id...

select * from employee id   value 23  100 24  200 25  300 26  300 27  300 28  400 29  500 30  500 select...

1) Union key -- Creates non clustered index by default.                      -- Can be set as...

ACTUAL DATA  ALTER FUNCTION [dbo].[fn_Split_month] (        @Data varchar(max) )  RETURNS varchar(30) AS ...

YOU CANNOT USE TEMPORARY TABLE IN FUNCTION: èI create a temporary table. And I was using that temporary table in function. I couldn’t use it. Then...