|
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
|
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
, 16 posts
by 6 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 made this noob post because i don't like ask for help and don't contribute with something
there you got some poor querys . maybe you need it .
3 faces of inventory for a specific character
PHP Code: use SRO_VT_SHARD_INIT
update dbo . _Char
set InventorySize...
Started by thepronto on
, 5 posts
by 5 people.
Answer Snippets (Read the full thread at ragezone):
Nice Queries
what do u mean by changing D12 to D13 >> do u mean to add D13 in your files or to make some upgrade system
or what !! Share Share this post on Digg Del.icio.us Technorati Twitter Facebook Reddit! Max InventorySize 109 Share Share....
|
|
Hope you guys don't mind if ask one or two questions.
1. How much leisure time do you have? Can you leave post for the weekends.
2. How good are the facilities, especially sports wise.
3. How long is the period in basic training where I can not bring ...
Started by Cornflakes on
, 5 posts
by 3 people.
Answer Snippets (Read the full thread at arrse):
You don't really....
Originally Posted by geoffafa As far as I'm aware- You can't leave camp for the first 6 weeks .
You don't really have time for sports during basic, it's a very busy 14 weeks .
As far as I'm aware- You can't leave camp for the first 6 weeks .
|
|
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?.
|
|
Geschrieben 20.01.2012 - 22:58
Hallo, habe ein paar Querys gemacht - da sich die Gebiete überschneiden habe ich wohl einige GC mehrfach gespeichert!
Wie, wo kann ich die GC der versch. Querys herunterladen, sortieren, löschen wo mehrfach vorhanden und...
Started by cratello on
, 7 posts
by 6 people.
Answer Snippets (Read the full thread at swissgeocache):
1) neue DB anlegen
2) PQ in DB laden
3) Sortieren, löschen, filtern nach Wunsch
Fürs 60er:
4) GPS anhängen... .
Geschrieben Gestern, 07:58
Ja, dieses Problem kannst Du mit GSAK (gsak.net) sehr schön lösen .
Geschrieben 20.01.2012 - 23:11
Schau die mal GSAK an.
|
|
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.
|
