We currently are saving WordML (Word 2003's XML format rather than binary
format) docs into a column of our SQL Server 2005 database and full text
indexing on it. Works okay, but not great. For example, all the XML tags
are indexed... so you find many words that are not in the document (from the
user persepctive).
The fix for that is clear... use an XML filter. (Though how to do that is
not so clear... we tried moving the WordML from a Text column to an XML
column, but it gives errors on illegal characters in the Word doc.)
However, it would seem that even an XML filter will not do nearly as well as
a filter designed for WordML.
Can anyone point me to a WordML full-text-search filter for SQL Server
2005?
Thanks,
Brian
Have you tried storing them as doc's in varbinary (max) or image columns and
indexing them with the Word iFilter.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Brian" <TargetedConvergence@.newsgroup.nospam> wrote in message
news:%23bHGZ5idHHA.4616@.TK2MSFTNGP03.phx.gbl...
> We currently are saving WordML (Word 2003's XML format rather than binary
> format) docs into a column of our SQL Server 2005 database and full text
> indexing on it. Works okay, but not great. For example, all the XML tags
> are indexed... so you find many words that are not in the document (from
> the user persepctive).
> The fix for that is clear... use an XML filter. (Though how to do that is
> not so clear... we tried moving the WordML from a Text column to an XML
> column, but it gives errors on illegal characters in the Word doc.)
> However, it would seem that even an XML filter will not do nearly as well
> as a filter designed for WordML.
> Can anyone point me to a WordML full-text-search filter for SQL Server
> 2005?
> Thanks,
> Brian
>
|||"Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
news:u2u%23lFjdHHA.4656@.TK2MSFTNGP06.phx.gbl...
> Have you tried storing them as doc's in varbinary (max) or image columns
> and indexing them with the Word iFilter.
No, for our app we need to keep them as .xml files, not .doc files.
But we could put the Word .xml file in a varbinary column if there is a
WordML iFilter out there that would act on the .xml file.
Thanks,
Brian
|||Hi Brian,
have you tried storying your WordML files in an a column of type XML? That
should invoke the XML filter.
Best regards,
-Denis.
"Brian" wrote:
> "Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
> news:u2u%23lFjdHHA.4656@.TK2MSFTNGP06.phx.gbl...
>
> No, for our app we need to keep them as .xml files, not .doc files.
> But we could put the Word .xml file in a varbinary column if there is a
> WordML iFilter out there that would act on the .xml file.
> Thanks,
> Brian
>
>
|||"denistc" <denistc@.discussions.microsoft.com> wrote in message
news:64C9346C-881C-4FC5-928C-1C7751ACECA6@.microsoft.com...
> have you tried storying your WordML files in an a column of type XML? That
> should invoke the XML filter.
Yes, though we've had trouble with some WordML files being rejected.
We've narrowed the issue on that front... any WordML file that has "UTF-8"
in the docheader gets rejected... not sure why though. Also not sure why
Word is creating some files with that encoding. Simply removing the tag
from the docheader (without any other re-encoding) seems to work fine, oddly
enough.
We're a bit nervous to move to the XML column until we understand what
conditions might cause XML to reject a WordML doc coming out of Word...
because without that understanding, we can't be sure it won't happen to our
customers.
Thanks for the suggestion,
Brian
|||"Brian" <TargetedConvergence@.newsgroup.nospam> wrote in message
news:%23OqdVzFgHHA.2396@.TK2MSFTNGP04.phx.gbl...
> Yes, though we've had trouble with some WordML files being rejected.
> We've narrowed the issue on that front... any WordML file that has "UTF-8"
> in the docheader gets rejected... not sure why though. Also not sure why
> Word is creating some files with that encoding. Simply removing the tag
> from the docheader (without any other re-encoding) seems to work fine,
> oddly
> enough.
Haven't done much with WordML myself, but assuming the WordML file has
"UTF-8" in the docheader, I'd be interested to know if it actually is a
UTF-8 file? Or is it possible it is being saved with an incorrect BOM or
invalid (non-UTF-8-encoded) characters in the doc? One of those two would
be my first guess. If so, that might be a bug that needs to be reported to
MS. You might try opening that WordML file in a hex editor to verify what
is actually being stored.
Thursday, March 29, 2012
filter for SQL commad ?
I dont know to write SQL command filter.
m_strQueryDelete.Format("DELETE FROM tab WHERE (Col1 = abc AND Col2
= abc AND ??)"
example: ODBC found 100 records.
I need to delete first 90 records and to leave last 10 records.
Thank you
Joseph
Posted using the http://www.dbforumz.com interface, at author's request
Articles individually checked for conformance to usenet standards
Topic URL: http://www.dbforumz.com/Client-filte...ict259609.html
Visit Topic URL to contact author (reg. req'd). Report abuse: http://www.dbforumz.com/eform.php?p=894697
Is there a unique field in the table, where you could write a query
like:
DELETE FROM TAB WHERE UNIQUE_FIELD IN
(SELECT TOP 90 UNIQUE_FIELD FROM TAB WHERE (COL1= 'ABC' AND COL2='ABC'
AND ??))
Good luck,
Tony Sebion
"Joseph" <UseLinkToEmail@.dbForumz.com> wrote in message
news:4_894697_c2b2ed0878532c267d72ee72a1e9aff5@.dbf orumz.com:
> I don't know to write SQL command filter.
> m_strQueryDelete.Format("DELETE FROM tab WHERE (Col1 = 'abc' AND Col2
> = 'abc' AND ??)"
> example: ODBC found 100 records.
> I need to delete first 90 records and to leave last 10 records.
> Thank you
> Joseph
> --
> Posted using the http://www.dbforumz.com interface, at author's request
> Articles individually checked for conformance to usenet standards
> Topic URL: http://www.dbforumz.com/Client-filte...ict259609.html
> Visit Topic URL to contact author (reg. req'd). Report abuse: http://www.dbforumz.com/eform.php?p=894697
sql
m_strQueryDelete.Format("DELETE FROM tab WHERE (Col1 = abc AND Col2
= abc AND ??)"
example: ODBC found 100 records.
I need to delete first 90 records and to leave last 10 records.
Thank you
Joseph
Posted using the http://www.dbforumz.com interface, at author's request
Articles individually checked for conformance to usenet standards
Topic URL: http://www.dbforumz.com/Client-filte...ict259609.html
Visit Topic URL to contact author (reg. req'd). Report abuse: http://www.dbforumz.com/eform.php?p=894697
Is there a unique field in the table, where you could write a query
like:
DELETE FROM TAB WHERE UNIQUE_FIELD IN
(SELECT TOP 90 UNIQUE_FIELD FROM TAB WHERE (COL1= 'ABC' AND COL2='ABC'
AND ??))
Good luck,
Tony Sebion
"Joseph" <UseLinkToEmail@.dbForumz.com> wrote in message
news:4_894697_c2b2ed0878532c267d72ee72a1e9aff5@.dbf orumz.com:
> I don't know to write SQL command filter.
> m_strQueryDelete.Format("DELETE FROM tab WHERE (Col1 = 'abc' AND Col2
> = 'abc' AND ??)"
> example: ODBC found 100 records.
> I need to delete first 90 records and to leave last 10 records.
> Thank you
> Joseph
> --
> Posted using the http://www.dbforumz.com interface, at author's request
> Articles individually checked for conformance to usenet standards
> Topic URL: http://www.dbforumz.com/Client-filte...ict259609.html
> Visit Topic URL to contact author (reg. req'd). Report abuse: http://www.dbforumz.com/eform.php?p=894697
sql
filter for profiler
Hi ,
How can i actually use the filter for profiler
i have set up the profiler with a filter using the object_name ( as like
"tb_transaction" w/o the quotes) and i have also bring out the object_name
column and make it into a group
however, it seems not to be work. i have tested with statements like "select
* from tb_transaction" and "select * from tb_customer" and both statements
were shown in the profiler and the column object_name is always empty
appreciate ur kind advice
tks & rdgs
Message posted via http://www.droptable.comHi
Object_name is not always recorded, using the object_id and database_id will
give you better results.
John
"maxzsim via droptable.com" wrote:
> Hi ,
> How can i actually use the filter for profiler
> i have set up the profiler with a filter using the object_name ( as like
> "tb_transaction" w/o the quotes) and i have also bring out the object_name
> column and make it into a group
> however, it seems not to be work. i have tested with statements like "sele
ct
> * from tb_transaction" and "select * from tb_customer" and both statements
> were shown in the profiler and the column object_name is always empty
> appreciate ur kind advice
> tks & rdgs
> --
> Message posted via http://www.droptable.com
>|||Hi ,
I have just tried using the object id method
1. the object id column is still blank
2. the profiler shows whatever SQL statement that i have executed on all the
tables including the object that i specially wanted it to be filtered
kindly advise
tks & rdgs
John Bell wrote:[vbcol=seagreen]
>Hi
>Object_name is not always recorded, using the object_id and database_id wil
l
>give you better results.
>John
>
>[quoted text clipped - 11 lines]
Message posted via droptable.com
http://www.droptable.com/Uwe/Forum...server/200604/1|||Hi
Object_name and object_id are not recorded for this type of event/statement.
If you had a stored procedure then SQL:StmtStarting and SQL:StmtCompleted
record the object_id of the stored procedure (not the table being accessed)
See the topic "TSQL Data Columns" in Books Online for information of the
columns captured and what they mean.
You will need to search your source code to find references to a given table
.
John
"maxzsim via droptable.com" wrote:
> Hi ,
> I have just tried using the object id method
> 1. the object id column is still blank
> 2. the profiler shows whatever SQL statement that i have executed on all t
he
> tables including the object that i specially wanted it to be filtered
> kindly advise
> tks & rdgs
> John Bell wrote:
> --
> Message posted via droptable.com
> http://www.droptable.com/Uwe/Forum...server/200604/1
>|||> You will need to search your source code to find references to a given tab
le.
... or capture the execution plan. It might include the SQL statement (I do
n't recall right now...).
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:A8427BCF-906D-46E3-857E-8CE37AC1B666@.microsoft.com...[vbcol=seagreen]
> Hi
> Object_name and object_id are not recorded for this type of event/statemen
t.
> If you had a stored procedure then SQL:StmtStarting and SQL:StmtCompleted
> record the object_id of the stored procedure (not the table being accessed
)
> See the topic "TSQL Data Columns" in Books Online for information of the
> columns captured and what they mean.
> You will need to search your source code to find references to a given tab
le.
> John
> "maxzsim via droptable.com" wrote:
>|||Hi ,
Below is from BOL on the object_name & object_id :
Object ID 22 System-assigned ID of the object.
ObjectName 34 Name of the object being referenced.
Is there a way to monitor all the activities performed on a particular table
?
i find it actually quite diffcult to know the object_id of a SP as there
could be many many SPs which would require me to first know what are the
activities being performed on a table in order to zoom in on a particular SP
else i might be trying on all SPs and the worst case is the one that i am
looking for is the last SP .
would appreciate if you could further advise
tks & rdgs
John Bell wrote:[vbcol=seagreen]
>Hi
>Object_name and object_id are not recorded for this type of event/statement
.
>If you had a stored procedure then SQL:StmtStarting and SQL:StmtCompleted
>record the object_id of the stored procedure (not the table being accessed)
>See the topic "TSQL Data Columns" in Books Online for information of the
>columns captured and what they mean.
>You will need to search your source code to find references to a given tabl
e.
>John
>
>[quoted text clipped - 19 lines]
Message posted via droptable.com
http://www.droptable.com/Uwe/Forum...server/200604/1|||Hi
There is no easy way to do that, if you do use stored procedures then it
does not necessarily guarantee that a table is being accessed as it could
have branched code. For instance you could use
SP:StmtStarting/SP:StmtCompleted and search the textdata column (which is
easier if it is loaded into a table where you can use patindex) but this
would not be a definitive answer if you have not called every stored
procedure with every combination of parameters/data that will execute all
branches. There is also the possibly of the textdata being truncated.
John
"maxzsim via droptable.com" wrote:
> Hi ,
> Below is from BOL on the object_name & object_id :
> Object ID 22 System-assigned ID of the object.
> ObjectName 34 Name of the object being referenced.
> Is there a way to monitor all the activities performed on a particular tab
le ?
>
> i find it actually quite diffcult to know the object_id of a SP as there
> could be many many SPs which would require me to first know what are the
> activities being performed on a table in order to zoom in on a particular
SP
> else i might be trying on all SPs and the worst case is the one that i am
> looking for is the last SP .
> would appreciate if you could further advise
> tks & rdgs
> John Bell wrote:
> --
> Message posted via droptable.com
> http://www.droptable.com/Uwe/Forum...server/200604/1
>|||tks for your advice
appreciate it ..
John Bell wrote:[vbcol=seagreen]
>Hi
>There is no easy way to do that, if you do use stored procedures then it
>does not necessarily guarantee that a table is being accessed as it could
>have branched code. For instance you could use
>SP:StmtStarting/SP:StmtCompleted and search the textdata column (which is
>easier if it is loaded into a table where you can use patindex) but this
>would not be a definitive answer if you have not called every stored
>procedure with every combination of parameters/data that will execute all
>branches. There is also the possibly of the textdata being truncated.
>John
>
>[quoted text clipped - 32 lines]
Message posted via http://www.droptable.com
How can i actually use the filter for profiler
i have set up the profiler with a filter using the object_name ( as like
"tb_transaction" w/o the quotes) and i have also bring out the object_name
column and make it into a group
however, it seems not to be work. i have tested with statements like "select
* from tb_transaction" and "select * from tb_customer" and both statements
were shown in the profiler and the column object_name is always empty
appreciate ur kind advice
tks & rdgs
Message posted via http://www.droptable.comHi
Object_name is not always recorded, using the object_id and database_id will
give you better results.
John
"maxzsim via droptable.com" wrote:
> Hi ,
> How can i actually use the filter for profiler
> i have set up the profiler with a filter using the object_name ( as like
> "tb_transaction" w/o the quotes) and i have also bring out the object_name
> column and make it into a group
> however, it seems not to be work. i have tested with statements like "sele
ct
> * from tb_transaction" and "select * from tb_customer" and both statements
> were shown in the profiler and the column object_name is always empty
> appreciate ur kind advice
> tks & rdgs
> --
> Message posted via http://www.droptable.com
>|||Hi ,
I have just tried using the object id method
1. the object id column is still blank
2. the profiler shows whatever SQL statement that i have executed on all the
tables including the object that i specially wanted it to be filtered
kindly advise
tks & rdgs
John Bell wrote:[vbcol=seagreen]
>Hi
>Object_name is not always recorded, using the object_id and database_id wil
l
>give you better results.
>John
>
>[quoted text clipped - 11 lines]
Message posted via droptable.com
http://www.droptable.com/Uwe/Forum...server/200604/1|||Hi
Object_name and object_id are not recorded for this type of event/statement.
If you had a stored procedure then SQL:StmtStarting and SQL:StmtCompleted
record the object_id of the stored procedure (not the table being accessed)
See the topic "TSQL Data Columns" in Books Online for information of the
columns captured and what they mean.
You will need to search your source code to find references to a given table
.
John
"maxzsim via droptable.com" wrote:
> Hi ,
> I have just tried using the object id method
> 1. the object id column is still blank
> 2. the profiler shows whatever SQL statement that i have executed on all t
he
> tables including the object that i specially wanted it to be filtered
> kindly advise
> tks & rdgs
> John Bell wrote:
> --
> Message posted via droptable.com
> http://www.droptable.com/Uwe/Forum...server/200604/1
>|||> You will need to search your source code to find references to a given tab
le.
... or capture the execution plan. It might include the SQL statement (I do
n't recall right now...).
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:A8427BCF-906D-46E3-857E-8CE37AC1B666@.microsoft.com...[vbcol=seagreen]
> Hi
> Object_name and object_id are not recorded for this type of event/statemen
t.
> If you had a stored procedure then SQL:StmtStarting and SQL:StmtCompleted
> record the object_id of the stored procedure (not the table being accessed
)
> See the topic "TSQL Data Columns" in Books Online for information of the
> columns captured and what they mean.
> You will need to search your source code to find references to a given tab
le.
> John
> "maxzsim via droptable.com" wrote:
>|||Hi ,
Below is from BOL on the object_name & object_id :
Object ID 22 System-assigned ID of the object.
ObjectName 34 Name of the object being referenced.
Is there a way to monitor all the activities performed on a particular table
?
i find it actually quite diffcult to know the object_id of a SP as there
could be many many SPs which would require me to first know what are the
activities being performed on a table in order to zoom in on a particular SP
else i might be trying on all SPs and the worst case is the one that i am
looking for is the last SP .
would appreciate if you could further advise
tks & rdgs
John Bell wrote:[vbcol=seagreen]
>Hi
>Object_name and object_id are not recorded for this type of event/statement
.
>If you had a stored procedure then SQL:StmtStarting and SQL:StmtCompleted
>record the object_id of the stored procedure (not the table being accessed)
>See the topic "TSQL Data Columns" in Books Online for information of the
>columns captured and what they mean.
>You will need to search your source code to find references to a given tabl
e.
>John
>
>[quoted text clipped - 19 lines]
Message posted via droptable.com
http://www.droptable.com/Uwe/Forum...server/200604/1|||Hi
There is no easy way to do that, if you do use stored procedures then it
does not necessarily guarantee that a table is being accessed as it could
have branched code. For instance you could use
SP:StmtStarting/SP:StmtCompleted and search the textdata column (which is
easier if it is loaded into a table where you can use patindex) but this
would not be a definitive answer if you have not called every stored
procedure with every combination of parameters/data that will execute all
branches. There is also the possibly of the textdata being truncated.
John
"maxzsim via droptable.com" wrote:
> Hi ,
> Below is from BOL on the object_name & object_id :
> Object ID 22 System-assigned ID of the object.
> ObjectName 34 Name of the object being referenced.
> Is there a way to monitor all the activities performed on a particular tab
le ?
>
> i find it actually quite diffcult to know the object_id of a SP as there
> could be many many SPs which would require me to first know what are the
> activities being performed on a table in order to zoom in on a particular
SP
> else i might be trying on all SPs and the worst case is the one that i am
> looking for is the last SP .
> would appreciate if you could further advise
> tks & rdgs
> John Bell wrote:
> --
> Message posted via droptable.com
> http://www.droptable.com/Uwe/Forum...server/200604/1
>|||tks for your advice
appreciate it ..
John Bell wrote:[vbcol=seagreen]
>Hi
>There is no easy way to do that, if you do use stored procedures then it
>does not necessarily guarantee that a table is being accessed as it could
>have branched code. For instance you could use
>SP:StmtStarting/SP:StmtCompleted and search the textdata column (which is
>easier if it is loaded into a table where you can use patindex) but this
>would not be a definitive answer if you have not called every stored
>procedure with every combination of parameters/data that will execute all
>branches. There is also the possibly of the textdata being truncated.
>John
>
>[quoted text clipped - 32 lines]
Message posted via http://www.droptable.com
filter for profiler
Hi ,
How can i actually use the filter for profiler
i have set up the profiler with a filter using the object_name ( as like
"tb_transaction" w/o the quotes) and i have also bring out the object_name
column and make it into a group
however, it seems not to be work. i have tested with statements like "select
* from tb_transaction" and "select * from tb_customer" and both statements
were shown in the profiler and the column object_name is always empty
appreciate ur kind advice
tks & rdgs
--
Message posted via http://www.sqlmonster.comHi
Object_name is not always recorded, using the object_id and database_id will
give you better results.
John
"maxzsim via SQLMonster.com" wrote:
> Hi ,
> How can i actually use the filter for profiler
> i have set up the profiler with a filter using the object_name ( as like
> "tb_transaction" w/o the quotes) and i have also bring out the object_name
> column and make it into a group
> however, it seems not to be work. i have tested with statements like "select
> * from tb_transaction" and "select * from tb_customer" and both statements
> were shown in the profiler and the column object_name is always empty
> appreciate ur kind advice
> tks & rdgs
> --
> Message posted via http://www.sqlmonster.com
>|||Hi ,
I have just tried using the object id method
1. the object id column is still blank
2. the profiler shows whatever SQL statement that i have executed on all the
tables including the object that i specially wanted it to be filtered
kindly advise
tks & rdgs
John Bell wrote:
>Hi
>Object_name is not always recorded, using the object_id and database_id will
>give you better results.
>John
>> Hi ,
>[quoted text clipped - 11 lines]
>> tks & rdgs
--
Message posted via SQLMonster.com
http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server/200604/1|||Hi
Object_name and object_id are not recorded for this type of event/statement.
If you had a stored procedure then SQL:StmtStarting and SQL:StmtCompleted
record the object_id of the stored procedure (not the table being accessed)
See the topic "TSQL Data Columns" in Books Online for information of the
columns captured and what they mean.
You will need to search your source code to find references to a given table.
John
"maxzsim via SQLMonster.com" wrote:
> Hi ,
> I have just tried using the object id method
> 1. the object id column is still blank
> 2. the profiler shows whatever SQL statement that i have executed on all the
> tables including the object that i specially wanted it to be filtered
> kindly advise
> tks & rdgs
> John Bell wrote:
> >Hi
> >
> >Object_name is not always recorded, using the object_id and database_id will
> >give you better results.
> >
> >John
> >
> >> Hi ,
> >>
> >[quoted text clipped - 11 lines]
> >>
> >> tks & rdgs
> --
> Message posted via SQLMonster.com
> http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server/200604/1
>|||> You will need to search your source code to find references to a given table.
... or capture the execution plan. It might include the SQL statement (I don't recall right now...).
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:A8427BCF-906D-46E3-857E-8CE37AC1B666@.microsoft.com...
> Hi
> Object_name and object_id are not recorded for this type of event/statement.
> If you had a stored procedure then SQL:StmtStarting and SQL:StmtCompleted
> record the object_id of the stored procedure (not the table being accessed)
> See the topic "TSQL Data Columns" in Books Online for information of the
> columns captured and what they mean.
> You will need to search your source code to find references to a given table.
> John
> "maxzsim via SQLMonster.com" wrote:
>> Hi ,
>> I have just tried using the object id method
>> 1. the object id column is still blank
>> 2. the profiler shows whatever SQL statement that i have executed on all the
>> tables including the object that i specially wanted it to be filtered
>> kindly advise
>> tks & rdgs
>> John Bell wrote:
>> >Hi
>> >
>> >Object_name is not always recorded, using the object_id and database_id will
>> >give you better results.
>> >
>> >John
>> >
>> >> Hi ,
>> >>
>> >[quoted text clipped - 11 lines]
>> >>
>> >> tks & rdgs
>> --
>> Message posted via SQLMonster.com
>> http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server/200604/1|||Hi ,
Below is from BOL on the object_name & object_id :
Object ID 22 System-assigned ID of the object.
ObjectName 34 Name of the object being referenced.
Is there a way to monitor all the activities performed on a particular table ?
i find it actually quite diffcult to know the object_id of a SP as there
could be many many SPs which would require me to first know what are the
activities being performed on a table in order to zoom in on a particular SP
else i might be trying on all SPs and the worst case is the one that i am
looking for is the last SP .
would appreciate if you could further advise
tks & rdgs
John Bell wrote:
>Hi
>Object_name and object_id are not recorded for this type of event/statement.
>If you had a stored procedure then SQL:StmtStarting and SQL:StmtCompleted
>record the object_id of the stored procedure (not the table being accessed)
>See the topic "TSQL Data Columns" in Books Online for information of the
>columns captured and what they mean.
>You will need to search your source code to find references to a given table.
>John
>> Hi ,
>[quoted text clipped - 19 lines]
>> >>
>> >> tks & rdgs
--
Message posted via SQLMonster.com
http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server/200604/1|||Hi
There is no easy way to do that, if you do use stored procedures then it
does not necessarily guarantee that a table is being accessed as it could
have branched code. For instance you could use
SP:StmtStarting/SP:StmtCompleted and search the textdata column (which is
easier if it is loaded into a table where you can use patindex) but this
would not be a definitive answer if you have not called every stored
procedure with every combination of parameters/data that will execute all
branches. There is also the possibly of the textdata being truncated.
John
"maxzsim via SQLMonster.com" wrote:
> Hi ,
> Below is from BOL on the object_name & object_id :
> Object ID 22 System-assigned ID of the object.
> ObjectName 34 Name of the object being referenced.
> Is there a way to monitor all the activities performed on a particular table ?
>
> i find it actually quite diffcult to know the object_id of a SP as there
> could be many many SPs which would require me to first know what are the
> activities being performed on a table in order to zoom in on a particular SP
> else i might be trying on all SPs and the worst case is the one that i am
> looking for is the last SP .
> would appreciate if you could further advise
> tks & rdgs
> John Bell wrote:
> >Hi
> >
> >Object_name and object_id are not recorded for this type of event/statement.
> >If you had a stored procedure then SQL:StmtStarting and SQL:StmtCompleted
> >record the object_id of the stored procedure (not the table being accessed)
> >See the topic "TSQL Data Columns" in Books Online for information of the
> >columns captured and what they mean.
> >
> >You will need to search your source code to find references to a given table.
> >
> >John
> >
> >> Hi ,
> >>
> >[quoted text clipped - 19 lines]
> >> >>
> >> >> tks & rdgs
> --
> Message posted via SQLMonster.com
> http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server/200604/1
>|||tks for your advice
appreciate it ..
John Bell wrote:
>Hi
>There is no easy way to do that, if you do use stored procedures then it
>does not necessarily guarantee that a table is being accessed as it could
>have branched code. For instance you could use
>SP:StmtStarting/SP:StmtCompleted and search the textdata column (which is
>easier if it is loaded into a table where you can use patindex) but this
>would not be a definitive answer if you have not called every stored
>procedure with every combination of parameters/data that will execute all
>branches. There is also the possibly of the textdata being truncated.
>John
>> Hi ,
>[quoted text clipped - 32 lines]
>> >> >>
>> >> >> tks & rdgs
--
Message posted via http://www.sqlmonster.com
How can i actually use the filter for profiler
i have set up the profiler with a filter using the object_name ( as like
"tb_transaction" w/o the quotes) and i have also bring out the object_name
column and make it into a group
however, it seems not to be work. i have tested with statements like "select
* from tb_transaction" and "select * from tb_customer" and both statements
were shown in the profiler and the column object_name is always empty
appreciate ur kind advice
tks & rdgs
--
Message posted via http://www.sqlmonster.comHi
Object_name is not always recorded, using the object_id and database_id will
give you better results.
John
"maxzsim via SQLMonster.com" wrote:
> Hi ,
> How can i actually use the filter for profiler
> i have set up the profiler with a filter using the object_name ( as like
> "tb_transaction" w/o the quotes) and i have also bring out the object_name
> column and make it into a group
> however, it seems not to be work. i have tested with statements like "select
> * from tb_transaction" and "select * from tb_customer" and both statements
> were shown in the profiler and the column object_name is always empty
> appreciate ur kind advice
> tks & rdgs
> --
> Message posted via http://www.sqlmonster.com
>|||Hi ,
I have just tried using the object id method
1. the object id column is still blank
2. the profiler shows whatever SQL statement that i have executed on all the
tables including the object that i specially wanted it to be filtered
kindly advise
tks & rdgs
John Bell wrote:
>Hi
>Object_name is not always recorded, using the object_id and database_id will
>give you better results.
>John
>> Hi ,
>[quoted text clipped - 11 lines]
>> tks & rdgs
--
Message posted via SQLMonster.com
http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server/200604/1|||Hi
Object_name and object_id are not recorded for this type of event/statement.
If you had a stored procedure then SQL:StmtStarting and SQL:StmtCompleted
record the object_id of the stored procedure (not the table being accessed)
See the topic "TSQL Data Columns" in Books Online for information of the
columns captured and what they mean.
You will need to search your source code to find references to a given table.
John
"maxzsim via SQLMonster.com" wrote:
> Hi ,
> I have just tried using the object id method
> 1. the object id column is still blank
> 2. the profiler shows whatever SQL statement that i have executed on all the
> tables including the object that i specially wanted it to be filtered
> kindly advise
> tks & rdgs
> John Bell wrote:
> >Hi
> >
> >Object_name is not always recorded, using the object_id and database_id will
> >give you better results.
> >
> >John
> >
> >> Hi ,
> >>
> >[quoted text clipped - 11 lines]
> >>
> >> tks & rdgs
> --
> Message posted via SQLMonster.com
> http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server/200604/1
>|||> You will need to search your source code to find references to a given table.
... or capture the execution plan. It might include the SQL statement (I don't recall right now...).
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:A8427BCF-906D-46E3-857E-8CE37AC1B666@.microsoft.com...
> Hi
> Object_name and object_id are not recorded for this type of event/statement.
> If you had a stored procedure then SQL:StmtStarting and SQL:StmtCompleted
> record the object_id of the stored procedure (not the table being accessed)
> See the topic "TSQL Data Columns" in Books Online for information of the
> columns captured and what they mean.
> You will need to search your source code to find references to a given table.
> John
> "maxzsim via SQLMonster.com" wrote:
>> Hi ,
>> I have just tried using the object id method
>> 1. the object id column is still blank
>> 2. the profiler shows whatever SQL statement that i have executed on all the
>> tables including the object that i specially wanted it to be filtered
>> kindly advise
>> tks & rdgs
>> John Bell wrote:
>> >Hi
>> >
>> >Object_name is not always recorded, using the object_id and database_id will
>> >give you better results.
>> >
>> >John
>> >
>> >> Hi ,
>> >>
>> >[quoted text clipped - 11 lines]
>> >>
>> >> tks & rdgs
>> --
>> Message posted via SQLMonster.com
>> http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server/200604/1|||Hi ,
Below is from BOL on the object_name & object_id :
Object ID 22 System-assigned ID of the object.
ObjectName 34 Name of the object being referenced.
Is there a way to monitor all the activities performed on a particular table ?
i find it actually quite diffcult to know the object_id of a SP as there
could be many many SPs which would require me to first know what are the
activities being performed on a table in order to zoom in on a particular SP
else i might be trying on all SPs and the worst case is the one that i am
looking for is the last SP .
would appreciate if you could further advise
tks & rdgs
John Bell wrote:
>Hi
>Object_name and object_id are not recorded for this type of event/statement.
>If you had a stored procedure then SQL:StmtStarting and SQL:StmtCompleted
>record the object_id of the stored procedure (not the table being accessed)
>See the topic "TSQL Data Columns" in Books Online for information of the
>columns captured and what they mean.
>You will need to search your source code to find references to a given table.
>John
>> Hi ,
>[quoted text clipped - 19 lines]
>> >>
>> >> tks & rdgs
--
Message posted via SQLMonster.com
http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server/200604/1|||Hi
There is no easy way to do that, if you do use stored procedures then it
does not necessarily guarantee that a table is being accessed as it could
have branched code. For instance you could use
SP:StmtStarting/SP:StmtCompleted and search the textdata column (which is
easier if it is loaded into a table where you can use patindex) but this
would not be a definitive answer if you have not called every stored
procedure with every combination of parameters/data that will execute all
branches. There is also the possibly of the textdata being truncated.
John
"maxzsim via SQLMonster.com" wrote:
> Hi ,
> Below is from BOL on the object_name & object_id :
> Object ID 22 System-assigned ID of the object.
> ObjectName 34 Name of the object being referenced.
> Is there a way to monitor all the activities performed on a particular table ?
>
> i find it actually quite diffcult to know the object_id of a SP as there
> could be many many SPs which would require me to first know what are the
> activities being performed on a table in order to zoom in on a particular SP
> else i might be trying on all SPs and the worst case is the one that i am
> looking for is the last SP .
> would appreciate if you could further advise
> tks & rdgs
> John Bell wrote:
> >Hi
> >
> >Object_name and object_id are not recorded for this type of event/statement.
> >If you had a stored procedure then SQL:StmtStarting and SQL:StmtCompleted
> >record the object_id of the stored procedure (not the table being accessed)
> >See the topic "TSQL Data Columns" in Books Online for information of the
> >columns captured and what they mean.
> >
> >You will need to search your source code to find references to a given table.
> >
> >John
> >
> >> Hi ,
> >>
> >[quoted text clipped - 19 lines]
> >> >>
> >> >> tks & rdgs
> --
> Message posted via SQLMonster.com
> http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server/200604/1
>|||tks for your advice
appreciate it ..
John Bell wrote:
>Hi
>There is no easy way to do that, if you do use stored procedures then it
>does not necessarily guarantee that a table is being accessed as it could
>have branched code. For instance you could use
>SP:StmtStarting/SP:StmtCompleted and search the textdata column (which is
>easier if it is loaded into a table where you can use patindex) but this
>would not be a definitive answer if you have not called every stored
>procedure with every combination of parameters/data that will execute all
>branches. There is also the possibly of the textdata being truncated.
>John
>> Hi ,
>[quoted text clipped - 32 lines]
>> >> >>
>> >> >> tks & rdgs
--
Message posted via http://www.sqlmonster.com
filter expressions combined with OR instead of AND
I need to combine filter expressions for my report item with the OR-logic -
but the Reporting Services dialog window is set on the AND-logic. How can I
get past this?
Example
======
What I need is the following:
Fields!Name1 = Parameters!Name
OR
Fields!Name2 = Parameters!Name
What I get from Reporting Services is the following:
Fields!Name1 = Parameters!Name
AND
Fields!Name2 = Parameters!Name
Thank you for your help.I think you can set that in the Expression builder, there is a column called
condition... But if for some reason it doesn't work properly go to the
generic query builder and simply type your expression
Sorry - you are talking about the filter... You could make a function in
the code section, pass both of the field values and parameter values into
the function and return 1 to include the row and 0 to exclude it...Then your
filter expression would be
GetFilter(Fields!Name1.Value,Fields!Name2.Value, Parameters!Name) = 1
--
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"j schuetz" <j schuetz@.discussions.microsoft.com> wrote in message
news:E5CA33E2-B55D-496D-A48D-C94892135151@.microsoft.com...
> I need to combine filter expressions for my report item with the
OR-logic -
> but the Reporting Services dialog window is set on the AND-logic. How can
I
> get past this?
> Example
> ======> What I need is the following:
> Fields!Name1 = Parameters!Name
> OR
> Fields!Name2 = Parameters!Name
> What I get from Reporting Services is the following:
> Fields!Name1 = Parameters!Name
> AND
> Fields!Name2 = Parameters!Name
> Thank you for your help.
>
>|||Dear Wayne
Thank you for your advice. However, I am a controller, not a programmer.
When I am working with RS, I only use the graphic interface - never the code
section... (-;
Is there not a more user-friendly (controller-friendly...) way around this
problem?
Thanks again.
"Wayne Snyder" wrote:
> I think you can set that in the Expression builder, there is a column called
> condition... But if for some reason it doesn't work properly go to the
> generic query builder and simply type your expression
> Sorry - you are talking about the filter... You could make a function in
> the code section, pass both of the field values and parameter values into
> the function and return 1 to include the row and 0 to exclude it...Then your
> filter expression would be
> GetFilter(Fields!Name1.Value,Fields!Name2.Value, Parameters!Name) = 1
> --
> Wayne Snyder, MCDBA, SQL Server MVP
> Mariner, Charlotte, NC
> www.mariner-usa.com
> (Please respond only to the newsgroups.)
> I support the Professional Association of SQL Server (PASS) and it's
> community of SQL Server professionals.
> www.sqlpass.org
> "j schuetz" <j schuetz@.discussions.microsoft.com> wrote in message
> news:E5CA33E2-B55D-496D-A48D-C94892135151@.microsoft.com...
> > I need to combine filter expressions for my report item with the
> OR-logic -
> > but the Reporting Services dialog window is set on the AND-logic. How can
> I
> > get past this?
> >
> > Example
> > ======> >
> > What I need is the following:
> >
> > Fields!Name1 = Parameters!Name
> > OR
> > Fields!Name2 = Parameters!Name
> >
> > What I get from Reporting Services is the following:
> >
> > Fields!Name1 = Parameters!Name
> > AND
> > Fields!Name2 = Parameters!Name
> >
> > Thank you for your help.
> >
> >
> >
>
>|||Hi,
I also had this problem and discovered that if you put the common filed
first Reporting Services will give you an OR.
So if youy enter your parameters as follows:
Parameters!Name = Fields!Name1
then
Parameters!Name = Fields!Name2
Reporting Services will generate:
Parameters!Name = Fields!Name1
OR
Parameters!Name = Fields!Name2
Steve
"j schuetz" wrote:
> I need to combine filter expressions for my report item with the OR-logic -
> but the Reporting Services dialog window is set on the AND-logic. How can I
> get past this?
> Example
> ======> What I need is the following:
> Fields!Name1 = Parameters!Name
> OR
> Fields!Name2 = Parameters!Name
> What I get from Reporting Services is the following:
> Fields!Name1 = Parameters!Name
> AND
> Fields!Name2 = Parameters!Name
> Thank you for your help.
>
>|||Too bad, but at least you know the differences between AND and OR :))
In any case, you'd be in a much better shape if you do filtering in
your SQL query, not in the report itself. RS filtering is evil,
because it makes SQL server pull ALL the data from the query, just to
throw away some of it later. It would be much more efficient (and
easier) to apply your filtering in your query (dataset):
SELECT ...
FROM ...
WHERE Name1 = @.paramName OR Name2 = @.paramName
On Mon, 24 Jan 2005 07:13:06 -0800, j schuetz
<jschuetz@.discussions.microsoft.com> wrote:
>Dear Wayne
>Thank you for your advice. However, I am a controller, not a programmer.
>When I am working with RS, I only use the graphic interface - never the code
>section... (-;
>Is there not a more user-friendly (controller-friendly...) way around this
>problem?
>Thanks again.
>
>"Wayne Snyder" wrote:
>> I think you can set that in the Expression builder, there is a column called
>> condition... But if for some reason it doesn't work properly go to the
>> generic query builder and simply type your expression
>> Sorry - you are talking about the filter... You could make a function in
>> the code section, pass both of the field values and parameter values into
>> the function and return 1 to include the row and 0 to exclude it...Then your
>> filter expression would be
>> GetFilter(Fields!Name1.Value,Fields!Name2.Value, Parameters!Name) = 1
>> --
>> Wayne Snyder, MCDBA, SQL Server MVP
>> Mariner, Charlotte, NC
>> www.mariner-usa.com
>> (Please respond only to the newsgroups.)
>> I support the Professional Association of SQL Server (PASS) and it's
>> community of SQL Server professionals.
>> www.sqlpass.org
>> "j schuetz" <j schuetz@.discussions.microsoft.com> wrote in message
>> news:E5CA33E2-B55D-496D-A48D-C94892135151@.microsoft.com...
>> > I need to combine filter expressions for my report item with the
>> OR-logic -
>> > but the Reporting Services dialog window is set on the AND-logic. How can
>> I
>> > get past this?
>> >
>> > Example
>> > ======>> >
>> > What I need is the following:
>> >
>> > Fields!Name1 = Parameters!Name
>> > OR
>> > Fields!Name2 = Parameters!Name
>> >
>> > What I get from Reporting Services is the following:
>> >
>> > Fields!Name1 = Parameters!Name
>> > AND
>> > Fields!Name2 = Parameters!Name
>> >
>> > Thank you for your help.
>> >
>> >
>> >
>>|||Thanks to Steve and Usenet User for their helpful piece of advice. Now I am
getting along!
but the Reporting Services dialog window is set on the AND-logic. How can I
get past this?
Example
======
What I need is the following:
Fields!Name1 = Parameters!Name
OR
Fields!Name2 = Parameters!Name
What I get from Reporting Services is the following:
Fields!Name1 = Parameters!Name
AND
Fields!Name2 = Parameters!Name
Thank you for your help.I think you can set that in the Expression builder, there is a column called
condition... But if for some reason it doesn't work properly go to the
generic query builder and simply type your expression
Sorry - you are talking about the filter... You could make a function in
the code section, pass both of the field values and parameter values into
the function and return 1 to include the row and 0 to exclude it...Then your
filter expression would be
GetFilter(Fields!Name1.Value,Fields!Name2.Value, Parameters!Name) = 1
--
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"j schuetz" <j schuetz@.discussions.microsoft.com> wrote in message
news:E5CA33E2-B55D-496D-A48D-C94892135151@.microsoft.com...
> I need to combine filter expressions for my report item with the
OR-logic -
> but the Reporting Services dialog window is set on the AND-logic. How can
I
> get past this?
> Example
> ======> What I need is the following:
> Fields!Name1 = Parameters!Name
> OR
> Fields!Name2 = Parameters!Name
> What I get from Reporting Services is the following:
> Fields!Name1 = Parameters!Name
> AND
> Fields!Name2 = Parameters!Name
> Thank you for your help.
>
>|||Dear Wayne
Thank you for your advice. However, I am a controller, not a programmer.
When I am working with RS, I only use the graphic interface - never the code
section... (-;
Is there not a more user-friendly (controller-friendly...) way around this
problem?
Thanks again.
"Wayne Snyder" wrote:
> I think you can set that in the Expression builder, there is a column called
> condition... But if for some reason it doesn't work properly go to the
> generic query builder and simply type your expression
> Sorry - you are talking about the filter... You could make a function in
> the code section, pass both of the field values and parameter values into
> the function and return 1 to include the row and 0 to exclude it...Then your
> filter expression would be
> GetFilter(Fields!Name1.Value,Fields!Name2.Value, Parameters!Name) = 1
> --
> Wayne Snyder, MCDBA, SQL Server MVP
> Mariner, Charlotte, NC
> www.mariner-usa.com
> (Please respond only to the newsgroups.)
> I support the Professional Association of SQL Server (PASS) and it's
> community of SQL Server professionals.
> www.sqlpass.org
> "j schuetz" <j schuetz@.discussions.microsoft.com> wrote in message
> news:E5CA33E2-B55D-496D-A48D-C94892135151@.microsoft.com...
> > I need to combine filter expressions for my report item with the
> OR-logic -
> > but the Reporting Services dialog window is set on the AND-logic. How can
> I
> > get past this?
> >
> > Example
> > ======> >
> > What I need is the following:
> >
> > Fields!Name1 = Parameters!Name
> > OR
> > Fields!Name2 = Parameters!Name
> >
> > What I get from Reporting Services is the following:
> >
> > Fields!Name1 = Parameters!Name
> > AND
> > Fields!Name2 = Parameters!Name
> >
> > Thank you for your help.
> >
> >
> >
>
>|||Hi,
I also had this problem and discovered that if you put the common filed
first Reporting Services will give you an OR.
So if youy enter your parameters as follows:
Parameters!Name = Fields!Name1
then
Parameters!Name = Fields!Name2
Reporting Services will generate:
Parameters!Name = Fields!Name1
OR
Parameters!Name = Fields!Name2
Steve
"j schuetz" wrote:
> I need to combine filter expressions for my report item with the OR-logic -
> but the Reporting Services dialog window is set on the AND-logic. How can I
> get past this?
> Example
> ======> What I need is the following:
> Fields!Name1 = Parameters!Name
> OR
> Fields!Name2 = Parameters!Name
> What I get from Reporting Services is the following:
> Fields!Name1 = Parameters!Name
> AND
> Fields!Name2 = Parameters!Name
> Thank you for your help.
>
>|||Too bad, but at least you know the differences between AND and OR :))
In any case, you'd be in a much better shape if you do filtering in
your SQL query, not in the report itself. RS filtering is evil,
because it makes SQL server pull ALL the data from the query, just to
throw away some of it later. It would be much more efficient (and
easier) to apply your filtering in your query (dataset):
SELECT ...
FROM ...
WHERE Name1 = @.paramName OR Name2 = @.paramName
On Mon, 24 Jan 2005 07:13:06 -0800, j schuetz
<jschuetz@.discussions.microsoft.com> wrote:
>Dear Wayne
>Thank you for your advice. However, I am a controller, not a programmer.
>When I am working with RS, I only use the graphic interface - never the code
>section... (-;
>Is there not a more user-friendly (controller-friendly...) way around this
>problem?
>Thanks again.
>
>"Wayne Snyder" wrote:
>> I think you can set that in the Expression builder, there is a column called
>> condition... But if for some reason it doesn't work properly go to the
>> generic query builder and simply type your expression
>> Sorry - you are talking about the filter... You could make a function in
>> the code section, pass both of the field values and parameter values into
>> the function and return 1 to include the row and 0 to exclude it...Then your
>> filter expression would be
>> GetFilter(Fields!Name1.Value,Fields!Name2.Value, Parameters!Name) = 1
>> --
>> Wayne Snyder, MCDBA, SQL Server MVP
>> Mariner, Charlotte, NC
>> www.mariner-usa.com
>> (Please respond only to the newsgroups.)
>> I support the Professional Association of SQL Server (PASS) and it's
>> community of SQL Server professionals.
>> www.sqlpass.org
>> "j schuetz" <j schuetz@.discussions.microsoft.com> wrote in message
>> news:E5CA33E2-B55D-496D-A48D-C94892135151@.microsoft.com...
>> > I need to combine filter expressions for my report item with the
>> OR-logic -
>> > but the Reporting Services dialog window is set on the AND-logic. How can
>> I
>> > get past this?
>> >
>> > Example
>> > ======>> >
>> > What I need is the following:
>> >
>> > Fields!Name1 = Parameters!Name
>> > OR
>> > Fields!Name2 = Parameters!Name
>> >
>> > What I get from Reporting Services is the following:
>> >
>> > Fields!Name1 = Parameters!Name
>> > AND
>> > Fields!Name2 = Parameters!Name
>> >
>> > Thank you for your help.
>> >
>> >
>> >
>>|||Thanks to Steve and Usenet User for their helpful piece of advice. Now I am
getting along!
filter expression using measures
Hi guys,
I want to filter an MDX query based on a specific measure values, however, the MDX query designer allows you to filter only based on a dimension.
Is there any soulution to resolve this problem.
Sincerely,
--Amde
In the data tab for reporting services, select your dataset you want to filter by in the drop down list. Now, click the "..." to the right. In the filters tab, you can filter the dataset by an expression you provide.
For example, if you wanted to filter the results so that only customers with over 100 purchases were displayed, you could do this:
Expression: =Fields!NumberOfPurchases.value
Operator: >
Value: 100
You should be good to go. Good luck!!
|||thx!Filter expression for searching "with all the words"
Using VWD I have created a search feature using the LIKE clause. The filter expression on my SQLDataSource allows the user to search the Description field of a database and yield a result that contains the exact word or phrase entered into a textbox. Assuming that the user enters more than one word, my understanding is that the search result is limited to database rows that contain the EXACT phrase (such as found in an advanced Google search using the “with the exact phrase” option). The current filter expression is:
Description LIKE '%{0}%'
For example, if “John Smith” is typed into the search textbox, the results will include a row with:
1. “John Smith is my neighbor”
but NOT a row with
2. “John is my neighbor. His last name is Smith”.
How does one modify the filter expression so that the search result is like the Google “with all the words” search option, where the search results are limited to records in which all the words typed into the textbox are present but not necessarily in the EXACT continuous order? In the example above, BOTH Descriptions would be returned in the search results when “John Smith” in typed into the search textbox.
Thanks for any help you can provide in helping me refine my search options.
Sounds like you're looking for a "full-text search".
read this:http://msdn2.microsoft.com/en-us/library/ms142571.aspx
|||To search several words,like "John Smith" ,you have to split that into "john" and "smith " then use
Description LIKE '%John%' andDescription LIKE '%Smith%'
but that operation is quite expensive,I recommend you to use fulltext search. You can see the following like for details:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsql2k/html/sql_fulltextsearch.asp
|||Thanks for the suggestions. I will explore these options.
I do have a couple of general questions about doing searches:
1. Am I correct in assuming that when you use LIKE as I have done (Description LIKE '%{0}%') that the search results that are returned are for the EXACT word or phrase that was searched (i.e., comparable in accuracy - if not speed - to the Google exact phrase search)?
2. Since full-text searches rely on an index they do not necessarily return EXACT results because "noise" words are eliminated? Thus the best that can be hoped for is an exact word order, but not an exact phrase?
3. Can the combined filter expression cited above (Description LIKE '%John%' and Description LIKE '%Smith%) contain parameters instead of the hardcoded search terms (Description LIKE '%{0}%' andDescription LIKE '%{0}%) that allow any combination of terms to be entered into the search textbox?
I look forward to researching the full-text approach and getting it implemented into my search page. Thanks again.
sql
Subscribe to:
Posts (Atom)