Subscribe to:
Post Comments (Atom)
How to Auto-generate Order Line Item numbers for bulk uploads
I had a problem where I had 17000 line items to insert into 9000 orders. The system required line item numbers, preferably numbered 1throug...
-
There is a long explanation about SQL server caching values for autoincrement columns, and losing them when the server is restarted, but the...
-
The easy and obvious answer is to use a function, not a procedure. Then you can use it like any built-in T-SQL function. select 1, dbo.Fun...
-
You'll need SQL Server command line tools to run this. Assuming: you have a .sql file you want to run, you have a username/password and...
No comments:
Post a Comment