SQL Server

No Image

Read and Write excel sheet in SQL Server

Recently, one of the projects needs to insert mass data into SQL server database. Data present in excel sheet with large number of row. There is a way to insert data into database through any…

No Image

SQL Server: Get table list from column name

Every business application must have database and it becomes very huge and complex day by day and difficult to remember everything. I.e. which table has which fields? Sometimes needs to find out all table lists…

No Image

SQL Server Rank() v/s Dense_rank()

Yesterday night I was searching about SQL Server system functions and got a nice puzzle of SQL Server. The puzzle likes to find out second highest salary of each department and tie salary should also count. Finally…