Click here to Skip to main content
15,915,032 members
Home / Discussions / Database
   

Database

 
GeneralRe: Identity reseed in trigger Pin
User 274316228-Mar-08 21:43
User 274316228-Mar-08 21:43 
GeneralRe: Identity reseed in trigger Pin
Mark J. Miller31-Mar-08 5:33
Mark J. Miller31-Mar-08 5:33 
GeneralRe: Identity reseed in trigger Pin
User 274316231-Mar-08 21:25
User 274316231-Mar-08 21:25 
GeneralSQL query optimization i sql server 2005 [modified] Pin
ashok@techxygen27-Mar-08 19:27
ashok@techxygen27-Mar-08 19:27 
GeneralRe: SQL query optimization i sql server 2005 Pin
John_Adams27-Mar-08 21:39
John_Adams27-Mar-08 21:39 
GeneralRe: SQL query optimization i sql server 2005 Pin
Gandalf_TheWhite30-Dec-09 4:35
professionalGandalf_TheWhite30-Dec-09 4:35 
GeneralI dont get it :-) Get Discounted price by porcentage Pin
AlexeiXX327-Mar-08 18:32
AlexeiXX327-Mar-08 18:32 
GeneralRe: I dont get it :-) Get Discounted price by porcentage Pin
Ashfield28-Mar-08 0:50
Ashfield28-Mar-08 0:50 
GeneralRe: I dont get it :-) Get Discounted price by porcentage Pin
Sgg24528-Mar-08 2:21
Sgg24528-Mar-08 2:21 
GeneralRe: I dont get it :-) Get Discounted price by porcentage Pin
AlexeiXX328-Mar-08 9:11
AlexeiXX328-Mar-08 9:11 
GeneralWeird Error Message in MS Access...Please help Pin
new_phoenix27-Mar-08 7:37
new_phoenix27-Mar-08 7:37 
AnswerRe: Weird Error Message in MS Access...Please help Pin
Justin Porteous27-Mar-08 8:54
Justin Porteous27-Mar-08 8:54 
GeneralDatabinding for SSRS CustomReportItem Pin
Mark J. Miller27-Mar-08 7:13
Mark J. Miller27-Mar-08 7:13 
GeneralRe: Databinding for SSRS CustomReportItem Pin
Mark J. Miller27-Mar-08 10:42
Mark J. Miller27-Mar-08 10:42 
GeneralDYNAMICALLY Generating Reports in SSRS-2005 Pin
Aswanth26-Mar-08 23:12
Aswanth26-Mar-08 23:12 
GeneralPrefix 'sp' for stored procs Pin
Brady Kelly26-Mar-08 22:47
Brady Kelly26-Mar-08 22:47 
GeneralRe: Prefix 'sp' for stored procs Pin
Jammer27-Mar-08 0:02
Jammer27-Mar-08 0:02 
GeneralRe: Prefix 'sp' for stored procs Pin
Brady Kelly27-Mar-08 0:08
Brady Kelly27-Mar-08 0:08 
GeneralRe: Prefix 'sp' for stored procs Pin
pmarfleet27-Mar-08 0:10
pmarfleet27-Mar-08 0:10 
GeneralRe: Prefix 'sp' for stored procs Pin
Rob Philpott27-Mar-08 3:09
Rob Philpott27-Mar-08 3:09 
GeneralRe: Prefix 'sp' for stored procs Pin
Pete O'Hanlon27-Mar-08 3:16
mvePete O'Hanlon27-Mar-08 3:16 
GeneralRe: Prefix 'sp' for stored procs Pin
pmarfleet27-Mar-08 3:36
pmarfleet27-Mar-08 3:36 
GeneralRe: Prefix 'sp' for stored procs Pin
Brady Kelly27-Mar-08 3:54
Brady Kelly27-Mar-08 3:54 
As I said above, yy prefix is not to indicate that it is a stored procedure, but to indicate a system procedure, one which access data not changed by the business processes of the application, such as lists for drop down etc. compared to 'transactional' data inserted by application procedures, prefixed with ap.  My initial idea was these prefixes themselves prefixed with an acronym for the application name, but hosting objects for different applications in the same database is not one of my good practices.  Databases are relatively cheap, and and cohesive application should have its own database.



GeneralRe: Prefix 'sp' for stored procs Pin
Pete O'Hanlon27-Mar-08 3:56
mvePete O'Hanlon27-Mar-08 3:56 
GeneralRe: Prefix 'sp' for stored procs Pin
GuyThiebaut27-Mar-08 0:34
professionalGuyThiebaut27-Mar-08 0:34 

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.