Click here to Skip to main content
13,151,514 members (45,387 online)
   

Database

 
AnswerRe: SET NOCOUNT Pin
Bernhard Hiller24-Jul-12 0:33
memberBernhard Hiller24-Jul-12 0:33 
GeneralRe: SET NOCOUNT Pin
Member 348763224-Jul-12 0:48
memberMember 348763224-Jul-12 0:48 
AnswerRe: SET NOCOUNT Pin
Eddy Vluggen24-Jul-12 2:34
memberEddy Vluggen24-Jul-12 2:34 
GeneralRe: SET NOCOUNT Pin
Member 348763224-Jul-12 5:41
memberMember 348763224-Jul-12 5:41 
GeneralRe: SET NOCOUNT Pin
Eddy Vluggen24-Jul-12 7:31
memberEddy Vluggen24-Jul-12 7:31 
AnswerRe: SET NOCOUNT Pin
_Amy24-Jul-12 2:57
member_Amy24-Jul-12 2:57 
GeneralRe: SET NOCOUNT Pin
Member 348763224-Jul-12 5:44
memberMember 348763224-Jul-12 5:44 
AnswerRe: SET NOCOUNT Pin
Luc Pattyn24-Jul-12 6:07
mvpLuc Pattyn24-Jul-12 6:07 
Member 3487632 wrote:
for select statement it is giving -1 always


What a shocker. It is what the doc[^] says: For UPDATE, INSERT, and DELETE statements, the return value is the number of rows affected by the command... For all other types of statements, the return value is -1

Hmmm | :|
Luc Pattyn [My Articles] Nil Volentibus Arduum

GeneralRe: SET NOCOUNT Pin
Member 348763224-Jul-12 6:21
memberMember 348763224-Jul-12 6:21 
AnswerRe: SET NOCOUNT Pin
_Amy24-Jul-12 17:36
member_Amy24-Jul-12 17:36 
AnswerRe: SET NOCOUNT Pin
jschell24-Jul-12 7:16
memberjschell24-Jul-12 7:16 
QuestionSET NOCOUNT Pin
Member 348763223-Jul-12 22:15
memberMember 348763223-Jul-12 22:15 
AnswerRe: SET NOCOUNT Pin
Wayne Gaylard23-Jul-12 23:06
mentorWayne Gaylard23-Jul-12 23:06 
GeneralRe: SET NOCOUNT Pin
Member 348763223-Jul-12 23:09
memberMember 348763223-Jul-12 23:09 
GeneralIncreasing the session existing time in sql server Pin
yousefshokati20-Jul-12 22:29
memberyousefshokati20-Jul-12 22:29 
AnswerRe: Increasing the session existing time in sql server Pin
Eddy Vluggen21-Jul-12 7:57
memberEddy Vluggen21-Jul-12 7:57 
GeneralRe: Increasing the session existing time in sql server Pin
jschell21-Jul-12 11:46
memberjschell21-Jul-12 11:46 
QuestionProblem saving file to MySQL Pin
jrahma20-Jul-12 21:27
memberjrahma20-Jul-12 21:27 
AnswerRe: Problem saving file to MySQL Pin
Eddy Vluggen20-Jul-12 23:22
memberEddy Vluggen20-Jul-12 23:22 
GeneralRe: Problem saving file to MySQL Pin
jrahma21-Jul-12 2:33
memberjrahma21-Jul-12 2:33 
GeneralRe: Problem saving file to MySQL Pin
Eddy Vluggen21-Jul-12 7:54
memberEddy Vluggen21-Jul-12 7:54 
GeneralRe: Problem saving file to MySQL Pin
jrahma21-Jul-12 8:40
memberjrahma21-Jul-12 8:40 
GeneralRe: Problem saving file to MySQL Pin
Eddy Vluggen21-Jul-12 9:21
memberEddy Vluggen21-Jul-12 9:21 
GeneralRe: Problem saving file to MySQL Pin
jrahma21-Jul-12 9:42
memberjrahma21-Jul-12 9:42 
GeneralRe: Problem saving file to MySQL Pin
jschell21-Jul-12 11:48
memberjschell21-Jul-12 11:48 

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.


Advertise | Privacy |
Web02 | 2.8.170924.2 | Last Updated 22 Sep 2017
Copyright © CodeProject, 1999-2017
All Rights Reserved. Terms of Service
Layout: fixed | fluid