InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comThu, 23 May 2013 03:11:14 GMT20http://www.sqlservercentral.com/Forums/Topic1407023-1292-1.aspx[quote][b]shilpaprele (1/16/2013)[/b][hr]there may be many developers working on the DB. And if sombody uses the select into then we will have dupliction.[/quote] and this cant be get restricted or stopped , so you should make them understand that why and what needs to follow ?Wed, 16 Jan 2013 02:14:15 GMTBhuvneshhttp://www.sqlservercentral.com/Forums/Topic1407023-1292-1.aspxThanks all for your replies. I agree that we should exclude row version column but there my be many developers working on the DB. And if sombody uses the select into then we will have dupliction.Wed, 16 Jan 2013 01:08:23 GMTKrishna1http://www.sqlservercentral.com/Forums/Topic1407023-1292-1.aspxSELECT INTO creates the target table, and the only exception along the lines that you are after is with the IDENTITY column.You could leave the Rowversion column out, as already suggested but we don't know the size of the tables concerned so altering the schema may be a large overhead.Why not create the target table first and then use INSERT INTO? That will allow what you require.[code="sql"]CREATE TABLE Test1( Col1 rowversion, col2 VARCHAR(20) );CREATE TABLE Test2( Col1 rowversion, col2 VARCHAR(20) );INSERT INTO Test1(col2)VALUES( 'test1'),( 'test2')INSERT INTO test2(col2) SELECT Col2 FROM Test1SELECT * FROM test1;SELECT * FROM test2;[/code]Tue, 15 Jan 2013 04:48:59 GMTBrainDonorhttp://www.sqlservercentral.com/Forums/Topic1407023-1292-1.aspx[quote][b]shilpaprele (1/14/2013)[/b][hr]Is there any way that we can use "SELECT INTO" and still avaoid rowversion dupllication?[/quote] YEs you can try like [code="sql"]select "all coumns except rowversion column " into newtable from oldtable [/code]then [code="sql"]alter table newtable add rowverison column [/code]The above is just code hint not the actual sql codeTue, 15 Jan 2013 04:36:32 GMTBhuvneshhttp://www.sqlservercentral.com/Forums/Topic1407023-1292-1.aspxIt's only duplicated if the rowversion column is included in the column list of the select into statement.Don't do that, and your values will stay unique.CheersTue, 15 Jan 2013 04:20:43 GMTGazarethhttp://www.sqlservercentral.com/Forums/Topic1407023-1292-1.aspxHi AllMost off our tables have rowversion columns. We whant this row version to be unique through out the DB. But as per msdn site it syas that rowverison can get deuplicated if "SELECT INTO " command is used?Is there any way that we can use "SELECT INTO" and still avaoid rowversion dupllication?RegardsShilpaMon, 14 Jan 2013 22:07:03 GMTKrishna1