dz6

gistfile1.txt

-- 1
DECLARE @a SMALLINT = 1
DECLARE @b SMALLINT = 2
DECLARE @c SMALLINT = 3
PRINT (@a + @b + @c) / 3

-- 2
DECLARE @var SMALLINT = 123

PRINT LEN(CAST(@var AS VARCHAR))

-- 3
DECLARE @L SMALLINT = 30

PRINT REPLICATE('*',@L)

-- 4
DECLARE @time INT = DATEPART(HOUR,GETDATE())

IF @time >= 6 AND @time < 18
	PRINT 'Сейчас день'
ELSE
	PRINT 'Сейчас ночь'

-- 5
DECLARE @N INT = 15, @i INT = 0, @Password NVARCHAR(15) = '';

WHILE @i < @N
BEGIN
    SET @Password = @Password + CAST(FLOOR(1 + (10 - 1) * RAND()) AS NVARCHAR);
    SET @i += 1;
END

PRINT @Password;

=======================
-- 2
DECLARE @string NVARCHAR(50) = 'One two tree', @i INT = 0, @count INT = 0

WHILE @i < LEN(@string)
BEGIN
	IF SUBSTRING(@string, @i, 1) = ' '
		SET @count += 1
	SET @i += 1
END

PRINT @count