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 |
How many .ndf files can we create in Sql server 2005?
what is a join and explain different types of joins? : Sql server database administration
How do I partition a table in sql server?
What command do we use to rename a db, a table and a column?
How do you persist objects, permissions in tempdb
What are the dmvs?
Explain different isolation levels?
Why functions are used in sql server?
What are the new security features added in sql server 2012? : sql server security
IF more than one Site is accessing the same Database server and I want to move the DB with Minimum down time? How will you do
you have separate development and production systems you want to move a copy of a development database into production to do this, you do a backup on the development system and restore to the production system after a few minutes, you begin getting calls from several customers saying that they are denied access to the system why? : Sql server administration
How to create a view using data from another view?
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)