Click here to Skip to main content
15,921,660 members
Home / Discussions / Database
   

Database

 
QuestionCan execute() return both recordset and output parameters Pin
TianYang29-Apr-03 22:34
TianYang29-Apr-03 22:34 
AnswerRe: Can execute() return both recordset and output parameters Pin
andyharman30-Apr-03 12:19
professionalandyharman30-Apr-03 12:19 
GeneralCustom view for a datafield Pin
ssnkh29-Apr-03 20:14
ssnkh29-Apr-03 20:14 
GeneralSQLJ with JTree Plz HELP Pin
sharathkv12329-Apr-03 17:02
sharathkv12329-Apr-03 17:02 
GeneralGet parameter that generated by Refresh() Pin
TianYang28-Apr-03 22:21
TianYang28-Apr-03 22:21 
GeneralRead Only Transactions Pin
Patje28-Apr-03 22:08
Patje28-Apr-03 22:08 
GeneralRe: Read Only Transactions Pin
Rein Hillmann1-May-03 19:42
Rein Hillmann1-May-03 19:42 
GeneralRe: Read Only Transactions Pin
Patje4-May-03 20:43
Patje4-May-03 20:43 
Thanks,
that would seem acceptable for applications that only need to load a few records from the database. In our situation, lots of records are loaded; in some situations, the whole database is loaded. We're speaking of about 100,000 records, sometimes even millions of records. Preventing updates while loading the database, or even worse, preventing applications from starting up as long as someone is saving is not acceptable in our situation.

Do you know if the next version of SQL Server (is this SQL Server 2003?) will have the concept of read-only transactions?

Thanks.

Enjoy life, this is not a rehearsal !!!

My Articles:
- Implementing a Subject/Observer pattern with templates
- Different ways of writing class factories
- AutoRunner: a template class to automatically run start- and cleanup-code in code blocks
</

GeneralSQL Statement Help... Pin
Jason Weibel28-Apr-03 9:51
Jason Weibel28-Apr-03 9:51 
GeneralRe: SQL Statement Help... Pin
Timur Fanshteyn28-Apr-03 11:07
Timur Fanshteyn28-Apr-03 11:07 
GeneralRe: SQL Statement Help... Pin
Jason Weibel28-Apr-03 11:43
Jason Weibel28-Apr-03 11:43 
QuestionADO events biased to COM memory model? Pin
Chopper28-Apr-03 9:33
Chopper28-Apr-03 9:33 
GeneralRelated Tables: How to set forgeign key of child table when adding new rows to parenttable Pin
STW27-Apr-03 10:41
STW27-Apr-03 10:41 
GeneralRe: Related Tables: How to set forgeign key of child table when adding new rows to parenttable Pin
perlmunger30-Apr-03 5:05
perlmunger30-Apr-03 5:05 
GeneralRe: Related Tables: How to set forgeign key of child table when adding new rows to parenttable Pin
STW30-Apr-03 5:25
STW30-Apr-03 5:25 
GeneralToolbar and Short Keys/Cuts Pin
STW27-Apr-03 6:30
STW27-Apr-03 6:30 
GeneralQuery Help Pin
NickOne26-Apr-03 12:35
NickOne26-Apr-03 12:35 
QuestionHow to get the last inserted and updated id (primary_key) with Sql C# Pin
STW26-Apr-03 3:24
STW26-Apr-03 3:24 
AnswerRe: How to get the last inserted and updated id (primary_key) with Sql C# Pin
David Salter26-Apr-03 10:29
David Salter26-Apr-03 10:29 
GeneralRe: How to get the last inserted and updated id (primary_key) with Sql C# Pin
STW26-Apr-03 23:02
STW26-Apr-03 23:02 
GeneralRe: How to get the last inserted and updated id (primary_key) with Sql C# Pin
David Salter30-Apr-03 11:37
David Salter30-Apr-03 11:37 
AnswerRe: How to get the last inserted and updated id (primary_key) with Sql C# Pin
Chris Maunder26-Apr-03 12:42
cofounderChris Maunder26-Apr-03 12:42 
GeneralFilter and Delete Question Pin
Toni7825-Apr-03 6:54
Toni7825-Apr-03 6:54 
GeneralDefault number of Decimals. Pin
Chris Meech25-Apr-03 5:58
Chris Meech25-Apr-03 5:58 
GeneralRe: Default number of Decimals. Pin
Toni7825-Apr-03 7:07
Toni7825-Apr-03 7:07 

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.