IDENTITY

RowNumber on SQL Server

por Thiago Suzuki
30/07/2015

People who had contact with Oracle and already used the function that enumerates the rows of a query (RowNumber) perceive a certain ease to use this functionality. However on SQL Server you are faced with a need to enumerate rows… Continue a ler »RowNumber on SQL Server

SQL Server – Insert records with value in identity column

por Thiago Suzuki
03/06/2015

Hi guys, Today I will give you a simple tip, more than a tip it is an script ready to run. You will be able to test an insert setting a value for a identity column on SQL Server. This… Continue a ler »SQL Server – Insert records with value in identity column