SQL Server Dynamic PIVOT
SQL server allows us to transform a row- level data into columnar data using SQL Pivot.
27,644 total views, 6 views today
Home »
sqlskull
SQL Server Download links
Following are the links to download SQL Server 2019 and Database sample files
1,486 total views
SQL Server NEWSEQUENTIALID()
SQL Server NEWSEQUENTIALID() function is used to generate incremental unique values of type uniqueidentifier.
3,602 total views
Troubleshooting Database Mail in SQL Server
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,458 total views
SQL Server NEWID()
SQL Server NEWID() function is a system function that is used to generate a unique value of type uniqueidentifier.
8,208 total views, 4 views today
SQL Server Recursive CTE
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.
8,288 total views
SQL Server CTE
SQL Server CTE (Common Table Expression) is temporary result set that is used to reference within another SELECT, INSERT, UPDATE, or DELETE statement.
3,809 total views
SQL DATENAME()
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,520 total views
SQL UNION ALL
SQL UNION ALL operator is used to combine the result sets of two or more select statements .
1,058 total views
SQL UNION
SQL UNION operator is used to combine the result sets of two or more select statements .
1,102 total views, 2 views today
SQL WAITFOR
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,498 total views, 2 views today