Introduction to T-SQL TRY CATCH
T-SQL TRY…CATCH is defined as, it is a block that can be utilized to assess the position of activities in which we can say that it has been built to au… Read More
SQL – Structured Query Language is a standard language for querying a database. PL SQL is called as Procedural language extension to SQL. T-SQL stands for Transact SQL. This is the ext… Read More
In SQL Server-Exception Handling Template for Stored Procedure This article, in the series of articles on Exception Handling in SQL Server. Below is the complete list of articles in this ser… Read More
Symptom
Creating a Peer 2 Peer publication from SQL scripts and you observe the Distribution Agents failing with "incorrect syntax near". These messages can be observed in SQL Serve… Read More
SQL Server, DBA interview questionsQuestions are categorized under the following sections, for your convenience:Database design (8 questions)SQL Server architecture (12 questions)Database ad… Read More
In the previous article on how to use the partial methods in the CodeSmith CSLA templates to preserve custom code mostly focused on the code side of things. For those of you who might be usi… Read More