The title of this article is misleading. It does NOT have to do at all with SQL Bulk Insert
Insert auto Number in SQLSERVER
To insert unique serial numeric values to an SQL table usually DBAs rely on procs with loops and inside loop an incrementing variable substitutes numeric values
this may query time out., will consume mush significant time and may cause intermediate termination
to resolve this issue in SQL Server us the following query
suppose there is one table called customers and we need to back it up to table customer_backup
insert into customers_backup
select cust_name,join_date,row_number() over (order by join_date) from customers
MSSQL Server 
2011, 2012, abhilash, Auto, backup, Bulk, bulk insert, cust, customer, Date, DBAs, Insert, issue, Loop, mush, name, number, numeric values, order, procs, query, query time, row, serial, server, significant time, SQL, sql table, table, termination, time
Comment on Facebook
2 Comments to “Insert auto Number in SQLSERVER”
-
Mb March 3, 2011 at 2:20 AM
-
Meet Author
S.Abhilash, started this blog in the later half of 2009 as a self hosting site for all his previous blogging attempts. , My way of writing and frequency of publishing may not be uniform as my resources are my projects nd issues i came across. For the last few years this blog is reacing 100 s of unique visitors each day, thanks wordpress and google for such a perfection in their software and services.
Submit Your Email For Free Updates on New Articles