IDENTITY columns are not expected to be sequential. Most of the times you will notice that the IDENTITY columns have missing numbers. This behavior is by design, and there is nothing to worry about it. If your application requires a sequential number an...

There may be times when you need to retrieve all the IDENTITY values generated by a multi-row insert (an query that inserts more than one row in a single statement). If the insert statement inserts more than one row, `SCOPE_IDENTITY()` cannot help. In s...

I have written over a dozen articles covering almost all aspects of SQL Server IDENTITY columns. The intention of this page is to serve as an index, so that people can find the right post based on the specific piece of information they are looking for. ...

I have written over a dozen articles covering almost all aspects of SQL Server IDENTITY columns. The intention of this page is to serve as an index, so that people can find the right post based on the specific piece of information they are looking for. ...

Here are some SSIS related Interview Questions with answers. 1. What is the control flow Answer: In SSIS a workflow is called a control-flow. A control-flow links together our modular data-flows as a series of operations in order to achieve a desired...

Hi, Lets talks about EXPRESSIONS. It is one of the most interesting and used feature available in SSIS. At times we tend to over do in out attempt to work using Expressions. One needs to decide when it is best to use an expression. A few po......

suppose if we add '19000101' ,result will be the same right?a...

s ur right madhi...

1)How to Create User Define Role? 2)How to Give Particular Access to Role?...

1)How to Create User Define Role? 2)How to Give Particular Access to Role?...