Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!
Alter PROCEDURE [dbo].[UpdateSecEventsandSchedle] @ScheduleID int, @ScheduledSlotId int, @VideoItemID int, @ItemOrder int, @VideoStartTime datetime, @VideoEndTime datetime, @VideoLength datetime , @Userid int, @showid int, @SecEvent int, @SecEventText text AS BEGIN -- SET NOCOUNT ON added to prevent extra result sets from SET NOCOUNT ON; IF @ScheduleID > 0 BEGIN UPDATE SlotVideoItems SET VideoItemID = 0 where ScheduleID = 1099 INSERT INTO SlotVideoItemsevents ([ScheduleID] ,[ScheduledSlotId] ,[VideoItemID] ,[ItemOrder] ,[VideoStartTime] ,[VideoEndTime] ,[VideoLength] ,[Userid] ,[Showid] ,[SecEvent] ,[SecEventText] ) VALUES (@ScheduleID , @ScheduledSlotId , @VideoItemID , @ItemOrder , @VideoStartTime , @VideoEndTime , @VideoLength , @Userid, @showid, @SecEvent, @SecEventText ) END END
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
|SQL Server Extended Events: list of deadlocks growing too long - how to cleanup?||23||65|
|Where clause to fliter varchar with Characters||12||59|
|I have an unknown large SQL database I want to get rid of||10||47|
|How do I find out to see if there is any open transaction in DB2 database ?||2||33|
Join the community of 500,000 technology professionals and ask your questions.