Click here to Skip to main content
15,848,594 members
Home / Discussions / Database
   

Database

 
GeneralDifference between INNER JOIN and WHERE Clause Pin
soso_online28-Mar-08 4:39
soso_online28-Mar-08 4:39 
GeneralRe: Difference between INNER JOIN and WHERE Clause Pin
GuyThiebaut28-Mar-08 5:57
professionalGuyThiebaut28-Mar-08 5:57 
GeneralRe: Difference between INNER JOIN and WHERE Clause Pin
Joe DiNatale28-Mar-08 6:55
Joe DiNatale28-Mar-08 6:55 
GeneralSecurity Model Recommendations for ASP.NET Client Pin
Brady Kelly28-Mar-08 3:59
Brady Kelly28-Mar-08 3:59 
GeneralRe: Security Model Recommendations for ASP.NET Client Pin
Mark J. Miller28-Mar-08 10:10
Mark J. Miller28-Mar-08 10:10 
QuestionIdentity reseed in trigger Pin
User 274316228-Mar-08 3:07
User 274316228-Mar-08 3:07 
GeneralRe: Identity reseed in trigger Pin
Mark J. Miller28-Mar-08 10:19
Mark J. Miller28-Mar-08 10:19 
GeneralRe: Identity reseed in trigger Pin
User 274316228-Mar-08 22:43
User 274316228-Mar-08 22:43 
Thanks for your reply. I think the solution you provided should work for me.

Just to clarify my problem.
Identity column is primary key in table that represents movement orders being processed at some moment in automated warehouse. So the table changes very dynamicaly and is generaly empty after each shift (if not it is due to crane or some other device malfunction).
The requirement is that this movement order ID should have values between e.g. 1000000 and 1999999 so when identity reaches critical value should be reseeded.

If this additional information makes any difference to your solution please let me know.

Thanks again.

modified 19-Nov-18 21:01pm.

GeneralRe: Identity reseed in trigger Pin
Mark J. Miller31-Mar-08 6:33
Mark J. Miller31-Mar-08 6:33 
GeneralRe: Identity reseed in trigger Pin
User 274316231-Mar-08 22:25
User 274316231-Mar-08 22:25 
GeneralSQL query optimization i sql server 2005 [modified] Pin
ashok@techxygen27-Mar-08 20:27
ashok@techxygen27-Mar-08 20:27 
GeneralRe: SQL query optimization i sql server 2005 Pin
John_Adams27-Mar-08 22:39
John_Adams27-Mar-08 22:39 
GeneralRe: SQL query optimization i sql server 2005 Pin
Gandalf_TheWhite30-Dec-09 5:35
professionalGandalf_TheWhite30-Dec-09 5:35 
GeneralI dont get it :-) Get Discounted price by porcentage Pin
AlexeiXX327-Mar-08 19:32
AlexeiXX327-Mar-08 19:32 
GeneralRe: I dont get it :-) Get Discounted price by porcentage Pin
Ashfield28-Mar-08 1:50
Ashfield28-Mar-08 1:50 
GeneralRe: I dont get it :-) Get Discounted price by porcentage Pin
Sgg24528-Mar-08 3:21
Sgg24528-Mar-08 3:21 
GeneralRe: I dont get it :-) Get Discounted price by porcentage Pin
AlexeiXX328-Mar-08 10:11
AlexeiXX328-Mar-08 10:11 
GeneralWeird Error Message in MS Access...Please help Pin
new_phoenix27-Mar-08 8:37
new_phoenix27-Mar-08 8:37 
AnswerRe: Weird Error Message in MS Access...Please help Pin
Justin Porteous27-Mar-08 9:54
Justin Porteous27-Mar-08 9:54 
GeneralDatabinding for SSRS CustomReportItem Pin
Mark J. Miller27-Mar-08 8:13
Mark J. Miller27-Mar-08 8:13 
GeneralRe: Databinding for SSRS CustomReportItem Pin
Mark J. Miller27-Mar-08 11:42
Mark J. Miller27-Mar-08 11:42 
GeneralDYNAMICALLY Generating Reports in SSRS-2005 Pin
Aswanth27-Mar-08 0:12
Aswanth27-Mar-08 0:12 
GeneralPrefix 'sp' for stored procs Pin
Brady Kelly26-Mar-08 23:47
Brady Kelly26-Mar-08 23:47 
GeneralRe: Prefix 'sp' for stored procs Pin
Jammer27-Mar-08 1:02
Jammer27-Mar-08 1:02 
GeneralRe: Prefix 'sp' for stored procs Pin
Brady Kelly27-Mar-08 1:08
Brady Kelly27-Mar-08 1:08 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.