Drastically shorten your training time with WalkMe's advanced online training solution that Guides your trainees to action. Forget about retraining and skyrocket knowledge retention rates.
CREATE TABLE [dbo].[appCompanyHolidays]( [CompanyHolidayID] [int] IDENTITY(1,1) NOT NULL, [EffectiveDate] [datetime] NOT NULL, CONSTRAINT [PK_appCompanyHolidays] PRIMARY KEY CLUSTERED ( [CompanyHolidayID] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] GO
declare @StartDate smallDateTime declare @EndDate smallDateTime set @StartDate = '2/7/2014 9:30 AM' set @endDate = '2/24/2014 8:30 AM' declare @startDay int declare @endday int declare @starttime time declare @endtime time select @startDay = 5, @endDay = 7, @starttime = '20:00', @endTime ='7:30' select @startDate startdate, @endDate enddate, @startday startDay, @endDay endDay, @startTime StartTime, @endTime endTime
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
|SQL syntax for max(date)||3||37|
|SQLCMD question to have fields created as fixed length||2||36|
|I have an unknown large SQL database I want to get rid of||10||43|
|SQL - Subquery in WHERE section||4||32|
Join the community of 500,000 technology professionals and ask your questions.