Click here to Skip to main content
15,879,613 members
Home / Discussions / Database
   

Database

 
GeneralRe: SQL: finding out if a column is NULL /without/ downloading all the content Pin
Edbert P26-Oct-03 15:15
Edbert P26-Oct-03 15:15 
GeneralRe: SQL: finding out if a column is NULL /without/ downloading all the content Pin
Scott.Chappel27-Oct-03 1:54
Scott.Chappel27-Oct-03 1:54 
GeneralRe: SQL: finding out if a column is NULL /without/ downloading all the content Pin
moredip29-Oct-03 1:20
moredip29-Oct-03 1:20 
Generalduplication !! Pin
bora3ee26-Oct-03 11:31
bora3ee26-Oct-03 11:31 
GeneralRe: duplication !! Pin
Edbert P26-Oct-03 13:31
Edbert P26-Oct-03 13:31 
QuestionADO.NET: Is it possible to create a dataset out of a view? Pin
Rakesh Rajan26-Oct-03 1:15
Rakesh Rajan26-Oct-03 1:15 
QuestionHow to return a boolean value from a Stored Procedure? Pin
sacoskun25-Oct-03 3:38
sacoskun25-Oct-03 3:38 
AnswerRe: How to return a boolean value from a Stored Procedure? Pin
Paul Watson25-Oct-03 4:28
sitebuilderPaul Watson25-Oct-03 4:28 
You can write the code yourself but here is the idea.

Create a SqlConnection.
Create a SqlCommand, assing the connection to it and give it a command-text equal to your SPs name.
Set the CommandType of the command to StoredProcedure.
Add an output SqlParameter to the command, make it's name equal to the output param in your SP.
Execute the command
The parameter will then be assigned the value.
Use Convert.ToBoolean to get the value.

regards,
Paul Watson
Bluegrass
South Africa

Miszou wrote:
I have read the entire internet. on how boring his day was.

Crikey! ain't life grand?

QuestionWhy the connection is so slow? Pin
yyf24-Oct-03 8:46
yyf24-Oct-03 8:46 
AnswerRe: Why the connection is so slow? Pin
Paul Watson25-Oct-03 4:31
sitebuilderPaul Watson25-Oct-03 4:31 
AnswerRe: Why the connection is so slow? Pin
Rob Graham25-Oct-03 5:36
Rob Graham25-Oct-03 5:36 
AnswerRe: Why the connection is so slow? Pin
Mike Dimmick28-Oct-03 3:12
Mike Dimmick28-Oct-03 3:12 
GeneralQuery Pin
Anonymous24-Oct-03 3:08
Anonymous24-Oct-03 3:08 
GeneralRe: Query Pin
Rocky Moore25-Oct-03 4:34
Rocky Moore25-Oct-03 4:34 
GeneralRestore Pin
Anonymous22-Oct-03 9:32
Anonymous22-Oct-03 9:32 
GeneralRe: Restore Pin
Terry O'Nolley25-Oct-03 15:02
Terry O'Nolley25-Oct-03 15:02 
GeneralCreate an text field in Access from SQL Pin
Jerome Conus22-Oct-03 3:55
Jerome Conus22-Oct-03 3:55 
GeneralRe: Create an text field in Access from SQL Pin
cyphermox22-Oct-03 12:34
cyphermox22-Oct-03 12:34 
GeneralRe: Create an text field in Access from SQL Pin
Jerome Conus22-Oct-03 19:22
Jerome Conus22-Oct-03 19:22 
GeneralRe: Create an text field in Access from SQL Pin
Chris Meech23-Oct-03 6:18
Chris Meech23-Oct-03 6:18 
GeneralRe: Create an text field in Access from SQL Pin
Jerome Conus23-Oct-03 19:51
Jerome Conus23-Oct-03 19:51 
GeneralRe: Create an text field in Access from SQL Pin
Chris Meech24-Oct-03 2:02
Chris Meech24-Oct-03 2:02 
GeneralRe: Create an text field in Access from SQL Pin
Rob Graham25-Oct-03 5:40
Rob Graham25-Oct-03 5:40 
QuestionSQL 2000: EXECUTE statement context??? Pin
mittalpa21-Oct-03 7:47
mittalpa21-Oct-03 7:47 
AnswerRe: SQL 2000: EXECUTE statement context??? Pin
Rob Graham25-Oct-03 5:43
Rob Graham25-Oct-03 5:43 

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.