Questions tagged [query-analyzer]
74 questions
0
votes
1 answer
Compound word handling in solr
There are compound words, which can written as "hand bag" or "handbag". If we have "handbag" in solr index, then on searching "hand bag", how can I show the result of "handbag". I have tried with multi-word synonym parser. But for that I have to add…
Kamal Kishore
- 325
- 2
- 4
- 15
0
votes
2 answers
Getting error with CASE expression using WHERE clause
declare @SP nvarchar(3)
SELECT HDR.SOPNUMBE, HDR.docdate, HDR.pymtrmid,
RTRIM(HDR.ShipToName) +
CASE WHEN HDR.ADDRESS1 <> '' THEN char(10) + RTRIM(HDR.ADDRESS1) ELSE '' END
FROM vSOPHdr HDR
WHERE HDR.SOPTYPE = 2 AND
(CASE WHEN HDR.SLPRSNID <>…
Anirudh
- 581
- 5
- 14
- 32
0
votes
1 answer
Problem using Query Analyzer to debug stored procedure
I am attempting to debug a stored procedure using the Debug option is SQL Query Analyzer (Version 8.00). However, the debugger run through the whole stored procedure as soon as I start and if add a break-point and try re-executing the sp, the…
Yossi Klein
- 9
- 2
0
votes
1 answer
Solr: LowerCaseFilterFactory not applied in SpellCheckComponent
I'm struggling with the SpellCheckComponent in Solr (tested with solr 4.4 and 4.5). I have a field type defined as follows:
Mathias Bank
- 95
- 8
0
votes
2 answers
How can I query a SQL Server CE database on a handheld device?
In researching bugs, I often need to quickly see what data actually exists in the SQL Server CE database on the handheld device. Due to the tedious nature of keying in SQL statements on the device itself, how can I quickly run SQL statements to…
B. Clay Shannon-B. Crow Raven
- 8,547
- 144
- 472
- 862
0
votes
3 answers
How Oracle uses statistics data
In previous question I got comment about Oracle statistics:
Oracle doesn't know that 50M is greater than the number of rows. Sure, it has statistics, but they could be old and wrong - and Oracle would never allow itself to deliver an incorrect…
zendar
- 13,384
- 14
- 59
- 75
0
votes
1 answer
How to replace whitespace with and operator in solr query
I have implemented solr search o my site. When I search the query "Red Shoes", it is showing results for both Red and shoes. But I wants solr to show those records which contains both keywords "Red" and "Shoes". It it related to whitespace tokenizer…
Kamal Kishore
- 325
- 2
- 4
- 15
0
votes
1 answer
Sitecore Query Language: Update + Where
I am trying use Sitecore Query Language through Sitecore Rocks Query Analyzer to update a bunch of items to a new Workflow, while maintaining the current state. I current have this:
update set @#__Workflow state# = "--GUID of the workflow state--"…
Tyler V.
- 2,471
- 21
- 44
0
votes
1 answer
SQL Server open source query analyzer
My team is going to be working on some internal tools for various teams in our department, and there are a number of database-specific tasks I'd like to support (SQL Server 2008 R2/SQL Server 2012).
I don't want to spend a bunch of time duplicating…
fussmonkey
- 606
- 5
- 19
0
votes
2 answers
sql server 2000: Short cut for getting stored proc text
what is the short cut to get entire text of the stored proc in query analyzer. I know that I could highlight table name and hit alt + F1 and get the entire table structure.
dotnet-practitioner
- 13,968
- 36
- 127
- 200
0
votes
2 answers
Can Visual Studio 2008 provide any of the functionality that Query Analyzer and Enterprise Manager provide?
I'm currently using MSSQL Server 2000 and to design tables, create and alter stored procedures as well as manage users and permissions I'm using Query Analyzer and Enterprise Manager. I also spend an awful lot of time in Visual Studio 2008 and…
Jonathon Watney
- 20,248
- 9
- 38
- 40
0
votes
1 answer
Is there a query analyzer in SQL Server 2005 Express edition?
I have downloaded the SQL Server 2005 Express edition and I was not able to fine query analyzer to run the queries or design the database.
developer
- 9,116
- 29
- 91
- 150
0
votes
1 answer
MS SQL 2008 R2 Queryanalyzer successful run in the code. Failed SQL code field within the LOGO application is running
MS SQL 2008 R2 Queryanalyzer successful run in the code. Failed SQL code field within the LOGO application is running.
Error :
" The order by clause is invalid in views, inline functions,derived tables,subqueries and common table expressions,unless…
Ersoy AYDIN
- 1
- 3
-2
votes
1 answer
Why is my SQL Server CE table undroppable in Query Analzyer?
I tried dropping a SQL Server CE table using both:
drop invHeader
-and:
drop [invHeader]
...in Query Analyzer, but in both cases, I get the same err msg:
Dropping a table should be drop-dead easy, but this one keeps bouncing back up, like a…
B. Clay Shannon-B. Crow Raven
- 8,547
- 144
- 472
- 862