Can we write trigger for view?
Suppose in a situation if two list boxes are there and if you select multiple options based on that the options related to those selected items should display in second list box. Again if we select multiple items in second listbox then the related to those selected items should display . In this scenario how will you design database,tables?
explain different types of backups avaialabe in sql server? : Sql server database administration
please bar with my english i having a database called tblhallreservation in which res_date is date field has to select all the fields in table deponding on month either has to display all details for the month jan or feb and so on
What is Cross Join and in which scenario do we use Cross Join?
What is the contrast between sql and mysql?
you have a table with close to 100 million records recently, a huge amount of this data was updated now, various queries against this table have slowed down considerably what is the quickest option to remedy the situation? : Sql server administration
What is implicit cursors?
What is trigger ?
List the ways in which dynamic sql can be executed?
What is transaction server isolation?
Can you pass expressions to stored procedure parameters?
What is the sql profiler?