If you are preparing for a .NET job interview you need to be proficient in SQL Server to an extent. There is a demand for people with .NET and C# programming along with proficiency in SQL. The following SQL Interview questions may help you ace the interview and get the programmer job you are looking […]
Loop Through Table Rows Without Cursor in T-SQL
At times you may need to sequentially loop through some specific result set for performing some action on individual record at a time. Using SQL cursor is a choice. But, for optimal performance and to avoid potential problems, as a recommended best practice, cursors should be avoided as much as possible in T-SQL code. But […]