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...
-
This function will return a list of all dates between a start date and an end date. SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO -- ====...
-
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...
-
There is a long explanation about SQL server caching values for autoincrement columns, and losing them when the server is restarted, but the...
No comments:
Post a Comment