Why is the procedure not created?

Question

SQL Server

Answer 1

That's right, you can't be so perverted :-)
If you really want to, you can make a dynamic request and execute it via EXEC . More or less like this:

DECLARE @query AS nvarchar(1024);

SET @query = N'CREATE VIEW WomanAward AS 
SELECT * FROM [Сотрудники] 
WHERE [Пол] = ''Ж'' AND [Премия] BERWEEN 130 AND 210';

EXEC sp_executesql @query;
-- EXEC(@query);

But creating a view in a stored procedure is a very strange and crooked solution, at least in the form shown in the picture. In this case, the representation is not necessary.
- EXECUTE
- sp_executesql