|
I've got a method that uses sp_sproc_columns to find all parameters that need to be send for a stored procedure.
My question is how can I do something similar for inline SQL querys?
I want to get a list of the parameters the query is expecting.
Would ...
Started by CD on
, 5 posts
by 5 people.
Answer Snippets (Read the full thread at stackoverflow):
It might be more complex than you expect, especially if your SQL is rude enough to contain things like:
internally executing a stored procedure using named parameters; for example EXEC MyProc @foo = @localArg... .
I suspect you would have to fully parse the SQL .
|
|
I've got a simple select query which executes in under 1 second normally, but when I add in a contains(column, 'text') into the where clause, suddenly it's running for 20 seconds up to a minute. The table it's selecting from has around 208k rows.
Any ...
Started by Robin on
, 4 posts
by 4 people.
Answer Snippets (Read the full thread at stackoverflow):
There's a....
CONTAINS does a lot of extra work.
Is the field indexed? If this is a major feature implementation, consider a search-caching table so you can simply lookup where the words exist .
Substring matching is a computationally expensive operation.
|
|
How do you put two different function outputs from the same controller into the same view(page)? For example, I have a function going to the "article" div, and another function that I am trying to use within the "aside" div. (using HTML 5 nomenclature...
Started by Brad on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at stackoverflow):
That means that all of your model data is added to a single $data variable, using different... .
To use a view twice on a page, or use two different views from one controller route, call $this->load->view() once for each view, but passing $data only once .
|
Ask your Facebook Friends
|
Hi all,
Another question about databases, I've a programme which recives a value that is a wieght via bluetooth and stores it in a database, the scales are my own creation and send the wieght in kgs, at the moment in this format "000.0" ie 1kg would be...
Started by geoffers on
, 14 posts
by 3 people.
Answer Snippets (Read the full thread at nokia):
I would check some basics such as character encoding and if you are missing some delimeter/field seprator from database Thanks for reply,
Sorry if I was a little vauge?... .
So you have custom database? You are not giving too much information to work with .
|
|
Im fastly reaching the stage where I have to look at plumbing, inside Im merely having a small sink with freshwater tap and drainage for this, Im not fussed on hot water or a toilet, I dont have room to fit a dyke, I figure when were touring most of the...
Started by dropbear68 on
, 17 posts
by 7 people.
Answer Snippets (Read the full thread at busaustralia):
So....
Mans gotta have a cold beer at the end of a hard days drive .
Beer on tap is a great idea Hey dont larf Eagle I was seriously thinking about a small fridge with a small keg full of home brew with a tap on the front, Ive seen it done it works a treat .
|
|
I have a query that when ran I would like it to ask for input. I need it to show one of the records that is required for eveyone all of the time, and still ask for input for additional records that are only required for a selected few.
Example:
Show "...
Started by SFCMatthews on
, 4 posts
by 2 people.
Answer Snippets (Read the full thread at access-programmers):
You will need to change [YourFieldNameHere....
Create a new element in your query like this:
ValidData: IIf([YourFieldNameHere]='A' OR [YourFieldNameHere]=[Input Your Query Criteria Here], 1,0)
Then underneath in the criteria section put a 1.
|
|
On Thu, 5 Jun 2008 09:36:01 -0700, Stacy <Stacy@discussions.microsoft.com
How do you query two sperate cross tab querys to make one query?
Started by Stacy on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at omgili):
Sperate cross tab querys to make one query? On Fri, 06 Jun 2008 06:50:11 -0400, John Spencer < query two sperate cross tab querys to make one query?.
|
|
On Mon, 20 Apr 2009 15:34:34 -0500, "Craig Brandt" <brandtcraig@att.net
I need several questions answered and the answer might be the same for both
questions.
I have a routine that goes out and pulls in data (historical data for a
number of stocks...
Started by Craig Brandt on
, 7 posts
by 2 people.
Answer Snippets (Read the full thread at omgili):
It looks like the querys are constantly refreshing, even though I
told it not to auto refresh.
When I select Querys sheet, it switches to 99%
Excel.exe.
Manager-processes, the
system is 99% in idle.
|
|
Hi,
Is possible to log querys wich takes a long time to run. Since 2 days
my server slows down with no explanation for 15-20 second after that
all goes well but after x minutes othe time the server slows down and
i dont know what query can cause this....
Started by danielpila@gmail.com on
, 3 posts
by 2 people.
Answer Snippets (Read the full thread at omgili):
Here is one that will
give you the TOP 10 slowest... .
On Fri, 03 Apr 2009 11:57:29 -0400, Plamen Ratchev <Plamen@SQLStudio.com
On SQL Server 2005 you can use the dynamic management objects to
directly gather info about slow running queries.
|
|
Posted 22 April 2012 - 01:45 AM
Hallo mede cachers,
Een vraagje: hoe lang blijven pocket querys beschikbaar?
Had er afgelopen maandag een paar gemaakt die ik net in GSAK wilde zetten maar die waren al verdwenen. Dacht nl dat ze een week bleven staan. ...
Started by Jerenemas on
, 5 posts
by 3 people.
Answer Snippets (Read the full thread at groundspeak):
Overigens kan je gsak heel makkelijk opdracht geven om de pq's .
Net daarnaast staat 'pocket querys ready for download'.
Je komt dan automatisch in het tabje 'active pocket querys'.
Op pocket querys.
|
