SQL INDEX1

 ----------------------------------------------------------------------

 Use while 

CREATE TABLE Sales(
 ID INT IDENTITY(1,1)
,ProductCode VARCHAR(20)
,Price FLOAT(53)
,DateTransaction DATETIME);

------------------------------------------------

CREATE PROCEDURE InsertIntoSales
AS 
SET NOCOUNT ON
BEGIN
DECLARE @PC VARCHAR(20)='A12CB'
DECLARE @Price INT = 50
DECLARE @COUNT INT = 0
      WHILE @COUNT<200000
      BEGIN
      SET @PC=@PC+CAST(@COUNT AS VARCHAR(20))
      SET @Price=@Price+@COUNT
      INSERT INTO Sales VALUES (@PC,@Price,GETDATE())
      SET @PC='A12CB'
      SET @Price=50
      SET @COUNT+=1
      END
END
--------------------------------------
EXEC InsertIntoSales 

--------------STUFF-----------------------------------

SELECT STUFF('abcdef', 2, 3, 'ijklmn');
GO 

----------------------CHOOSE -------------------------------

CHOOSE ( index, val_1, val_2 [, val_n ] ) 

------------------------------------------------------------

SELECT CHOOSE ( 3, 'Manager', 'Director', 'Developer', 'Tester' ) AS Result;

-------------------------------------------------------------

USE AdventureWorks2012;
GO
SELECT ProductCategoryID, CHOOSE (ProductCategoryID, 'A','B','C','D','E') AS Expression1
FROM Production.ProductCategory; 

-----------------------Random--------------------------------------

DECLARE @counter smallint;
SET @counter = 1;
WHILE @counter <= 5
   BEGIN
      SELECT RAND() Random_Number
      SET @counter = @counter + 1
   END;
GO 

----------------------IIF-----------------------------------------------

IIF ( boolean_expression, true_value, false_value )

-----------------------------------------------------------------------

DECLARE @a int = 45, @b int = 40;
SELECT IIF ( @a > @b, 'TRUE', 'FALSE' ) AS Result;

--------------SIN-------------------------------------- 

SIN ( float_expression ) 

-----------------------------

DECLARE @angle float;
SET @angle = 45.175643;
SELECT 'The SIN of the angle is: ' + CONVERT(varchar,SIN(@angle));
GO

-------------UNICODE --------------------------

UNICODE ( 'ncharacter_expression' ) 

----------------------------------------

DECLARE @nstring nchar(12);
SET @nstring = N'Åkergatan 24';
SELECT UNICODE(@nstring), NCHAR(UNICODE(@nstring));