| SQL Server Triggers Interview Questions |
|
|
|
|
I have Red hat Linux 4.0 and i want to install a data base on it where that should behave just like Microsoft SQL Server 2000 ( Store procedures, Views, Triggers, also considerable in it ). Please, help me if there is any solution available.
|
|
|
|
what is trigger in sql server?
tell me an example.
|
|
|
|
I have a number of sheets which fetch the data from SQL server - unfortunately the sheer quantity of the sheets is overwhelming the server and when the sheets refresh (on open), the server timeouts - which means that the data does not refresh.
My question is : how can I either stagger the refresh, increase the refresh timeout duration or have internal VBA code iterate over the sheets and trigger data refresh manually?
|
|
|
|
Hey I have to alter a table field from varchar2(5) to number(11) the table contains roughly 50 million records and is indexed and the like. I have used regular DDL and then went with bulk collecting & updating via PL/SQL and the PL/SQL did improve things but not enough.
To alter, I have been adding a temp field, assigning the data to the temp field, nulling the old field, reassigning the temp_field back to the old field, and dropping the temp field.
One complication is the old field occasionally has a non-numeric in it. I have a trigger designed to handle this when assigning to the temp field.
Anyway thanks
The Wisconsin Skier
|
|
|
|
I am using SQL Server 2000.
|
|
|
|
i'm IT student, still new in asp. i'm now developing a system using asp and sql server2000. one of the system's function is:
the system should be able to trigger email automatically to the staff to inform them about something.
how can i do this?using SMTP? i refer to thiese source, but still can't function. it appear server error code 500...
html code:
<form method="POST" action="tizagEmail.asp">
To <input type="text" name="To"/>
From <input type="text" name="From"/>
Subject <input type="text" name="Subject"/>
Body <textarea name="Body" rows="5" cols="20" wrap="physical" > </textarea>
<input type="submit" /></form>
asp code:
<%
Dim mail
Set mail = Server.CreateObject("CDO.Message")
mail.To = Request.Form("To")
mail.From = Request.Form("From")
mail.Subject = Request.Form("Subject")
mail.TextBody = Request.Form("Body")
mail.Send()
Response.Write("Mail Sent!")
'Destroy the mail object!
Set mail = nothing
%>
anyone please help me, thx a lot
|
|
|
|
I'm trying to create a trigger... Why doesn't this work:
create trigger idx_trigger AFTER INSERT ON idx_datafeed_Plus_Residential_BH FOR EACH ROW
BEGIN
insert into idx_datafeed_Plus_Residential_KEYS SET IMPORT_FILE_DATE = '2008-08-02' ;
END;
The error I get is:
ERROR 1064 (42000) at line 14: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'insert into idx_datafeed_Plus_Residential_KEYS SET IMPORT_FILE_DATE = '2008-08' at line 3
thanks!
|
|
|
|
Related to oracle pl/sql and OCP.
|
|
|
|
im connected to one of my servers to view the tables for a database and i noticed for each database there are things called
views,procedures,functions,queries,tri... processes,variables,and character sets.
whats all this mean?
im viewing it through sql maestro for mysql.
|
|
|
|
In "Stored Procedures" in MY SQL is used to refer to procedures and __________
a. triggers
b.functiuons
c.methods
d.only procedure
|
|
|
|
1.An Exit statement can only be used inside a PL/SQL loop.
True
False
2.An inner loop can use a variable declared in the outer loop but the outer loop can not use variable declared in the inner loop.
True
False
3.An implicit cursor is automatically associated (generated) with every DML statement.
True
False
4. Main advantage of using an explicit cursor is that it allows you to process rows returned by SELECT statement, one row a a time.
True
False
5.Once all of the rows in the cursor have been processed (retreived), the cursor should be closed. Otherwise, it will generate syntax error.
True
False
6. A PL/SQL procedure can be created and stored in the database without execution of the code.
True
False
7. PL/SQL functions returns a scalar value and PL/SQL procedures return nothing. Both can take zero or more number of parameters as input or output.
True
False
8. A PL/SQL function can be called as part of a SQL expression or as part of a PL/SQL expression.
True
False
9. In PL/SQL function, multiple RETURN statements are allowed, usually within an IF statement. Only one RETURN statement will be executed.
True
False
10. The parameters of a function must be labeled IN or the function will not complete successfully.
True
False
11. IN OUT paramenters are permissible in PL/SQL functions.
True
False
12. PL/SQL package groups logically related program units like procedures and function.
True
False
13. All procedures and functions in a package body must be declared in the package specification.
True
False
14. A trigger is a PL/SQL block that executes implicitly whenever a particular event takes place.
True
False
|
|
|
|
1.An Exit statement can only be used inside a PL/SQL loop.
True
False
2.An inner loop can use a variable declared in the outer loop but the outer loop can not use variable declared in the inner loop.
True
False
3.An implicit cursor is automatically associated (generated) with every DML statement.
True
False
4. Main advantage of using an explicit cursor is that it allows you to process rows returned by SELECT statement, one row a a time.
True
False
5.Once all of the rows in the cursor have been processed (retreived), the cursor should be closed. Otherwise, it will generate syntax error.
True
False
6. A PL/SQL procedure can be created and stored in the database without execution of the code.
True
False
7. PL/SQL functions returns a scalar value and PL/SQL procedures return nothing. Both can take zero or more number of parameters as input or output.
True
False
8. A PL/SQL function can be called as part of a SQL expression or as part of a PL/SQL expression.
True
False
9. In PL/SQL function, multiple RETURN statements are allowed, usually within an IF statement. Only one RETURN statement will be executed.
True
False
10. The parameters of a function must be labeled IN or the function will not complete successfully.
True
False
11. IN OUT paramenters are permissible in PL/SQL functions.
True
False
12. PL/SQL package groups logically related program units like procedures and function.
True
False
13. All procedures and functions in a package body must be declared in the package specification.
True
False
14. A trigger is a PL/SQL block that executes implicitly whenever a particular event takes place.
True
False
|
|
|
|
I am running Zabbix on Ubuntu, It's the monitoring is wonderful,, and it basically does what it is supposed to. Maybe there is an option i am overlooking but when i configure Items/Triggers/Actions,, my actions (which is to send Email to an Administrative Group) actually loop up and i end up with multiple Emails for one trigger... I am looking for a way to get just 1 Email per trigger. For arguments sake i will include an example of my trigger item/trigger/action possibly i have configured improperly;
Item;
Fax Service is Down service_state[Fax]
Trigger;
{$ Z SQL Server:service_state[Fax].last(0)}#0
If the last value is not 0 then the trigger will send an Email Alert..
Other than that i don't think there is any more to the item, it's a part of a custom template that is assigned to servers.
|
|
|
|
Hi Guys and Firls,
My question is that while hiring someone who is a Java Developer or ColdFusion Developer or .Net Developer, companies mention that we need to know ORACLE. Can you please let me know what are they looking for in Oracle. Is it that we need to know every In-Out like how to install, how to configure, how to manage(which seems to be a DBA job) OR they just want that we should know PL/SQL, Views, Triggers, Procedures,Packages etc(which is more like what Oracle can do)?
Your help is well appreciated.
Thank You Guys. You are awesome.
Regards
Sandeep
|
|