On Fri, Jan 28, 2011 at 2:57 AM, Scott Marlowe wrote:
> On Thu, Jan 27, 2011 at 10:50 AM, Amitabh Kant
> wrote:
> > Hi
> >
> > I am trying to write a function which is being called from a trigger used
> > for partitioning a large table. The partitioning is to happen based on an
> > integer field
On Fri, Jan 28, 2011 at 2:40 AM, Viktor Bojović wrote:
> when creating dynamic query try to store it completey as string because you
> will not be able to change tableName (i havent been doing that for a long
> time , so possibly i can be wrong).
> to "exec" or "execute" command you have to pass t
On Thu, Jan 27, 2011 at 10:50 AM, Amitabh Kant wrote:
> Hi
>
> I am trying to write a function which is being called from a trigger used
> for partitioning a large table. The partitioning is to happen based on an
> integer field (testing_id). A simplified structure of what I am trying to do
> is w
when creating dynamic query try to store it completey as string because you
will not be able to change tableName (i havent been doing that for a long
time , so possibly i can be wrong).
to "exec" or "execute" command you have to pass the query as parameter.
it would look like this
declare sql as v
Hi
I am trying to write a function which is being called from a trigger used
for partitioning a large table. The partitioning is to happen based on an
integer field (testing_id). A simplified structure of what I am trying to do
is written below.
Create Table tbltesting(
testing_id int not null,
On Thu, Jan 27, 2011 at 11:20 PM, Amitabh Kant wrote:
> Hi
>
> I am trying to write a function which is being called from a trigger used
> for partitioning a large table. The partitioning is to happen based on an
> integer field (testing_id). A simplified structure of what I am trying to do
> is w
