SQL Server PIVOT
SQL PIVOT allow us to aggregate the results and rotate rows into columns so in sort, we can say using PIVOT
Home » SQL SERVER » SQL Advance »
SQL Advance
SQL Server Advance Concepts includes Stored Procedures, Views, triggers, Complex SQL Queries, Index, Performance Tunning, Database Mail Configuration, SQL Server Agent Job Scheduling and so on..
SQL MERGE
SQL MERGE statement is used to modify data in a target table based on data in a source table.
SQL Server OUTPUT CLAUSE
The OUTPUT clause returns the values of each row that was affected by an INSERT, UPDATE or DELETE statements.
SQL Server Stored Procedure
A stored procedure is a group of SQL statements compiled into one unit for later use and can be used many times.
- « Previous
- 1
- …
- 3
- 4
- 5