Database

MySQL: how to call a stored proc with OUT param

1-May-09 14:52

I found something recently that discussed arith_abort (I think, the link is at work) which is set on by default, setting it to off apparently made a difference to some procs that showed this behavior.

I have seen this behavior and after doing all the optimising possible the proc was still slow, that's when I started chasing down the more esoteric suggestions.

If I find the link I will post it Monday....

Never underestimate the power of human stupidity
RAH

devvvy30-Apr-09 20:15

devvvy

30-Apr-09 20:15

hi there,

how can you call a stored proc with OUT param in MySQL?

CREATE PROCEDURE spListUser (
...
PrimaryEmailFilter nvarchar(255),
..
OUT NumItemsSelected int
)
BEGIN
...
END;

I tried different things none work.

<br />
CALL spListUser (<br />
...<br />
	@NumItemsSelected<br />
);<br />
<br />
CALL spListUser (<br />
...<br />
	OUT @NumItemsSelected<br />
);<br />
<br />
CALL spListUser (<br />
...<br />
	@NumItemsSelected OUT<br />
);<br />

In the end, I figured that it worked with Command line client but not with TOAD. What the hell is this? Anybody come across this before?

Thanks

dev

Microsoft SQL 2008

Ivan200930-Apr-09 10:20

Ivan2009

30-Apr-09 10:20

How can I go about building a database for say, a toy company? Using the microsoft SQL 2008? I know SQL commands whcih Ihave used to retrieve data using VB script from an already built website.
But I want to build my own DB and then connect it to my .NET framework.

Henry Minute30-Apr-09 11:43

Henry Minute

30-Apr-09 11:43

Well one way to start would be by building ER diagrams.

Henry Minute

Do not read medical books! You could die of a misprint. - Mark Twain
Girl: (staring) "Why do you need an icy cucumber?"
“I want to report a fraud. The government is lying to us all.”

Ivan200930-Apr-09 14:12

Ivan2009

30-Apr-09 14:12

Yeah Henry, that would be a good start. But then, how do I start up SQL 2008 and how do I get the Microsoft SQL editor? I mean, i see a downloaded link that says SQL 2008 on my desktop after I installed Visual Developer. But, I am unanle to figure out where do i go from there to build my DB??

Mycroft Holmes30-Apr-09 17:50

30-Apr-09 17:50

Buy a book on SQL, your question is unanswerable in a forum, you are asking someone to teach you how to build a database, this can take years to perfect and certainly weeks/months to get the basics.

Never underestimate the power of human stupidity
RAH

system table sysmergesubscriptions: replacements for distributor and srvid

Ivan20091-May-09 6:28

Ivan2009

1-May-09 6:28

Thanks for the Curt reply Mycroft.

Roland Bär30-Apr-09 6:03

Roland Bär

30-Apr-09 6:03

Hi
The system table sysmergesubscriptions has changed from SQL Server 2000 to SQL Server 2005. The columns distributor and srvid are no more available. I have a stored procedure that used this columns that is not working when it should be used on an SQL Server 2005 or 2008.

Are there any replacements for this columns and is it possible to use them also on SQL Server 2000?

Here is the query that uses this columns:

DECLARE repl_cur CURSOR FOR
		SELECT
			mp.name,
			me.srvname,
			mp.publisher, 
			mp.publisher_db,
			ms.db_name,
			ms.subscription_type,
			ms.distributor
		FROM
			sysmergepublications mp 
		INNER JOIN
			sysmergesubscriptions ms 
			ON ms.pubid = mp.pubid 
		INNER JOIN 
			master.dbo.sysservers me
			ON ms.srvid = me.srvid
		INNER JOIN 
			sysmergearticles ma 
			ON ma.pubid = ms.pubid 
		WHERE 
			ma.name = 'PasswordCounter' 
			AND ms.subscription_type = 1

Thanks for your help

Greets
Roland

Hi! I'm a signature virus. Copy me into your sig file and help me spread!

Follow your Euro notes in their tracks

linked server error in sql server

Maddie from Dartford30-Apr-09 3:32

Maddie from Dartford

30-Apr-09 3:32

Hello,
I got a SQL 2005 database back up file which i restored in my VS2005 SQL studio express to use in my code. I found that some of the stored procedure are using linked server. I created all required linked server object in studio express but still when i try to execute the stored procedure, i get this error:

"The OLE DB provider "MSDASQL" for linked server "LinkedServerName" reported an error. The provider did not give any information about the error.
Msg 7303, Level 16, State 1, Procedure rpStoredProcedureName, Line 18
Cannot initialize the data source object of OLE DB provider "MSDASQL" for linked server "LinkedServerName"."

Any idea to resolve this problem? what else i need to do?

Thanks in Advance.

Re: linked server error in sql server

Mycroft Holmes30-Apr-09 17:54

30-Apr-09 17:54

gajesh wrote:
I created all required linked server object in studio express

Does Express support linked servers - I would be surprised if it does.
Are all the linked servers accessible to your system?

Never underestimate the power of human stupidity
RAH

select where only

foryou30-Apr-09 0:58

foryou

30-Apr-09 0:58

Hi!

I have a table Validation:
Id_student --- - id_semestre ----- id_validation
102----------- - 1 ---------------- 4
102----------- - 1 ---------------- 3 --
102----------- - 2 ---------------- 4
103----------- - 1 ---------------- 4
104----------- - 2 ---------------- 3
104----------- - 2 ---------------- 4

I want to select students who have in semestre 2 id_validation = 4 only .
in the example i want have :
102 students, not 102 and 104
thank you.

Re: select where only

scottgp30-Apr-09 1:46

scottgp

30-Apr-09 1:46

This works (using a correlated subquery), but I'm sure it's not the only way to get the correct results:

select v1.id_student from validation v1
where v1.id_semestre = 2 and v1.id_validation=4
and not exists (select id_student from validation v2
where id_semestre = 2 and id_validation<>4
and V1.ID_STUDENT = V2.ID_STUDENT )

Scott

Re: select where only

foryou30-Apr-09 2:56

foryou

30-Apr-09 2:56

Thanks scottgp it works. Smile | :)

Update datagridview

hitesh.kalra29-Apr-09 21:41

hitesh.kalra

29-Apr-09 21:41

If I am working manually to create columns and add it on datagrid view at run time it is not updating through olddbcommandbulder command. But when I am using this code

"datagridview.datasource= ds.tables[0].defaultview;"

then it is updating. But how will I updating when I work manually. Plz give a code in c# .net.

thanx in advance.

Re: Update datagridview

Mycroft Holmes29-Apr-09 22:03

29-Apr-09 22:03

i give up!

Never underestimate the power of human stupidity
RAH

Re: Update datagridview

Spunky Coder29-Apr-09 22:13

Spunky Coder

29-Apr-09 22:13

Post all your GridView and the related troubles in C# forum.

"Don't worry if it doesn't work right. If everything did, you'd be out of a job." (Mosher's Law of Software Engineering)

Re: Update datagridview

saanj29-Apr-09 23:56

Re: Validate emailaddress

29-Apr-09 23:56

Your problem is not clear man. Can you please ellaborate more on this?

Either you love IT or leave IT...

Validate emailaddress

hitesh.kalra29-Apr-09 21:37

hitesh.kalra

29-Apr-09 21:37

How will I validate the text of email address. I am making a window application in c# .net, in the text box I want that the textbox of email contains the '@' without written @ it gives a messagebox that it is not valid email address.

thanx in advance

Mycroft Holmes29-Apr-09 22:02

Re: Validate emailaddress

29-Apr-09 22:02

Same reply as the DGV, oh wait you know it is C# so go there

Never underestimate the power of human stupidity
RAH

saanj29-Apr-09 23:58

29-Apr-09 23:58

This is not the right place to ask C#.NET Question. Go to C#.NET Section.

Either you love IT or leave IT...

Datagrid view

hitesh.kalra29-Apr-09 21:35

hitesh.kalra

29-Apr-09 21:35

In datagridview how will I make a validation for the length of text written in cell, eg. mobile no column takes on 10 digits

Re: Datagrid view

Mycroft Holmes29-Apr-09 22:01

29-Apr-09 22:01

Wrong forum
Take it to VB, C# or winforms

Never underestimate the power of human stupidity
RAH

Re: Datagrid view

saanj29-Apr-09 23:59

How to deploy a report to the client machine server?

29-Apr-09 23:59

Repost the question in the appropriate section.

Either you love IT or leave IT...

SIJUTHOMASP29-Apr-09 10:06

SIJUTHOMASP

29-Apr-09 10:06

Hello,

I have created report using visual studio and in sql 2005. .rdl files got created with the report. Usually in development enviroment, its easy to deploy using the UI and specify the target url..But my requirement is to deploy the report to another server where there is no VS or BI of sql server to get the interface..

Is there way to deploy the created report to the server? Really would appreciate any help on this..

I have seen one article that mentioned to move the dbs to the server..my confusion in this case is that , would that remove the existing reports in the target machine..

Thanks in advance..
Rahul.

SoftwareDeveloper(.NET)

Re: How to deploy a report to the client machine server?

saanj30-Apr-09 0:01