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
Home »
sql skull
SQL Server Download links
Following are the links to download SQL Server 2019 and Database sample files
1,398 total views, 2 views today
SQL Server NEWSEQUENTIALID()
SQL Server NEWSEQUENTIALID() function is used to generate incremental unique values of type uniqueidentifier.
3,411 total views, 2 views today
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,361 total views, 1 views today
SQL Server NEWID()
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
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.
7,569 total views, 2 views today
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,617 total views, 1 views today
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,392 total views, 4 views today
SQL UNION ALL
SQL UNION ALL operator is used to combine the result sets of two or more select statements .
1,003 total views
SQL UNION
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
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