SQL Server Dynamic PIVOT
SQL server allows us to transform a row- level data into columnar data using SQL Pivot.
25,083 total views, 23 views today
SQL server allows us to transform a row- level data into columnar data using SQL Pivot.
25,083 total views, 23 views today
Following are the links to download SQL Server 2019 and Database sample files
1,398 total views, 2 views today
SQL Server NEWSEQUENTIALID() function is used to generate incremental unique values of type uniqueidentifier.
3,411 total views, 2 views today
Troubleshooting Database Mail
If you are not getting Database Mail after configuring it , you need to got through few more step to fix it.
2,361 total views, 1 views today
SQL Server NEWID() function is a system function that is used to generate a unique value of type uniqueidentifier.
7,428 total views, 15 views today
A Recursive CTE (Common Table Expression) is a CTE that references itself. In doing so, the initial CTE is repeatedly executed, returning subsets of data, until it returns the complete result set.
7,569 total views, 2 views today
SQL Server CTE (Common Table Expression) is temporary result set that is used to reference within another SELECT, INSERT, UPDATE, or DELETE statement.
3,617 total views, 1 views today
The DATENAME() function returns a string, navarchar type, that represents a specified date part of date ,it can be a day , month ,year or time of specific date.
2,392 total views, 4 views today
SQL UNION ALL operator is used to combine the result sets of two or more select statements .
1,003 total views
SQL UNION operator is used to combine the result sets of two or more select statements .
1,043 total views, 2 views today
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.
5,266 total views, 1 views today