From: anton.txt@g{oogle}mail.com   
      
   Erland Sommarskog to Anton Shepelev:   
      
   > > For efficient querying and joining, I need a covering   
   > > index on the [moment] field that includes [value], but   
   > > the INCLUDE keyword does not seem to be suported:   
   >   
   > Starting with SQL 2019, it is:   
   >   
   > CREATE TYPE series_t AS TABLE   
   >   (  moment DATETIME NOT NULL,   
   >      value  FLOAT,   
   >      INDEX Main(moment)   
   >      INCLUDE (value)   
   >   )   
      
   Glad to know MSSQL is improving, although I am using an   
   older version.   
      
   > If you are an older version, I would suggest adding value   
   > as an index key is the best in most situations.   
      
   Indeed.  That's that I did.   
      
   > I will submit an edit to the CREATE TYPE topic.   
      
   Thank you.  I myself have fixed a few of their documentation   
   articles about .NET, including those describing the   
   connection-string syntax.  How strange that Microsoft has   
   decidied to let the community wrote their documentation...   
      
   --   
   ()  ascii ribbon campaign -- against html e-mail   
   /\  www.asciiribbon.org   -- against proprietary attachments   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)