Click here to Skip to main content
15,882,278 members
Home / Discussions / Database
   

Database

 
GeneralProblem in writing a stored procedure in SQL SERVER 2000 Pin
Member 305788717-Dec-07 19:41
Member 305788717-Dec-07 19:41 
GeneralRe: Problem in writing a stored procedure in SQL SERVER 2000 Pin
pmarfleet17-Dec-07 21:41
pmarfleet17-Dec-07 21:41 
GeneralQuery regarding SQL Pin
sandhya1417-Dec-07 18:45
sandhya1417-Dec-07 18:45 
GeneralRe: Query regarding SQL Pin
That's Aragon17-Dec-07 18:52
That's Aragon17-Dec-07 18:52 
GeneralRe: Query regarding SQL Pin
sandhya1418-Dec-07 1:05
sandhya1418-Dec-07 1:05 
QuestionInsert vs Update Pin
Yusuf17-Dec-07 7:38
Yusuf17-Dec-07 7:38 
GeneralRe: Insert vs Update Pin
Colin Angus Mackay17-Dec-07 8:01
Colin Angus Mackay17-Dec-07 8:01 
GeneralRe: Insert vs Update Pin
GuyThiebaut17-Dec-07 8:51
professionalGuyThiebaut17-Dec-07 8:51 
Looks like a case of code that was written for testing was then changed to live code.

With the information you have provided I can see no reason to need to do this.

The only time it may be useful is in an OLTP system where thousands of users need to create records at high speed and recover the id (for call logging purposes for instance), as you say, before inserting a large amount of data in a row.

Regards

Guy
You always pass failure on the way to success.


QuestionFinding triggers that are disabled or not? Pin
Syed Mujtaba Hassan17-Dec-07 0:29
Syed Mujtaba Hassan17-Dec-07 0:29 
AnswerRe: Finding triggers that are disabled or not? Pin
GuyThiebaut17-Dec-07 0:43
professionalGuyThiebaut17-Dec-07 0:43 
Generalhijri calender with sql server 2005 Pin
Ahmad Adnan16-Dec-07 22:38
Ahmad Adnan16-Dec-07 22:38 
GeneralRe: hijri calender with sql server 2005 Pin
GuyThiebaut17-Dec-07 1:30
professionalGuyThiebaut17-Dec-07 1:30 
GeneralMySql database does not store "\" (backward slash) when query using vb.net Pin
Rupesh Kumar Swami16-Dec-07 21:16
Rupesh Kumar Swami16-Dec-07 21:16 
GeneralRe: MySql database does not store "\" (backward slash) when query using vb.net Pin
Giorgi Dalakishvili16-Dec-07 22:00
mentorGiorgi Dalakishvili16-Dec-07 22:00 
QuestionC# : How to get the server machine's current date and time? Pin
kssknov16-Dec-07 20:34
kssknov16-Dec-07 20:34 
AnswerRe: C# : How to get the server machine's current date and time? [modified] Pin
Tobias Schoenig16-Dec-07 21:42
Tobias Schoenig16-Dec-07 21:42 
Generalpopulating Access table field with charater variable Pin
Amanjot16-Dec-07 13:18
Amanjot16-Dec-07 13:18 
GeneralRe: populating Access table field with charater variable Pin
ChandraRam16-Dec-07 23:08
ChandraRam16-Dec-07 23:08 
QuestionSqlserver 2000 joins Pin
Dhilipkumar15-Dec-07 22:14
Dhilipkumar15-Dec-07 22:14 
GeneralRe: Sqlserver 2000 joins PinPopular
GuyThiebaut16-Dec-07 6:35
professionalGuyThiebaut16-Dec-07 6:35 
GeneralRe: Sqlserver 2000 joins Pin
Bassam Saoud16-Dec-07 7:25
Bassam Saoud16-Dec-07 7:25 
GeneralRe: Sqlserver 2000 joins Pin
Paul Conrad16-Dec-07 8:31
professionalPaul Conrad16-Dec-07 8:31 
GeneralRe: Sqlserver 2000 joins Pin
GuyThiebaut16-Dec-07 9:00
professionalGuyThiebaut16-Dec-07 9:00 
GeneralRe: Sqlserver 2000 joins Pin
Paul Conrad16-Dec-07 9:12
professionalPaul Conrad16-Dec-07 9:12 
GeneralRe: Sqlserver 2000 joins Pin
Pete O'Hanlon16-Dec-07 11:33
mvePete O'Hanlon16-Dec-07 11:33 

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.