Category Archives: SQL Development

How to connect SQL Server from Excel

Posted on March 29, 2017 by uday arumilli

How to connect SQL Server from Excel This post can help you in understanding “How to connect SQL Server from Excel Workbook”. There are situations where we need to export data from SQL Server to Excel file. There are multiple … Continue reading →

Posted in SQL Development | Tagged , , , , , , | 2 Comments

Get the Next and Previous Row Value in SQL Server

Posted on January 31, 2017 by uday arumilli

Get the Next and Previous Row Value in SQL Server This post can help you to get the next and previous row Value in SQL Server using T-SQL. We had a requirement to get the previous row information and compare … Continue reading →

Posted in Interview Q&A, SQL Development, SQL Scripts | Tagged , , , , , , , , , , | 2 Comments

SQL Server Date and Time related Interview Questions

Posted on January 27, 2017 by uday arumilli

SQL Server Date and Time related Interview Questions This post can help you in answering SQL Server Date and Time related Interview Questions.  Below is the list of queries which are recently asked in SQL Server Developer interviews. These are … Continue reading →

Posted in Interview Q&A, SQL Development, SQL Scripts | Tagged , , , , | 2 Comments