In many databases, foreign key constraints are not used initially and then later created on tables after data already exists. If data already exists and there are possible foreign key violations the constraint may be created using the NOCHECK option. In addition, sometimes when loading BULK data, foreign keys are disabled or removed to make [...]
Category Archives: SQL SERVER/ORACLE
Finding/Getting/Identifying Violating SQL Server Foreign Key Values Asp.Net C#
Posted by james on March 22, 2011
0 comments
Differences Similarities Between Global Variables @@IDENTITY @@SCOPE_IDENTITY Asp.Net C# Sql Server
Posted by on November 14, 2010
0 comments
SCOPE_IDENTITY, IDENT_CURRENT, and @@IDENTITY are similar functions because they return values that are inserted into identity columns. IDENT_CURRENT is not limited by scope and session; it is limited to a specified table. IDENT_CURRENT returns the value generated for a specific table in any session and any scope. SCOPE_IDENTITY and @@IDENTITY return the last identity values [...]