debug sql stored procedure - Database Discussion Boards

First Prev Next

Re: Web part database access

Michael Potter24-Oct-05 3:15

Michael Potter

24-Oct-05 3:15

Is your web server out of your domain/firewall zone? Maybe you don't have access to talk on the port (default 1433). Try and open the port from a using telnet from a command prompt on the web server (XXX is the IP number of the SQL Server):

telnet XXX.XXX.XXX.XXX 1433

If you go to a blank screen then you are connected (you will have to [X] out of the app at that point). Otherwise a connect error will be displayed.

Re: Web part database access

phy6njsb24-Oct-05 3:53

phy6njsb

24-Oct-05 3:53

Cheers but the two are connected and can talk to one another.

help!!!!!!!.............. please

alonso2k8119-Oct-05 11:46

alonso2k81

19-Oct-05 11:46

i need help look i disigned a aplication in csharp and i use crystal report

but when i instal the aplicacion run correct when i print some thins they sendme this error
ee the end of this message for details on invoking
just-in-time (JIT) debugging instead of this dialog box.

************** Exception Text **************
CrystalDecisions.CrystalReports.Engine.InternalException: Cannot find KeycodeV2.dll, or invalid keycode.
at .K(String
, EngineExceptionErrorID )
at .G(String , Int32 )
at CrystalDecisions.CrystalReports.Engine.ReportDocument.@()
at CrystalDecisions.CrystalReports.Engine.ReportDocument.InternalInit()
at CrystalDecisions.CrystalReports.Engine.ReportDocument..ctor()
at CrystalDecisions.CrystalReports.Engine.ReportClass..ctor()
at Elias.porfavor..ctor() in C:\Documents and Settings\lobo\Mis documentos\Visual Studio Projects\Elias\porfavor.cs:line 21
at Elias.Form9.button2_Click(Object sender, EventArgs e) in c:\documents and settings\lobo\mis documentos\visual studio projects\elias\form9.cs:line 255
at System.Windows.Forms.Control.OnClick(EventArgs e)
at System.Windows.Forms.Button.OnClick(EventArgs e)
at System.Windows.Forms.Button.OnMouseUp(MouseEventArgs mevent)
at System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons button, Int32 clicks)
at System.Windows.Forms.Control.WndProc(Message& m)
at System.Windows.Forms.ButtonBase.WndProc(Message& m)
at System.Windows.Forms.Button.WndProc(Message& m)
at System.Windows.Forms.ControlNativeWindow.OnMessage(Message& m)
at System.Windows.Forms.ControlNativeWindow.WndProc(Message& m)
at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)

Re: help!!!!!!!.............. please

TheOnlyFalcon21-Oct-05 14:41

TheOnlyFalcon

21-Oct-05 14:41

I've also been facing this problem , but i found the
solution which worked for me . I donn't whether it's a perfect solution or not someone may present a better to
you. But for now you can try it .
Just uninstall dotNet Framework from the PC on which you are deploying/testing you application , Restart the PC
then again install dotNet framewok perhaps from other source , Your Pervious may not work as i think some of the libraries are missing .
Best of luck

BindingContext

NormBohana19-Oct-05 8:44

NormBohana

19-Oct-05 8:44

I use the following code to move to the next record. I need to get the key field data of that record. Can someone please help, I have been reading and searching but I cannot find anything. I do not know how to use the DataRowView code, I think it gets me to the current row. But how do I get the data in a field?

this.BindingContext[dsAnimal1, "animal-info"].Position += 1;

DataRowView rv = (DataRowView)this.BindingContext[dsAnimal1, "animal-info"].Current;
DataRow r = rv.Row;

Auto-generating SQL to fill a DataSet

GazzaJ19-Oct-05 1:01

GazzaJ

19-Oct-05 1:01

I am writing an application where I am using strongly typed DataSets to define the DataTables and relations used in various parts of the application. I have code that takes these DataSets and converts the rows in the DataTables to objects which I then use in my application. The reason for using strongly typed DataSets is so if I change the database schema I only need to validate the DataSets to identify any mismatches at compilation time.

I obviously need to fill the DataSets which is currently done by creating SqlAdapters which call stored procedures to populate the DataTables within the DataSet. This means I have to keep the stored procedures in sync with the DataSets when the schema is changed. I am trying to minimise any potential bugs and so I am looking at ways to ensure the database schema, DataSets and stored procedures are kept in sync.

My current method is to use my own validation tool which performs tests on the DataSets to ensure the stored procedures correctly fill the DataSets.

Given the information contained within the DataSet I was thinking that it should be possible to "auto-generate" the SQL from the DataTables and DataRelations definitions. For a simple situation like Customers and Orders this is not difficult but I was wondering if there are any libraries or tools out there which generate SQL code from a DataSet definition given the complexity that may be involved with many tables and their relationships.

Re: Auto-generating SQL to fill a DataSet

miah alom19-Oct-05 4:01

miah alom

19-Oct-05 4:01

Check this out.

http://www.radsoftware.com.au/articles/usingcommandbuilder.aspx

debug sql stored procedure

nripin18-Oct-05 17:49

nripin

18-Oct-05 17:49

which is the easiest and most efficient means to debug stored procedures?
pls help

Re: debug sql stored procedure

Scott Serl19-Oct-05 6:55

Scott Serl

19-Oct-05 6:55

If you are talking about MS SQL Server:
Open SQL Query Analyzer, right click on your stored procedure, click on Debug. It will prompt you to input values for for the parameters, then you click Execute. It will let you single step through the stored proc, and has a window for current variable values.
If debugging is not enabled for your instance of SQL Server, you may have to install the option from cd. Also, it needs the SQL Server Agent service to be running.
To debug triggers, just write a stored proc which will cause a trigger to execute, then you can step into the trigger when debugging the stored proc.

Re: debug sql stored procedure

nripin19-Oct-05 17:55

nripin

19-Oct-05 17:55

thanks buddy Smile | :)

cheers

Re: debug sql stored procedure

nrps19-Oct-05 18:06

nrps

19-Oct-05 18:06

why do i get this error msg when i try to compile the stored procedure?

[Microsoft][ODBC SQL Server Driver]Invalid character value for cast specification

pls help Smile | :)

Query to get specific word in a column

JayaDurai18-Oct-05 2:05

JayaDurai

18-Oct-05 2:05

Hi,

I am need of a query to retrieve a column by trimming in a particular format.
For example I have a field called UserName. The data is as follows
UserName
--------
user1 (user1@noreply.com)
user2 (user2@noreply.com)
user3 (user3@noreply.com)

Here I want a query to retrieve username data as
user1
user2
user3
I have to trim the content from '(' to ')'

Please Let me know the query.

Thanks in Advance,
Jaya

Re: Query to get specific word in a column

miah alom18-Oct-05 3:52

miah alom

18-Oct-05 3:52

select substring(UserName,charindex('(',UserName), charindex(')',UserName)-charindex('(',UserName)) from UserTable

is the sybase syntax. The SQL Server syntax should be equivalent. Please check.

Re: Query to get specific word in a column

JayaDurai18-Oct-05 18:51

JayaDurai

18-Oct-05 18:51

Hi alam,
Thank you.
I tried your query. Its working fine.
The Query can be written as follows.

select LEFT(UserName,CHARINDEX('(',UserName)-1) FROM UserTable

Regards,
Jaya

Re: Query to get specific word in a column

under281120-Oct-05 0:06

under2811

20-Oct-05 0:06

Hi!!!!!!!

SELECT LEFT(USERNAME,PATINDEX('%(%',USERNAME)-1)

Enjoy!!!!

Regards

Shashank

Instanciate SQLXMLBulkLoad object

george ivanov18-Oct-05 1:07

george ivanov

18-Oct-05 1:07

How to instanciate SQLXMLBulkLoad object in C#?
I have SQL Server 2000 installed and added Microsoft.Data.SqlXml reference to the project, but I can't find any SQLXMLBulkLoad object in it.

What have to be installed to have SQLXMLBulkLoad object?

Re: Instanciate SQLXMLBulkLoad object

cmacgowan2-Dec-05 4:04

cmacgowan

2-Dec-05 4:04

Just to follow-up ...

If you are working in .NET C# for example you will need to add the reference to the SQLXML BulkLoad 3.0 Type Library.

(from the below refeences article)
http://www.dbazine.com/sql/sql-articles/cook3

... COM and the .NET Framework are two fundamentally different approaches to application development. COM type libraries must be converted to .NET assembly metadata to achieve COM interop in .NET. By using the Visual Studio .NET IDE, this can be done automatically by following the simple steps that follow. It is assumed that MSXML is already installed.

- Begin by going to the Visual Studio .NET menu bar and selecting Project, then Add Reference.

- From the Add Reference dialog box, select Microsoft SQLXML BulkLoad 3.0 Type Library from the list, click the Select button, and click OK to complete your selection.

- The necessary metadata is automatically generated. The COM object appears as a reference in the solution explorer.

- Use the Object Browser to see what’s available in the component. Go to the menu bar and select View, Other Windows, Object Browser.

- The Object Browser shows you the interfaces and members available.

The rest of the code would be as such ...

// A SQLXMLBulkLoad3 object must be instantiated. In C# use the following code:<br />
SQLXMLBULKLOADLib.SQLXMLBulkLoad3 bulkLoadObj = new SQLXMLBULKLOADLib.SQLXMLBulkLoad3Class();<br />
<br />
<br />
// Notice that the Object Browser reveals a ConnectionString property and an Execute method. The <br />
// ConnectionString property is a valid OLE DB connection string. In this example, a connection <br />
// is made to a SQL Server. Instead, the connection could have been to an <br />
// Oracle server. <br />
bulkLoadObj.ConnectionString = "Provider=SQLOLEDB;Data Source=localhost;" +<br />
                      "Integrated Security=SSPI;Initial Catalog=northwind";<br />
<br />
// The Execute method requires two parameters: a mapping schema file and the XML file to be bulk loaded.                      <br />
bulkLoadObj.Execute("C:/Locations.xsd", "C:/Locations.xml");

http://www.dbazine.com/sql/sql-articles/cook3

Peace and Love,
Chris Macgowan

Avg in SQL Statement

dabuskol17-Oct-05 23:36

dabuskol

17-Oct-05 23:36

Guys,

I have 3 records defined in the following fields
Company Date Type Amount
COA Sept-205 Cash 500.00
COB Oct-2005 Cash 20.00
COC Oct-2005 Cash 145.00
COD Oct-2005 Cash 0.0

I want to get the average amount per month.
SELECT date, avg(amount)
FROM COTABLE
GROUP BY date.

MY question is IF THE AMOUNT = 0.00 DO NOT INCLUDE IT IN GETTING THE AVERAGE PER MONTH.

In the scenario above, for the month of OCT: the AVERAGE is 55 becuase it's DIVIDED BY 3.

BUT It should be
20.00 + 145.00 = 165.00
165.00 / 2 = 82.5 SINCE the third amount is 0.0 it should not be included in the calculation.

Any help will do. Thanks

Re: Avg in SQL Statement

Marc Soleda17-Oct-05 23:49

Marc Soleda

17-Oct-05 23:49

Add a WHERE clause before the GROUP BY statement:

SELECT date, avg(amount)
FROM COTABLE
WHERE amount>0
GROUP BY date;

I hope it helps,

Marc Soleda.

... she said you are the perfect stranger she said baby let's keep it like this... Dire Straits

I used NVL fuction to convert the null value into 0 what is the equavalent thing in SQL server .

anishyanic17-Oct-05 23:33

anishyanic

17-Oct-05 23:33

thanks a lot for your answers.

Rgds
theepa

cumulative aggregate queries in transact-sql

smita_roy17-Oct-05 22:27

smita_roy

17-Oct-05 22:27

how do i generate cumulative aggregate queries in transact-sql

Re: cumulative aggregate queries in transact-sql

under281120-Oct-05 0:19

under2811

20-Oct-05 0:19

Hi!!!!

U can Enjoy with this.....

http://msdn.microsoft.com/library/default.asp?url=/library/en-s/tsqlref/ts_fa-fz_9yuk.asp

Regrads

Shashank
under2811@yahoo.co.in

connection string

kindkirk17-Oct-05 18:44

kindkirk

17-Oct-05 18:44

Help!
Can anybody show me the connection string required or point me to a link regarding this matter.
I need the public to connect to a Data Acces Page on a Web Site where the database is stored on a seperate folder.
I believe this is 3 tier connection and probibly RDS?
The ISP has provided a DSN name for DSN connection as well.

Many thanks
Wink | ;)

Re: connection string

S Douglas20-Oct-05 0:52

S Douglas

20-Oct-05 0:52

kindkirk wrote:
Can anybody show me the connection string required or point me to a link regarding this matter

You mean your going to open your SQL server for anyone to connect to? That’s a huge security risk, even if its password protected. OMG | :OMG:

Here is a link to ADO connection strings.
ADO Connection Strings[^]

DEBUGGING : Removing the needles from the haystack.

Re: connection string

Luis Alonso Ramos20-Oct-05 19:10

Luis Alonso Ramos

20-Oct-05 19:10

Try this, it's so cool!

http://www.connectionstrings.com[^]

I always go there to look for that SQL Server connection string I can never learn! Smile | :)

-- LuisR

Luis Alonso Ramos
Intelectix - Chihuahua, Mexico

Not much here: My CP Blog!

The amount of sleep the average person needs is five more minutes. -- Vikram A Punathambekar, Aug. 11, 2005

Last Visit: 31-Dec-99 18:00 Last Update: 19-Apr-24 4:29

Refresh

ᐊ Prev 1...2018 2019 2020 202120222023 2024 2025 2026 2027 Next ᐅ

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.