81 What is a view in sql server | Create view in SQL Server

[@user-df1kb7th3v]

Wonderful explanation as usual Aqil sir

[@learnssis]

Thank you Sir.

[@Chsurendra556]

Hi Aqil nice explanation. Please make a video on Execution plan in sql server.

[@learnssis]

Yeah, I will cover all topics in SQL server development. Stay tuned for more videos.

[@neelamkushwah1079]

Hlo sir interviewer asked me this question and say do this in store procedure (Create a table if it doesnt exist - details of employee table, designation - set 'higher management where sal>50LPA) please tell how to write query

[@learnssis]

Hi Neelam, this is the query for this. For these simple questions, you can use chatgpt as well. It can help you to write the sql queries for a very wide variety of requirements. create proc sp_UpdateDesignation as begin IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Employee]') AND type in (N'U')) CREATE TABLE [dbo].[Employee]( [id] [int] NULL, [first_name] [varchar](50) NULL, [last_name] [varchar](50) NULL, Salary money NULL, designation [varchar](50) NULL ) ON [PRIMARY] update [Employee] set designation = 'higher management' where Salary > 5000000 end

[@neelamkushwah1079]

@@learnssis ok thank you sir I will do it myself.

[@user-gq7of3bz8h]

Sir please make video on ssis pakage in vs code ..hiw it works

[@learnssis]

Sorry did not get you.