SQL

Subscribe to SQL content with RSS Syndicate content or email

SQL Inbound Adapter - Not returning all the records it should from a View in Micrsoft SQL Server

I am currently working on a issue with WRC on one of my Inbound SQL Adapters not returning all the records it should be.

views

rating

Need variable number of query parameters in dynamic query

I have a query string that I am creating programmatically, based on some user inputs.  The user might search on 5 fields, or 8 fields, or no fields.

views

rating

Using WHERE clause on a sub-query populated column

Hi,

Is it possible to use the value of a column that is populated by its own subquery,  in the WHERE clause of the outer-query ?

The following fails (it does not parse syntactically):

views

rating

Old/New Dynamic SQL Cheat Sheet

The newer dynamic SQL classes (%SQL.Statement and %StatementResult) perform better than %ResultSet, but I did not adopt them for some time because I had learned how to use %ResultSet.

views

rating

ODBC to Cache with Dynamic Table Names

Hello! So, my knowledge on the Cache database is extremely limited, and I was hoping I could find some assistance here. I'm connecting to the DB via ODBC.

views

rating

How can I determine if a query is an SQL or an MDX query

I have a query text that I need to execute and return results as xml.

views

rating

Indexing of non-atomic attributes

Quotes (1NF/2NF/3NF)ru:

Every row-and-column intersection contains exactly one value from the applicable domain (and nothing else).
The same value can be atomic or non-atomic depending on the purpose of this value. For example, “4286” can be
  • atomic, if its denotes “a credit card’s PIN code” (if it’s broken down or reshuffled, it is of no use any longer)
  • non-atomic, if it’s just a “sequence of numbers” (the value still makes sense if broken down into several parts or reshuffled)

This article explores the standard methods of increasing the performance of SQL queries involving the following types of fields: string, date, simple list (in the $LB format), "list of <...>" and "array of <...>".

views

rating

Ways and methods of Accessing Relationships with SQL

I am experimenting with Relationships, both Parent to Child and One to Many.

views

rating

How to escape the single quote in the single quoted string

I have a stored procedure like below:

views

rating

stored procedure %SYSTEM.SQL_TableExists

"SELECT  %SYSTEM.SQL_TableExists('table name') "could work as expected under SQL shell,

views

rating

SQL index for array property elements

Sometimes, it comes in very handy (especially for the EAV model) to use array properties in a class and be able to qickly search by their elements: both the key and the value.

Let’s take a look at a simple example:

views

rating

Is Caché SQL essential to Caché Objects?

I would like to start a discussion regarding Caché Objects and Caché SQL.

views

rating