In what three ways is the return statement used in a stored procedure?
how to know description of a table in sqlserver 2000
What is tempdb in sql server?
What is normalization?
Can binary strings be converted into numeric or float data types?
Difference between drill down and drill through report.
Describe about first three Normal forms.
How to send email from database?
What are different types of join?
Lets say due to N/W or Security issues client is not able to connect to server or vice versa. How do you troubleshoot?
Assume,there are three tables in a database, Can i have both primary key and foreign key for each table in the same database?
There is a trigger defined for INSERT operations on a table, in an OLTP system. The trigger is written to instantiate a COM object and pass the newly insterted rows to it for some custom processing. What do you think of this implementation? Can this be implemented better?
What is the difference between stored procedure and functions?