Re: Using Passthrough Query to Disable Triggers

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance



hi Jeff,

jeff wrote:
is there a way I can run a passthrough query to call an appropriate Oracle Stored Procedure to do the same as MSSQL???
PL/SQL: ALTER TABLE tableName ENABLE|DISABLE ALL TRIGGERS;


mfG
--> stefan <--

.



Relevant Pages

  • MSSQL vs. SYBASE
    ... I am converting to MSSQL SERVER from SYBASE. ... by or called within a stored procedure. ... I can not find any type of callback ...
    (microsoft.public.sqlserver.programming)
  • Re: tool to write code which runs on the server
    ... VS.NET 2003 using MSSQL 2000? ... >> One solution is to write a Stored Procedure but the programming language ... >> to write a Stored Procedure but the programming language for Stored ... >> Order table with a OrderID as its primary and CustomerID as foreign key. ...
    (microsoft.public.sqlserver.programming)
  • Re: MSSQL Output Cursor Parameter
    ... property of a DataAdapter with the command for the stored procedure, ... > Oracle) or to SqlDbType.Variant > ... If it works with MSSQL too i won't need any> customization in my project. ... > If not i have to customize code like this:> ...
    (microsoft.public.dotnet.languages.csharp)
  • RE: preserving a relationship
    ... I'm not sure, Jeff, but it sounds like you are going the wrong way with the ... MfgID ... SerialID ... Now you can tie everything back to an Mfg, or Dept, or Model. ...
    (microsoft.public.access.tablesdbdesign)
  • Re: MSSQL 2005 Stored Procedure?
    ... Can somebody help me with MSSQL 2005 and stored procedure? ... dbs = DBI.connect('DBI:ODBC:MYDB', 'usr', 'pwd') ... update database. ...
    (comp.lang.ruby)