I have a search page that takes in various fields. Users may leave some of
them empty. However in the sql generated the code is still doing a "Where
X='' or Y='12'". Notice how X is still there, just that it's blank. Does
this lead to more overhead on the sql server?
Re: upsizing access 2002 database to SQL Server 2000 - fatal error ... Never seen problems with bit fields myself, but if you believe that empty... bit fields could be your problem, then create an update query on your access ... > I have read on a few sites that sql server doesnt like empty bit (i.e. ... (microsoft.public.access.conversion)
Re: Top generic pascal tips required ... Having any TDataSet descendant or database connection with property Active ... T*Query with empty SQL property.... TActionList with empty OnUpdate event hadler.... TDBGrid or TDataSource with empty DataSource and DataSet properties.... (borland.public.delphi.language.objectpascal)
Re: Access/SQLServer Requery Recordsource ... If the recordset is empty, the detail section of the form will not ... alter the recordsource SQL, you need to do it in the form Open ... event or before the form Open event.... a saved querydef as the source for the form. ... (microsoft.public.access.formscoding)
Re: Calculate ... The reason this can only be used in rare cases is that the query is not ... the second query eliminates completely empty rows.... the engine returns an empty cell.... See this section of the "SQL Server 2008 White Paper: ... (microsoft.public.sqlserver.olap)
Re: So whats null then if its not nothing? ... Because way too many people started writing half-baked study books about ...SQL when it became booming business. ... >"A good standard survives because people know how to use it. ... But I've also seen you write that it's equal to the empty... (comp.databases.theory)
