SQL Server Dynamic PIVOT
SQL server allows us to transform a row- level data into columnar data using SQL Pivot.
4,509 total views
Home ยป
sql skull
SQL Server Download links
Following are the links to download SQL Server 2019 and Database sample files
554 total views
SQL Server NEWSEQUENTIALID()
SQL Server NEWSEQUENTIALID() function is used to generate incremental unique values of type uniqueidentifier.
1,377 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.
1,219 total views
SQL Server NEWID()
SQL Server NEWID() function is a system function thatย is used to generate a unique value of type uniqueidentifier.ย
1,788 total views
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.
2,570 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.
796 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.
1,002 total views
SQL UNION ALL
SQL UNION ALL operator is used to combine the result sets of two or more select statements .
390 total views
SQL UNION
SQL UNION operator is used to combine the result sets of two or more select statements .
353 total views
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.
2,066 total views