Hi Aqil nice explanation. Please make a video on Execution plan in sql server.
@learnssis4 ай бұрын
Yeah, I will cover all topics in SQL server development. Stay tuned for more videos.
@neelamkushwah10794 ай бұрын
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
@learnssis4 ай бұрын
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
@neelamkushwah10794 ай бұрын
@@learnssis ok thank you sir I will do it myself.
@user-gq7of3bz8h3 ай бұрын
Sir please make video on ssis pakage in vs code ..hiw it works