#Sql

1️⃣ Functions in #SQL (User Defined Functions – UDF).
They are persistent objects in the database that encapsulate logic and return a result.

• Scalars → a single value (INT, DECIMAL, NVARCHAR, etc.)
• Table → a set of rows (such as a parameterized view).

They should not modify data in SQL Server (they cannot do INSERT, UPDATE, DELETE).

They are used within queries (SELECT, WHERE, FROM).

Latitude's new AI-powered SQL Assistant uses GPT-3 to generate SQL in real time, helping teams explore and analyze data much faster. Connect multiple sources, run queries, and visualize results all in minutes. Good stuff https://latitude.so/

#SQL #AI #GPT3 #Analytics #DataTools