How to drop an existing stored procedure in ms sql server?

1093

Can a stored procedure call itself or recursive stored procedure? How many levels sp nesting is possible?

1019

What are user defined functions?

1069

in the physical file layout, where should the transaction log be stored in relation to the data file?

1044

How do I copy an entire mysql database?

949

What is database management system(dbms) and why it is used?

1086

How many TRIGGERS are allowed in MySql table?

1140

How to unlock microsoft access record locking information?

1305

How check triggers in sql server?

1058

What's the difference between 'union' and 'union all' ?

1053

1.what are diff types of joins , and explain diff between cross join and full outer join 2.diff types of views 3. Diff types of index 4. What is diff b/w stores procedure and function procedure 5.diff between double and int in SQL 6.diff between char and varchar in SQL. 7.Oracle or SQL whice you will preferred and why.

1670

What are the different types of trigger and explain its various uses and functions?

1175

How exceptions can be handled in sql server programming?

1079

What is serial data type in postgresql?

957

Tempdb is full. How would you clear it?

945