Viewing 15 posts - 16 through 30 (of 57 total)
I ran into the same problem this week trying to expose 2 values from a table function for the current row. I ended up converting the table function to 2 standard...
May 18, 2006 at 8:12 pm
This trigger looks a bit like a conversion from Oracle with all the inherent pitfalls. Table Inserted includes all records stored by an after-statement trigger, not just a single row...
March 30, 2006 at 6:37 pm
Applications quite often treat multi-row inserts as individual transaction. I split my triggers into 2 sections for @@rowcount=1 and @@rowcount >1. In the latter I use a cursor which is...
December 6, 2005 at 7:20 pm
You may not be able to control the mainframe, but you control the target side. You can write an instead-of trigger instead of insert (trigger action happens before the insert) for...
December 6, 2005 at 6:33 pm
If you do not apply the initial snapshot, then these sps are not created at the subscriber. Every time a transaction at the publisher is replicated to the subscriber you'll...
October 10, 2005 at 9:16 pm
Essentially I want to set up replication without initial snapshot synchronisation and I want to avoid having to create these replication sps at all using some MS supplied procedures. SQL...
October 10, 2005 at 7:21 pm
No, I have not found the solution I was looking for. Instead, I start the Identity with -2147483648. I still can move to bigint if needed.
July 28, 2005 at 10:18 pm
I found another significant difference in trigger behaviour, which is not strictly due to different trigger implementation, but the way transactions are counted.
If @@trancount is used to find out if...
June 26, 2005 at 7:59 pm
If I remember correctly TNS stands for Transparent Network Substrate. An Oracle service name is associated with an Oracle database (instance). You create a service name when you create a...
June 23, 2005 at 7:18 pm
A blank char cannot be used in an oracle name. The double-quote in oracle is similar to sql svr's square brackets. If you create a table in oracle as TableName...
February 24, 2005 at 6:32 pm
Are you looking for the equivalent of Oracle sqlplus commands define, prompt and accept? These are only available in sqlplus - not in pl/sql.
T-sql is a poor cousing of pl/sql...
February 22, 2005 at 6:00 pm
One of your 3 parameters is a global (in out) parameter of a reference type - the equivalence of a cursor variable in sql svr I don't know if you...
February 1, 2005 at 6:45 pm
Without knowing what exactly is going on inside the oracle procedure it is hard to guess. For starters the error message could just be plain misleading.
If it is a procedure with a global...
January 31, 2005 at 12:39 am
Is your statement a pass-thru statment? If so, have you tried to embed your statement in an Oracle pl/sql block:
begin pkg.spname(par1,pa2,par3); end;
Exec is a SQL*PLUS commmand, not a pl/slq command if...
January 27, 2005 at 6:54 pm
Have you tried to enclose the parameters in brackets?
January 27, 2005 at 3:02 am