Useful tips for everyday
How do I grant rights to a SQL Server Agent? Using SQL Server Management Studio In Object Explorer, expand a server. Expand Security, and then…
How do I get metadata from Snowflake? Snowflake automatically generates metadata for files in internal (i.e. Snowflake) stages or external (Amazon S3, Google Cloud Storage,…
Is Min aggregate function in SQL? An aggregate function performs a calculation one or more values and returns a single value….SQL Server Aggregate Functions. Aggregate…
How do I undo a database restore in SQL Server? To use SQL Server Management studio, you can follow the following procedure: Right click on…
What is the default engine of MySQL? InnoDB The default engine is InnoDB in MySQL 5.7. You can specify the default engine by using the…
How do you create a sequence query? CREATE SEQUENCE sequence_2 start with 100 increment by -1 minvalue 1 maxvalue 100 cycle; Above query will create…
What is distinct row? DISTINCT. Omits records that contain duplicate data in the selected fields. To be included in the results of the query, the…
How do I join Teradata? An inner join is the most common join operation used in applications and can be regarded as the default join-type.…
How do I change the time on DateTime? The easiest way of doing that to change just the time is to create a TimeSpan with…
What is the use of log file in SQL Server? Every SQL Server database has a transaction log that records all transactions and the database…