SQL Formatting Data

DATE EXAMPLE: FORMAT(cd.DateOfBirth, 'yyyy-MM-dd')

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