0
Add your answer:
Earn +20 pts
Can we use javascript in SQL stored procedure?
Transact-SQL in an internationally standardised method to create, modify and delete databases and tables, as well as insert, retrieve, modify and delete data stored in a database. With Microsoft SQL Server 2005 you can also author procedures in any managed language such as C# or VB. This is because it is integrated with the CLR which allows you write powerful programs inside stored procedures. All functionality of the .NET Framework BCL (Base Class Library) is available to your stored procedures. This means that developers have access to thousands of pre-built classes and routines which can be accessed. The BCL includes classes that provide functionality for improved string functioning, advanced math operations, file access, cryptography, and more.
What are the procedures used to identify and address surplus or missing equipment or resource?
write it down
What is Upper trigger point in schmitt trigger?
the point of input voltage at which Q1 begins to conduct
What are stored in heap memory?
Objects are stored in heap.
Is trigger finger genetic?
yes it is
What is trigger in DBMS?
A trigger is a special kind of stored procedures that automatically executes when an event occurs in the database server. Insert, update and delete are called as events.
What is Trigger is SQL Server 2005?
A trigger is a SQL procedure that initiates an action when an event (INSERT, DELETE or UPDATE) occurs. Triggers are stored in and managed by the DBMS.Triggers are used to maintain the referential integrity of data by changing the data in a systematic fashion. A trigger cannot be called or executed; the DBMS automatically fires the trigger as a result of a data modification to the associated table. Triggers can be viewed as similar to stored procedures in that both consist of procedural logic that is stored at the database level. Stored procedures, however, are not event-drive and are not attached to a specific table as triggers are. Stored procedures are explicitly executed by invoking a CALL to the procedure while triggers are implicitly executed. In addition, triggers can also execute stored procedures.Nested Trigger: A trigger can also contain INSERT, UPDATE and DELETE logic within itself, so when the trigger is fired because of data modification it can also cause another data modification, thereby firing another trigger. A trigger that contains data modification logic within itself is called a nested trigger.
What is Advantages and disadvantages of stored procedures?
1> Poor Exception handling 2>There are no debuggers available for stored procedures Siva.Pachigolla
What is the examples of Stored procedure?
sp_helpdb , sp_who2, sp_renamedb are a set of system defined stored procedures. We can also have user defined stored procedures which can be called in similar way.
What are stored-procedures?
It is a saved set of SQL commands that can be run by the user.
What is mean by trigger?
it s an stored procedures....it s an statements..that goes into effect when you modify data in a specified table using one or more data modification operations: UPDATE, INSERT,or DELETE.a trigger is a set of Structured Query Language (SQL) statements that automatically "fires off" an action when a specific operation, such as changing data in a table, occurs.
What are stored procedures in data bases?
Stored procedure is the pl-sql block in precomplile from and can be used to excecute plsql statement
Which of these procedures usually has a set time during which to write?
Free write
What risks are associated with electroencephalography?
Being off certain medications for one to two days may trigger seizures. Certain procedures used during EEG may trigger seizures in persons with epilepsy. Those procedures include flashing lights and deep breathing.
What are the procedures in rdbms?
Procedures in an RDBMS are programs that are written to accomplish a set of functions that cannot be done using a single query. A procedure contains a sequence of SQL Queries that can be executed one after the other by invoking the procedure. There are two kinds of procedures Functions & Stored Procedures.
What is the difference between a stored database procedure and a batch of SQL statements submitted by a client application?
Stored procedures prevent unauthorized access to data
What is the name of the SQL language used in SQL Server stored procedures?
Transact SQL (TSQL)
