What is the difference between a view and a stored procedure?
No Answer is Posted For this Question
Be the First to Post Answer
What is a derived table?
What are cursors stored procedures and triggers?
How reterive duplicate value in SQL?
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?
Can you explain what is sql server english query?
Can we use custom code in ssrs?
How to use transact-sql statements to access the database engine?
Assume,there are three tables in a database, Can i have both primary key and foreign key for each table in the same database?
Does union all remove duplicates?
Is it possible to create trigger on views?
Why should one not prefix user stored procedures with ‘sp_’?
Can the query output be sorted by multiple columns in ms sql server?