After OK parse, I try to execute this statement in a trigger:
if inserted.col1 = 10 --col1 type int
--do instruction
But I have this message:
The multi-part identifier "inserted.col1" could not be bound.
What is this problem'
How can I resolve it?
Thanks!
Good night!Inserted is a "table" that can have many rows in it (1 for each row inserted
or updated in the statement that fired the trigger). As such, you could do
something like this:
SELECT @.variable = col1 FROM Inserted
IF @.Variable = 10 ...
However, this will only get the col1 value from 1 of the rows in the
inserted table.
Show us the rest of the code in your trigger and we can likely help you
write it using a set based solution that will handle multiple rows in the
inserted table.
"bubixx" <bubixx@.discussions.microsoft.com> wrote in message
news:7BBC3219-4A58-4561-8DBA-95CF54E46489@.microsoft.com...
> After OK parse, I try to execute this statement in a trigger:
> if inserted.col1 = 10 --col1 type int
> --do instruction
> But I have this message:
> The multi-part identifier "inserted.col1" could not be bound.
> What is this problem'
> How can I resolve it?
> Thanks!
> Good night!|||You can't do a direct comparison on a column in a table in an IF statement.
It's pretty tough to tell you what the appropriate syntax should be without
knowing more about what you are trying to do. In any case you should always
code triggers to account for multiple rows being affected. What you are
trying to do infers only one row is ever affected which will ultimately get
you in trouble.
Andrew J. Kelly SQL MVP
"bubixx" <bubixx@.discussions.microsoft.com> wrote in message
news:7BBC3219-4A58-4561-8DBA-95CF54E46489@.microsoft.com...
> After OK parse, I try to execute this statement in a trigger:
> if inserted.col1 = 10 --col1 type int
> --do instruction
> But I have this message:
> The multi-part identifier "inserted.col1" could not be bound.
> What is this problem'
> How can I resolve it?
> Thanks!
> Good night!
Showing posts with label multi-part. Show all posts
Showing posts with label multi-part. Show all posts
Friday, March 9, 2012
Sunday, February 26, 2012
Error Message. Please help
This is a multi-part message in MIME format.
--=_NextPart_000_0006_01C6531E.93D6CCD0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
I have 7 SQL Servers
They all sync once every hour.
One of my servers shows 2 Views (while the others show 4). SO I tried to = create the missing view's and I get this error message
"ODBC error: [Microsoft][ODBC SQL Server Driver][SQL Server]There is = already an object named <name> already exists"
Thank You
--=_NextPart_000_0006_01C6531E.93D6CCD0
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
&
I have 7 SQL Servers
They all sync once every = hour.
One of my servers shows 2 Views (while = the others show 4). SO I tried to create the missing view's and I get this error message
"ODBC error: [Microsoft][ODBC = SQL Server Driver][SQL Server]There is already an object named already = exists"
Thank You
--=_NextPart_000_0006_01C6531E.93D6CCD0--Try refreshing enterprise manger.
Regards
Amish Shah|||I used the right mouse button and clicked REFRESH.
and nothing happened.
Anything else I can try?
Thanks
"amish" <shahamishm@.gmail.com> wrote in message
news:1143649651.420463.246200@.v46g2000cwv.googlegroups.com...
> Try refreshing enterprise manger.
>
> Regards
> Amish Shah
>|||I have found disconnecting from the server and/or shutting down EM helps.
--
Joseph R.P. Maloney, CSP,CCP,CDP
"Shayaan Siddiqui" wrote:
> I used the right mouse button and clicked REFRESH.
> and nothing happened.
> Anything else I can try?
> Thanks
> "amish" <shahamishm@.gmail.com> wrote in message
> news:1143649651.420463.246200@.v46g2000cwv.googlegroups.com...
> > Try refreshing enterprise manger.
> >
> >
> > Regards
> > Amish Shah
> >
>
>|||How do you do this?
Do you click the "X" or is there another process?
Shayaan
"jrpm" <jrpm@.discussions.microsoft.com> wrote in message
news:9576EDFF-5EF4-4944-8B59-EF4422D1A05F@.microsoft.com...
>I have found disconnecting from the server and/or shutting down EM helps.
> --
> Joseph R.P. Maloney, CSP,CCP,CDP
>
> "Shayaan Siddiqui" wrote:
>> I used the right mouse button and clicked REFRESH.
>> and nothing happened.
>> Anything else I can try?
>> Thanks
>> "amish" <shahamishm@.gmail.com> wrote in message
>> news:1143649651.420463.246200@.v46g2000cwv.googlegroups.com...
>> > Try refreshing enterprise manger.
>> >
>> >
>> > Regards
>> > Amish Shah
>> >
>>|||This is a multi-part message in MIME format.
--=_NextPart_000_0008_01C653E0.B89F5FB0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Any suggestions?
Thanks
"Shayaan Siddiqui" <givethis@.mac.com> wrote in message =news:e2hL$h0UGHA.5884@.TK2MSFTNGP14.phx.gbl...
I have 7 SQL Servers
They all sync once every hour.
One of my servers shows 2 Views (while the others show 4). SO I tried =to create the missing view's and I get this error message
"ODBC error: [Microsoft][ODBC SQL Server Driver][SQL Server]There is =already an object named <name> already exists"
Thank You
--=_NextPart_000_0008_01C653E0.B89F5FB0
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
&
Any suggestions?
Thanks
"Shayaan Siddiqui" wrote in =message news:e2hL$h0UGHA.5884=@.TK2MSFTNGP14.phx.gbl...
I have 7 SQL Servers
They all sync once every =hour.
One of my servers shows 2 Views =(while the others show 4). SO I tried to create the missing view's and I get this error message
"ODBC error: [Microsoft][ODBC =SQL Server Driver][SQL Server]There is already an object named =already exists"
Thank =You
--=_NextPart_000_0008_01C653E0.B89F5FB0--
--=_NextPart_000_0006_01C6531E.93D6CCD0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
I have 7 SQL Servers
They all sync once every hour.
One of my servers shows 2 Views (while the others show 4). SO I tried to = create the missing view's and I get this error message
"ODBC error: [Microsoft][ODBC SQL Server Driver][SQL Server]There is = already an object named <name> already exists"
Thank You
--=_NextPart_000_0006_01C6531E.93D6CCD0
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
&
I have 7 SQL Servers
They all sync once every = hour.
One of my servers shows 2 Views (while = the others show 4). SO I tried to create the missing view's and I get this error message
"ODBC error: [Microsoft][ODBC = SQL Server Driver][SQL Server]There is already an object named already = exists"
Thank You
--=_NextPart_000_0006_01C6531E.93D6CCD0--Try refreshing enterprise manger.
Regards
Amish Shah|||I used the right mouse button and clicked REFRESH.
and nothing happened.
Anything else I can try?
Thanks
"amish" <shahamishm@.gmail.com> wrote in message
news:1143649651.420463.246200@.v46g2000cwv.googlegroups.com...
> Try refreshing enterprise manger.
>
> Regards
> Amish Shah
>|||I have found disconnecting from the server and/or shutting down EM helps.
--
Joseph R.P. Maloney, CSP,CCP,CDP
"Shayaan Siddiqui" wrote:
> I used the right mouse button and clicked REFRESH.
> and nothing happened.
> Anything else I can try?
> Thanks
> "amish" <shahamishm@.gmail.com> wrote in message
> news:1143649651.420463.246200@.v46g2000cwv.googlegroups.com...
> > Try refreshing enterprise manger.
> >
> >
> > Regards
> > Amish Shah
> >
>
>|||How do you do this?
Do you click the "X" or is there another process?
Shayaan
"jrpm" <jrpm@.discussions.microsoft.com> wrote in message
news:9576EDFF-5EF4-4944-8B59-EF4422D1A05F@.microsoft.com...
>I have found disconnecting from the server and/or shutting down EM helps.
> --
> Joseph R.P. Maloney, CSP,CCP,CDP
>
> "Shayaan Siddiqui" wrote:
>> I used the right mouse button and clicked REFRESH.
>> and nothing happened.
>> Anything else I can try?
>> Thanks
>> "amish" <shahamishm@.gmail.com> wrote in message
>> news:1143649651.420463.246200@.v46g2000cwv.googlegroups.com...
>> > Try refreshing enterprise manger.
>> >
>> >
>> > Regards
>> > Amish Shah
>> >
>>|||This is a multi-part message in MIME format.
--=_NextPart_000_0008_01C653E0.B89F5FB0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Any suggestions?
Thanks
"Shayaan Siddiqui" <givethis@.mac.com> wrote in message =news:e2hL$h0UGHA.5884@.TK2MSFTNGP14.phx.gbl...
I have 7 SQL Servers
They all sync once every hour.
One of my servers shows 2 Views (while the others show 4). SO I tried =to create the missing view's and I get this error message
"ODBC error: [Microsoft][ODBC SQL Server Driver][SQL Server]There is =already an object named <name> already exists"
Thank You
--=_NextPart_000_0008_01C653E0.B89F5FB0
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
&
Any suggestions?
Thanks
"Shayaan Siddiqui"
I have 7 SQL Servers
They all sync once every =hour.
One of my servers shows 2 Views =(while the others show 4). SO I tried to create the missing view's and I get this error message
"ODBC error: [Microsoft][ODBC =SQL Server Driver][SQL Server]There is already an object named =already exists"
Thank =You
--=_NextPart_000_0008_01C653E0.B89F5FB0--
Subscribe to:
Posts (Atom)