Can I know,how to Execute Funcion and Trigger through
command(Manualy Execution) in MS SQL/SERVER 2005,give me
answer with Example.
Function can excute by the SELECT statement
ex SELECT Functionname(parameters), select *from
functionname
select s_func(Parameters)
We cant execute the trigger ,
When we perform a DML(DELETE,INSERT,UPDATE) operation
Trigger will fire automatically
| Is This Answer Correct ? | 4 Yes | 0 No |
What is a View ? Can we insert, Update and delete a view?
How cand Optimize SQL Server Stored Procedures
system date format is "yy-mm-dd" "select getdate()" ----> 2009-01-24 20:03:28.513 if i write "select dateadd(dd,2,getdate()) ".it returns "2009-01-26 19:59:38.340"...my question is dat could it be possible to retrive da date in da format "26 jan 2009 ...."??
what are cursors? : Sql server database administration
What is INTVAL( )and where we use Plz any body help me
What is the difference between a stored procedure and a user defined function?
Why use triggers?
what is the Enterprise manager(2000) and management studio (2005)?
How do I edit a stored procedure in sql server?
What is difference between clustered and non clustered index?
What is database normalization?
7 Answers Deloitte, Digicel, JPMorgan Chase, Verifone,
What is sql server management studio? : sql server management studio
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)