Contents tagged with SQL Server
-
@@IDENTITY vs SCOPE_IDENTITY()
Have you ever wondered why the @@IDENTITY is not returning the "right" value occassionally when everything was working correctly earlier. Here is the reason.
-
SQL Server 2008 for Oracle DBA
This 15 modules, level 300 course provides students with the knowledge and skills to capitalize on their skills and experience as an Oracle DBA to manage a Microsoft SQL Server 2008 system. This workshop provides a quick start for the Oracle DBA to map, compare, and contrast the realm of Oracle database management to SQL Server database management.
-
RaiseError in SQL Server
mmm. How many of us thought about giving a progress to the client as a feed back mechanism for a long running SQL call. Read the following blog where Jens used RaiseError event differently from inside the stored procedure to give a feedback to client application on the progress.