See If Stored Proc Returns Data - Database Discussion Boards

Re: Read LFD(log ) file SQLserver 2008

jojoba201112-May-12 22:31

jojoba2011

12-May-12 22:31

Thanks for reply!
I have create App. and trace everything in SQL but I cannot trace SP and ... that will call from C#.
I mean when i call SP in C# it doesnt trace.

<br />
//را یکبار اجرا نمایید SP این trace ابتدا باید برای فعال کردن<br />
           declare @TraceId int<br />
           -- create the trace<br />
           exec sp_trace_create @TraceId output, 0, N'C:\Temp\OurDemoTrace'<br />
           -- set event and columns to trace<br />
           exec sp_trace_setevent @TraceId, 12, 1, 1<br />
           exec sp_trace_setevent @TraceId, 12, 6, 1<br />
           exec sp_trace_setevent @TraceId, 13, 1, 1<br />
           exec sp_trace_setevent @TraceId, 13, 6, 1<br />
           -- start the trace<br />
           exec sp_trace_setstatus @TraceId, 1<br />
           -- check status for our trace<br />
           select value from fn_trace_getinfo(@TraceId) where property in (2, 5)<br />
           go<br />
              <br />

<pre lang="c#">sb.AppendLine("\nEventClass: " + ts.GetString(ts.GetOrdinal("EventClass")));
                            sb.AppendLine("NTUserName: " + ts.GetString(ts.GetOrdinal("NTUserName")));
                            sb.AppendLine("Command : " + ts.GetString(ts.GetOrdinal("TextData")));

modified 13-May-12 4:56am.

Re: Read LFD(log ) file SQLserver 2008

Eddy Vluggen13-May-12 4:08

Eddy Vluggen

13-May-12 4:08

jojoba2011 wrote:
and trace everything in SQL but I cannot trace SP and ... that will call from C#.

I mean when i call SP in C# it doesnt trace.

Not quite everything; stored procedures have their own trave_event, specifically SP:StmtStarting (44) and SP:StmtCompleted (45). A complete list of events can be found here[^].

Bastard Programmer from Hell Suspicious | :suss:

Re: Read LFD(log ) file SQLserver 2008

jojoba201113-May-12 19:22

jojoba2011

13-May-12 19:22

thanks a lot <big>Eddy Vluggen.</big>
Your really an export in SQL.

I have use this for SP:

SQL

declare @TraceId int
           -- create the trace
           exec sp_trace_create @TraceId output, 0, N'C:\Temp\SQLLog'
           -- set event and columns to trace
           exec sp_trace_setevent @TraceId, 12, 1, 1
           exec sp_trace_setevent @TraceId, 12, 6, 1
           exec sp_trace_setevent @TraceId, 13, 1, 1
           exec sp_trace_setevent @TraceId, 13, 6, 1
           exec sp_trace_setevent @TraceId, 12, 13, 1
            exec sp_trace_setevent @TraceId, 12, 10, 1
           exec sp_trace_setevent @TraceId, 12, 13, 1
           exec sp_trace_setevent @TraceId, 12, 14, 1
           exec sp_trace_setevent @TraceId, 12, 15, 1
            exec sp_trace_setevent @TraceId, 13, 10, 1
           exec sp_trace_setevent @TraceId, 13, 13, 1
           exec sp_trace_setevent @TraceId, 13, 14, 1
           exec sp_trace_setevent @TraceId, 13, 15, 1
           exec sp_trace_setevent @TraceId, 12, 35, 1
           exec sp_trace_setevent @TraceId, 13, 35, 1
           exec sp_trace_setevent @TraceId, 44, 10, 1
           exec sp_trace_setevent @TraceId, 44, 13, 1
           exec sp_trace_setevent @TraceId, 44, 14, 1
           exec sp_trace_setevent @TraceId, 44, 15, 1
            exec sp_trace_setevent @TraceId, 44, 1, 1
           exec sp_trace_setevent @TraceId, 44, 6, 1
             exec sp_trace_setevent @TraceId, 44, 35, 1
           exec sp_trace_setevent @TraceId, 45, 35, 1
          exec sp_trace_setevent @TraceId, 45, 10, 1
           exec sp_trace_setevent @TraceId, 45, 13, 1
           exec sp_trace_setevent @TraceId, 45, 14, 1
           exec sp_trace_setevent @TraceId, 45, 15, 1
            exec sp_trace_setevent @TraceId, 45, 1, 1
           exec sp_trace_setevent @TraceId, 45, 6, 1

           -- start the trace
           exec sp_trace_setstatus @TraceId, 1
           -- check status for our trace
           select value from fn_trace_getinfo(@TraceId) where property in (2, 5)
           go

and in C#

sb = new StringBuilder();
                            sb.AppendLine("\nEventClass: " + ts.GetString(ts.GetOrdinal("EventClass")));
                            sb.AppendLine("NTUserName: " + ts.GetString(ts.GetOrdinal("NTUserName")));
                            sb.AppendLine("Command : " + ts.GetString(ts.GetOrdinal("TextData")));

I have done about 90 percent:

but when i run any SP in SQL Management it returns exactly the SP witch have exec in LOG like bellow :

SQL

INSERT INTO tblGroups
                      (GroupName, GroupFatherId)
VALUES     ('Friends',1)

SQL

DECLARE	@return_value int

EXEC	@return_value = [dbo].[InsertGroups]
		@GroupName = N'ali joon',
		@GroupFatherId = 1

SELECT	'Return Value' = @return_value

But when i run SP in C# it only return the <big>SP Code</big>.like bellow:

SQL

INSERT INTO tblGroups
                      (GroupName, GroupFatherId)
VALUES     (@GroupName,@GroupFatherId)

<big>But i wanna to have this also :</big>

SQL

INSERT INTO tblGroups
                      (GroupName, GroupFatherId)
VALUES     ('Friends',1)

SQL

DECLARE	@return_value int

EXEC	@return_value = [dbo].[InsertGroups]
		@GroupName = N'ali joon',
		@GroupFatherId = 1

SELECT	'Return Value' = @return_value

modified 14-May-12 3:51am.

Re: Read LFD(log ) file SQLserver 2008

jojoba201115-May-12 5:11

jojoba2011

15-May-12 5:11

No ans for my Question!

Re: Read LFD(log ) file SQLserver 2008

Eddy Vluggen16-May-12 2:06

Eddy Vluggen

16-May-12 2:06

jojoba2011 wrote:
No ans for my Question

You do realize that we're volunteers here?

I know that Sql-profiler can see the parameters, I assume that they're also there for a trace. I don't have an answer ready for this question.

Bastard Programmer from Hell Suspicious | :suss:

Re: Read LFD(log ) file SQLserver 2008

JohnPayton22-May-12 19:18

JohnPayton

22-May-12 19:18

Here have a 5 for patience and being...

C++

really an export in SQL

Re: Read LFD(log ) file SQLserver 2008

Eddy Vluggen23-May-12 0:13

Eddy Vluggen

23-May-12 0:13

Thanks for exporting me Cool | :cool:

See If Stored Proc Returns Data

Kevin Marois3-May-12 10:51

Kevin Marois

3-May-12 10:51

I need to check hundreds of sprocs to see if they return data. So, I need to know if the proc

[] Returns a dataset
[] Returns a scalar
[] Runs some other type of command (INSERT, UPDATE, DELETE)

Is it possble to determine this in SQL? Can SQL tell me the result of the query?

Everything makes sense in someone's mind

Re: See If Stored Proc Returns Data

Mycroft Holmes3-May-12 12:40

Mycroft Holmes

3-May-12 12:40

Kevin Marois wrote:
Can SQL tell me the result of the query

Not without executing the code.

Never underestimate the power of human stupidity
RAH

Re: See If Stored Proc Returns Data

Eddy Vluggen4-May-12 0:01

Eddy Vluggen

4-May-12 0:01

You can get the body-text of the sproc, and see if it contains a "RETURN" statement. That does not mean that the sproc actually returns something, that will depend on the logic.

Return types will be defined for functions, not for sprocs.

Bastard Programmer from Hell Suspicious | :suss:

Re: See If Stored Proc Returns Data

Corporal Agarn7-May-12 7:21

Corporal Agarn

7-May-12 7:21

You would have to go into each procedure as you can return data with a select statement, thus looking for just return will not work.

Re: See If Stored Proc Returns Data

vvashishta10-May-12 4:46

vvashishta

10-May-12 4:46

Create Params passed to a Store Proc.. as local variables in Debug Code,,, and to check whether a SP returns data, execute the SP with those local variable with specified values.. by marking comment on Create or Alter Command on SP

- Happy Coding -
Vishal Vashishta

Playing music on my end, with APIs of search engines

Neha.prakash882-May-12 21:52

Neha.prakash88

2-May-12 21:52

I want to create a web application, in which it searches the API available in various sites like playme.com,freemusicarchive.org and plays mp3 at my end.

By using web services of these websites I am just getting the URLs which doesn't point to any specific mp3. So how will I write the code for player which I have prepared in my website.

I have searched several websites like beemp3.com they have the functionality, same I want to achieve for my website. Please help!!

Re: Playing music on my end, with APIs of search engines

Richard MacCutchan2-May-12 22:24

Richard MacCutchan

2-May-12 22:24

This has nothing to do with databases and you already posted the question here[^]. Please post in one forum only.

Binding 100,000 items to a list box can be just silly regardless of what pattern you are following. Jeremy Likness

Re: Playing music on my end, with APIs of search engines

Eddy Vluggen4-May-12 0:04

Eddy Vluggen

4-May-12 0:04

Neha.prakash88 wrote:
By using web services of these websites I am just getting the URLs which doesn't
point to any specific mp3.

Probably a "redirect" url that points to something that points to your MP3. The API's will probably not be all the same for the websites you named.

Neha.prakash88 wrote:
I have searched several websites like beemp3.com they have the functionality,
same I want to achieve for my website. Please help!!

If you are stuck on a specific problem, or if there's some code that we can review. Right now, the question is too broad.

Bastard Programmer from Hell Suspicious | :suss:

Re: Playing music on my end, with APIs of search engines

Neha.prakash884-May-12 0:19

Neha.prakash88

4-May-12 0:19

This is an XML file provided by http://freemusicarchive.org[^] in this at the place of track URl they have provided http://freemusicarchive.org/music/Alastair_Cameron/Free_Film_Music_cameronmusiccouk/gentle_marimba[^], which is opening some page which contains a mp3 file which we can listen.

My problem is that I want to play that music at my website, I don't want to redirect to any any other website. I want that user just click on play button and it start playing, without showing the actual website which is hosting the song.

XML

<value>
<track_id>55860</track_id>
<track_title>gentle marimba</track_title>
<track_url>
http://freemusicarchive.org/music/Alastair_Cameron/Free_Film_Music_cameronmusiccouk/gentle_marimba
</track_url>
<track_image_file/>
<artist_id>12203</artist_id>
<artist_name>Alastair Cameron</artist_name>
<artist_url>
http://freemusicarchive.org/music/Alastair_Cameron/
</artist_url>
<artist_website>http://www.cameronmusic.co.uk/</artist_website>
<album_id>10345</album_id>
<album_title>Free Film Music (cameronmusic.co.uk)</album_title>
<album_url>
http://freemusicarchive.org/music/Alastair_Cameron/Free_Film_Music_cameronmusiccouk/
</album_url>
<license_title>Creative Commons Attribution</license_title>
<license_url>http://creativecommons.org/licenses/by/3.0/</license_url>
<track_language_code/>
<track_duration>01:44</track_duration>
<track_number>0</track_number>
<track_disc_number>1</track_disc_number>
</value>

Re: Playing music on my end, with APIs of search engines

Eddy Vluggen4-May-12 0:26

Eddy Vluggen

4-May-12 0:26

In that case you'll have to fetch the redirect-page, read it, figure out where the MP3 is actually located and then fetch that mp3.

Bastard Programmer from Hell Suspicious | :suss:

Re: Playing music on my end, with APIs of search engines

Neha.prakash884-May-12 0:29

Neha.prakash88

4-May-12 0:29

Those redirected pages contain some coded information, they too don't have any direct mp3 link.

Re: Playing music on my end, with APIs of search engines

Eddy Vluggen4-May-12 0:39

Eddy Vluggen

4-May-12 0:39

I'm sorry, seems I cannot help here.

Bastard Programmer from Hell Suspicious | :suss:

check date range in between date range

RA|-|UL PATEL2-May-12 20:58

RA|-|UL PATEL

2-May-12 20:58

Hello friends,

I need query which will check user supplied date range is in between the existing table startdate and enddate.
if any of the date of user supplied date range is in between the tables start date and end date,it should retrun that record from table.

for example user supply date range is from 1 may 2012 to 5 may 2012.
then query must check that
1 may 2005
2 may 2005
3 may 2005
4 may 2005
5 may 2005
(all dates) is in between startdate and enddate of existing table.

please reply...Thanx in advance...

Re: check date range in between date range

Blue_Boy2-May-12 21:27

Blue_Boy

2-May-12 21:27

SQL

select * from tablename where startdate>=@startDate and enddate<=@endDate

Initialize parameters

SQL

@startDate

and

SQL

@endDate

with values

I Love T-SQL
"VB.NET is developed with C#.NET"
If my post helps you kindly save my time by voting my post.

Re: check date range in between date range

jschell3-May-12 8:42

jschell

3-May-12 8:42

Blue_Boy wrote:
where startdate>=@startDate and enddate<=@endDate

Probably not a good idea. One end should be inclusive and the other exclusive, for example.

where startdate>=@startDate and enddate<@endDate

The reason for this is that for a range check you do not want the same value to show up twice in two 'different' ranges.

Re: check date range in between date range

Vishal D Kolekar4-May-12 2:19

Vishal D Kolekar

4-May-12 2:19

SELECT *
FROM tablename
where insertdate BETWEEN @startDate and @endDate

this is simple but it won't contain @endDate in result set.
For that you need to use DATEADD(datepart, number, date) fuction
Since your query will be

SELECT *
FROM tablename
WHERE insertdate BETWEEN @startDate and DATEADD(d,1,@endDate)

Thanks,
Vishal K

Re: check date range in between date range

vvashishta10-May-12 4:50

vvashishta

10-May-12 4:50

Instead of usign Between Operator, you should use FromDate >= @FromDate
AND EndDate < DateAdd(D, 1, @EndDate )
(It always perform the accurate process, specially in case when Date Column accepts dates also)

Remember EndDate must work with LessThan and FromDate performs on GreaterThanEqualTo

- Happy Coding -
Vishal Vashishta

career Sql developer

Arul R Ece29-Apr-12 20:36

Arul R Ece

29-Apr-12 20:36

I have knowledge in

Basic SQL queries.

SP

function

view

Triggers

shall i chose my career as sql developer side

Thanks & Regards

Arul.R

"The greatest lesson of life is that you are responsible for your life."

modified 30-Apr-12 3:09am.

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