SQL GOTO Statement
The SQL GOTO statement is used to alter the flow of execution. When the execution reaches the GOTO statement.
2,519 total views, 1 views today
The SQL GOTO statement is used to alter the flow of execution. When the execution reaches the GOTO statement.
2,519 total views, 1 views today
SQL Server CONCAT_WS() function is a string function that is used concatenates two or more strings together with a separator.
It separates those concatenated string values with the delimiter specified in the first function parameter.
1,592 total views, 1 views today
SQL Server Interview Question & Answer Quiz on CREATE statement
1,120 total views, 1 views today
SQL interview question and answer on Substring function
3,173 total views
The DENSE_RANK() is a Ranking function that is used to assign ranks to rows in partitions with no gaps in the ranking values.
1,439 total views, 2 views today
The RANK() function is a window function that is used to assign a rank to each row in the partition of a result set.
1,277 total views, 1 views today
SQL Row_Number() is a ranking function/window function that is used to assign a sequential integer to each row within a partition of a result set. The row number starts with one for the first row in each partition.
1,725 total views, 1 views today
The SQL INTERSECT clause is used to combine two SELECT statements, but returns rows only from the first SELECT statement that are identical to a row in the second SELECT statement.
1,268 total views, 1 views today
A PRIMARY KEY constraint uniquely identifies each record in a table .
1,149 total views, 3 views today
How to copy a data of table from another database in SQL Server?
Suppose, you have a database1 and table1 and one another database2 and table2 in SQL server.
Now you are required to select data of a table1 of database1 from database2 of table2.
What would be a query for that?
20,444 total views, 13 views today
It fires in response to LOGON events of SQL Server is raised .
A LOGON Triggers can be useful in may ways, such as to restrict number of connection made by a Login or to prevent a user from logging-in outside .
1,133 total views, 3 views today