Can we check locks in database? If so, how can we do this lock check?
No Answer is Posted For this Question
Be the First to Post Answer
Do you know what are the restrictions applicable while creating views? : SQL Server Architecture
How many max. conditions can b written under the WHERE clause? Like select * from [tabnam] WHERE (cond1...or..cond2....or...cond3...and.....so on.....??? (upto how much extent))?????
What is a view in sql?
How to create user defined functions with parameters?
What is intellisense?
What are the types of database recovery models?
i want to join two queries....and i want to run them as one after another that is want output of first query then second , then again output of first query then second and so on...
can we have a nested transaction? : Sql server database administration
What is the difference between drop table and truncate table?
Does partitioning improve performance?
you have couple of stored procedures that depend on a table you dropped the table and recreated it what do you have to do to reestablish those stored procedure dependencies?
Table - Products has number of products as below Productid ProductName 1 iPhone 2 iPad 3 BlackBerry Table - SalesPersonProduct has the below records Salespersonid productid S1 1 S1 2 S1 3 S2 1 S3 2 Write a SQL query that returns the number of sales for each product
Oracle (3253)
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)