Home »
SQL basics to Advance
SP_RENAME in SQL Server
SQL Server SP_NAME is SQL Server Database Engine stored procedure that is used to Changes the name of a user-created object in the current database. This object can be a table, index column or alias datatype.
SQL Server @@ERROR
SQL Server @@ERROR is a global variable that returns an error number if the last statement encountered an error but we have to trace it within just after the next line where the actual error occurred, otherwise, it will reset to 0.
SQL Server Create SCHEMA
A Schema in SQL Server is a collection of database objects associated with a database.
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.
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.
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.
SQL DML AFTER TRIGGER
After Trigger (using FOR/AFTER CLAUSE)
This type of trigger fires after SQL Server finishes the execution of the action successfully that fired it.
USER DEFINED FUNCTIONS
SQL Server allows us to create our functions called as user defined functions in SQL Server.
SQL CROSS JOIN
SQL CROSS JOIN returns a result set which is the number of rows in the first table multiplied by the number of rows in the second table if no WHERE clause is used along with CROSS JOIN
SQL SERVER REPLACE
SQL REPLACE() function is used to replace all occurrences of a substring in a string with a new substring .
SQL EOMONTH()
SQL EOMONTH() function is a date function , it returns the last day of the month of a specified date, with an optional offset.