Database

DECLARE @SomeLongName VARCHAR(100) 
SET @SomeLongName = 'Some long text'        
CREATE TABLE #temp
(
	someCode VARCHAR(500)
)                
DECLARE @Sql VARCHAR(1000) 
SET @Sql = 'INSERT into #temp SELECT MAX(SomeCode) FROM MyTable WHERE [Name] LIKE ' +
    
    CHAR(39) + LEFT(REPLACE(@SomeLongName, ' ', ''), 3) + ' %' + CHAR(39) + 
    ' select * from #temp drop table #temp'

EXEC (@Sql)

DECLARE @SomeLongName VarChar(100) = 'Some long text'    
               
    DECLARE @Sql VarChar(1000) 
    SET @Sql='DECLARE @temp TABLE( someCode VarChar(10) )' 
	SET @Sql=@Sql+
            'INSERT @temp SELECT MAX(SomeCode) ' +
            'FROM MyTable ' +
            'WHERE [Name] LIKE''' + LEFT(REPLACE( @SomeLongName, ' ', ''), 3) + '%'''
               
    EXEC (@Sql)

select distinct col1 from mytable
union all 
select distinct col2 from mytable
union all 
select distinct col3 from mytable

SELECT Col1,Col2,Col3, COUNT(*) as DuplicateCount
FROM MyTable
GROUP BY Col1,Col2,Col3
ORDER BY DuplicateCount DESC

SELECT Col1,Col2,Col3, COUNT(*) as DuplicateCount
FROM MyTable
GROUP BY Col1,Col2,Col3
HAVING COUNT(*)>1

insert into newscheme.dbo.mytable
  select * from oldscheme.dbo.mytable

DECLARE @InputValue INT
SET @InputValue=3

DECLARE @PrintValue INT
SET @PrintValue=1



WHILE @InputValue > 0 
BEGIN
	  
		PRINT @PrintValue
		SET @PrintValue=@PrintValue+1
		SET @InputValue=@InputValue-1
END