# HG changeset patch
# User Oleksandr Gavenko <gavenkoa@gmail.com>
# Date 1676843995 -7200
# Node ID e023a7bbaf3b727919d5b75bdb8f93f8735ee0d6
# Parent  42551ca22ca35257a4cbe26a00f1686725e91f0f
Finding expression type.

diff -r 42551ca22ca3 -r e023a7bbaf3b sqlserver.rst
--- a/sqlserver.rst	Mon Feb 13 14:31:41 2023 +0200
+++ b/sqlserver.rst	Sun Feb 19 23:59:55 2023 +0200
@@ -13,6 +13,7 @@
   SELECT * FROM sys.tables;
   SELECT * FROM sys.views;
   SELECT * FROM sys.indexes;
+  SELECT * FROM sys.types;
 
   SELECT * FROM information_schema.tables;
 
@@ -34,3 +35,20 @@
 
   SELECT name, description FROM sys.fn_helpcollations();
 
+Finding expression type
+=======================
+
+::
+
+  SELECT SQL_VARIANT_PROPERTY(current_timestamp, 'BaseType');
+  SELECT SQL_VARIANT_PROPERTY(current_timestamp, 'Precision');
+  SELECT SQL_VARIANT_PROPERTY(current_timestamp, 'Scale');
+  SELECT SQL_VARIANT_PROPERTY(current_timestamp, 'MaxLength');
+
+Number of bytes required to hold both the metadata and data of the value::
+
+  SELECT SQL_VARIANT_PROPERTY(current_timestamp, 'TotalBytes');
+
+https://learn.microsoft.com/en-us/sql/t-sql/functions/sql-variant-property-transact-sql
+  SQL_VARIANT_PROPERTY (Transact-SQL).
+