|
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.
|
|
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 .
|
Ask your Facebook Friends
|
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.
|
|
Hi,
I have a table with multiple Lookup fields . I am trying the create an append query to copy data from this source table to another table.
From the fields that are lookups in the source, I end up with a number in that field in the target table, instead...
Started by Birdman895 on
, 6 posts
by 3 people.
Answer Snippets (Read the full thread at access-programmers):
One of the things....
See here for why:
www.mvps.org/access/lookupfields.htm
Get rid of them and then all will work right .
Get rid of lookups at table level.
This is your first, and biggest, error.
|
|
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.
|
|
On Thu, 28 May 2009 14:57:46 +0200, Fabien <UrbaniakFabienxxxx@Neuf.fr
FTH a écrit :
Je propose une procédure qui te donne le nom de chaque requête de ta
base et pour chacune tu utilises un replace pour changer le nom du champ
Sub Remplace_dans...
Started by Fabien on
, 10 posts
by 2 people.
Answer Snippets (Read the full thread at omgili):
Glup
Ceci dit, les champs odifier apparaissent dans MSysQueries.expression et
je ne... .
Ps d'erreur qui s'affichent mas un blocage de l'appli..
On Wed, 3 Jun 2009 14:49:49 +0200, "FTH" <fth@fth
Bonjour Fabien,
je test mais pas avec bcp de succes .
|
|
On Mon, 27 Apr 2009 16:57:17 GMT, "Skypilot via AccessMonster.com" <u50870@uwe
I used your #1 idea and created two subforms and place them over one another.
Each subform looks and the query i need it to. So after the criteria is
selected from the...
Started by Skypilot via AccessMonster.com on
, 3 posts
by 2 people.
Answer Snippets (Read the full thread at omgili):
On Mon, 27 Apr 2009 10:31:02 -0700, Ken Sheridan <KenSheridan@discussions.microsoft.com
If the subform's RecordSource is the query and the subform is not linked to
the parent form by means of the LinkMasterFields and LinkChildFields
properties....
|
