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 cursor is a choice, but we have other choices as well. Use following sample logic. Example 1 – Loop Through Table Rows in SQL: Select records where SalProcessed = 0 and process […]