How to create a view and a stored procedure in ms sql server using "create view/procedure" statements?
No Answer is Posted For this Question
Be the First to Post Answer
How to list all schemas in a database?
what is database replicaion? : Sql server database administration
How do you simulate a deadlock for testing purposes
Help!!!!!!!!!!!! My database has gone offline, it is highlighted as 'Suspect'. Foolishly, i haven't got a recent back up. Is there a way of quickly restoring the database? Thank you
What is exporting and importing utility?
How can you see what type of locks used?
What is filtered index?
How to generate random numbers with the rand() function in ms sql server?
What is ACID Property of Transaction?
What is an index. What are the types?
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?
How do you check the performance of a query and how do you optimize it?
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)