Database

date (Transact-SQL) - SQL Server | Microsoft Docs[^]

Storage size: 3 bytes, fixed

Mike Ahrens wrote:

Snowflake Azure database system

Mike Ahrens wrote:

Just wanted to see if there was anyone else using it

Mike Ahrens wrote:

If I hadn't figured it out, I would have posted a proper question.

Bastard Programmer from Hell
"If you just follow the bacon Eddy, wherever it leads you, then you won't have to think about politics." -- Some Bell.

CREATE OR ALTER FUNCTION dbo.fn_OrganizationJson(@ParentId int)
RETURNS nvarchar(max)
As
BEGIN
DECLARE @json nvarchar(max);
  
  If @ParentId Is Null
  BEGIN
    SET @json = (SELECT Id, Name, dbo.fn_OrganizationJson(Id) As Children FROM dbo.Organizations WHERE ParentId Is Null FOR JSON AUTO);
  END
  Else
  BEGIN
    SET @json = (SELECT Id, Name, dbo.fn_OrganizationJson(Id) As Children FROM dbo.Organizations WHERE ParentId = @ParentId FOR JSON AUTO);
  END
    
  Return @json;
END
GO

niksirat2030 wrote:

What programming language should I use for this task so that I can design a beautiful appearance (GUI) for entering information and this information can be entered easily by the user?