Explain the difference between delete,drop and truncate in SQL Server?
No Answer is Posted For this Question
Be the First to Post Answer
Where do you find the default Index fill factor and how to change it?
What are the different types of collation sensitivity in sql server?
How will you make an attribute not process? : sql server analysis services, ssas
What is normalization and what are the different forms of normalizations?
What is the difference between a local and a global temporary table?
Hi, I Created 3 Tables Person(PersID[prkey],Name,Email,Password), Project(ProjName,ProjID[prkey],ProjLeader,ProjManager) & ProjectInvolvement(EntryDate,ProjID[frkey],PersID[frkey],ProjDuration). For this how can i INSERT,UPDATE & DELETE Through PROCEDURE? Please Post the Answer for me. Desai.
What are database states in ms sql server?
What do you mean by an execution plan? Why is it used? How would you view it?
You want to be sure that queries in a database always execute at the maximum possible speed. To achieve this goal you have created various indexes on tables which other statement will keep the database in good condition?
How to make remote connection in database?
what is the maximum size of sql row in mssql?
Assume,there are three tables in a database, Can i have both primary key and foreign key for each table in the same database?
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)