CREATE DATABASE
Database in SQL Server is a collection of tables that stores a specific set of structured data. You can eaisly interact with data such as you can Select, Update and Delete the data in tables.
Schedule a Job in SQL
The SQL Server Agent job is the specified action or series of actions that the SQL Server Agent will execute at any specific date time.
SQL UNION ALL
SQL UNION ALL operator is used to combine the result sets of two or more select statements .
SQL WAITFOR
SQL WAITFOR statement is used to blocks the execution of a batch statement, transnational statement or any stored procedure until a specified time or any time interval is reached, or a specified statement modifies or returns at least one row.
Displaying line numbers in Query Editor Window
we can enable line numbers to be displayed in Sql Server Query Editor Window.
SQL sp_help
SQL Sp_help is part of database engine stored procedures ,which returns information about a database object or a data type.
SQL DATEADD()
SQL DATEADD() function adds a number to a specified date part of an input date and returns the modified date.
SQL Server RTRIM()
SQL Server RTRIM() function is used to trim trailing characters from a character string.
- « Previous
- 1
- 2