SQL GOTO Statement
The SQL GOTO statement is used to alter the flow of execution. When the execution reaches the GOTO statement.
3,388 total views, 3 views today
Home »
sql statement
SQL Server CONCAT_WS Function
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,911 total views, 1 views today
SQL Server Interview Question & Answer Quiz on CREATE statement
SQL Server Interview Question & Answer Quiz on CREATE statement
1,493 total views
SQL SERVER Interview Q & A QUIZ on SUBSTRING()
SQL interview question and answer on Substring function
3,774 total views, 1 views today
SQL Server DENSE_RANK()
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,758 total views, 1 views today
SQL RANK()
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,540 total views
SQL Server ROW_NUMBER()
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.
2,191 total views
SQL SERVER INTERSECT
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,560 total views, 1 views today
SQL Primary Key constraint
A PRIMARY KEY constraint uniquely identifies each record in a table .
1,474 total views
How to access a data of table from another database in SQL Server?
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?
25,095 total views, 4 views today
SQL LOGON Trigger
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,702 total views