|
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
|
|
|
|
|
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
|
|
|
|
|
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 
|
|
|
|
|
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.
|
|
|
|
|
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
|
|
|
|
|
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!!
|
|
|
|
|
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
|
|
|
|
|
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
|
|
|
|
|
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.
<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>
|
|
|
|
|
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
|
|
|
|
|
Those redirected pages contain some coded information, they too don't have any direct mp3 link.
|
|
|
|
|
I'm sorry, seems I cannot help here.
Bastard Programmer from Hell 
|
|
|
|
|
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...
|
|
|
|
|
select * from tablename where startdate>=@startDate and enddate<=@endDate
Initialize parameters
@startDate and
@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.
|
|
|
|
|
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.
|
|
|
|
|
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
|
|
|
|
|
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
|
|
|
|
|
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.
|
|
|
|
|
Sorry, but this is a technical forum, it's unlikely we can offer useful career guidance. You need to decide these things for yourself based on your knowledge, experience and the job vacancies open to you.
Binding 100,000 items to a list box can be just silly regardless of what pattern you are following. Jeremy Likness
|
|
|
|
|
Yes sure..being a newbie to technology..you can opt whatever strikes you better.
SQL is also a good option.
- Happy Coding -
Vishal Vashishta
|
|
|
|
|
You need to do whatever it is you enjoy. Do not let the market determine what you decide on. It is ever changing.
There are only 10 types of people in the world, those who understand binary and those who don't.
|
|
|
|
|
well, It is also a good option and later on you can master other skills as well like SSIS,SSRS etc..
regards
Vatsa
www.objectiveprogramming.com
|
|
|
|
|
I want to learn complicated store procedure. I have needed some table and different and complicated syntax of store procedure as example where I show result to execute syntax.
|
|
|
|
|
And you question is what?
First you need a complicated data structure to work with, then you need a detailed requirement and then you need to work through examples, read books and learn TSQL (or the flavour of the database you choose to work with).
Good luck!
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
See here[^] for some useful sources.
Binding 100,000 items to a list box can be just silly regardless of what pattern you are following. Jeremy Likness
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
