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

Comments

Post a Comment

Popular posts from this blog

Time Example

 SELECT distinct td.[CandidateID] ,pc.Description AS Province ,Year(td.Start) ,Day(td.Start) ,cast(td.[Start] as time) [time] ,cast(td.[End] as time) [time]   FROM [hjklhj].[dbo].[TimesheetDetail] AS td      INNER JOIN [jkljkh].[dbo].[Candidate] AS cd on td.CandidateID = cd.CandidateID   INNER JOIN [hjlhhhj].[dbo].[Province] AS pc on cd.ProvinceID = pc.Id   WHERE pc.Description = 'CB070000-CPT'    AND Year(Start) = '2021'   AND Month(Start) = '01'
Read more

SET IDENTITY_INSERT

Image
  SET IDENTITY_INSERT (Transact-SQL) Article 01/30/2021 2 minutes to read 14 contributors Applies to:   SQL Server (all supported versions)  Azure SQL Database  Azure SQL Managed Instance  Azure Synapse Analytics Allows explicit values to be inserted into the identity column of a table.   Transact-SQL Syntax Conventions Syntax syntaxsql SET IDENTITY _ INSERT [ [ database_name . ] schema_name . ] table_name { ON | OFF }
Read more