SQL Management studio shortcuts

-

SQL Server Management Studio  shortcuts


At the following video you can see some shortcuts for writing faster and more efficient SQL queries, at Synapse or SQL Database.

Environment 

SQL Server  2019 Developer Edition.
SQL Server Management Studio v18.10

You can download the client from the following 🔗  SQL Server Management Studio  🠟 .



Σχόλια

Δημοσίευση σχολίου

Δημοφιλείς αναρτήσεις από αυτό το ιστολόγιο

Calendar table on Vertica DB

-
Εικόνα
Calendar Table In this post we will describe how can we create a calendar table on Vertica db using Timeseries analytics. TIMESERIES Clause Provides gap-filling and interpolation (GFI) computation, an important component of time series analytics computation. More information you can find on  timeseries info . Our query consists of 3 parts in order to have all the necessary fields. CREATE TABLE IF NOT EXISTS calendar AS 👉    SELECT ROW_NUMBER() over(partition by 1) AS id   , tmp.* FROM ( 👉     SELECT  slice_time                                                   AS  actual_timestamp,                      CAST(slice_time AS DATE)                      ...
Διαβάστε περισσότερα