Posts

Showing posts from December, 2019

MSSQL Example 3

 SELECT TOP 1000 [ClientVacancyID]       ,[DateOfVacancy]       ,[ShiftTypeID]       ,[CandidateCategoryID]       ,[QualificationID]       ,[ClientID]       ,[DepartmentID]       ,[CreatedUserID]       ,[Created]       ,[Note]       ,[ClientVacancyStatusID]       ,[Daily]       ,[Monthly]       ,[Prompt]   FROM [MedXStaff].[dbo].[ClientVacancy]   WHERE [DateOfVacancy] = '2006/06/21'
Post a Comment
Read more

MSSQL select example 2

SELECT TOP 1000 [ClientVacancyID]       ,[DateOfVacancy]       ,[ShiftTypeID]       ,[CandidateCategoryID]       ,[QualificationID]       ,[ClientID]       ,[DepartmentID]       ,[CreatedUserID]       ,[Created]       ,[Note]       ,[ClientVacancyStatusID]       ,[Daily]       ,[Monthly]       ,[Prompt]   FROM [MedXStaff].[dbo].[ClientVacancy]     WHERE [ClientVacancyID] = 9
Post a Comment
Read more