What is clustered vs nonclustered index?
No Answer is Posted For this Question
Be the First to Post Answer
What is a not null constraint?
How to truncate a table first before running a package?
how can you check the level of fragmentation on a table? : Sql server administration
I applied Transactional with updatable subscriptions replication on 2 tables now i want to delete those 2 tables but i cannot delete those tables as replication is running how can i stop replication for those 2 tables(but i don't want to delete those replicated tables but i need to stop the replication) how can i do that
What is local temp table?
What are sub-queries? Give example? In which case sub-queries are not feasible?
What are indexers?
What is the difference between mysql and mysqli?
How many categories of data types used by sql server?
Explain the truncate command? : SQL Server Architecture
What is PROJECTION Operation?
how to update a null value field in sql server eg a table contains 3 fields id,name,salary and 3 records salary of 1 record is null i want update the nullfield 111 arun 300 112 ddd 200 113 ttt null i want to update table with add 100 to every record include null after updation the recrds should be 111 arun 400 112 ddd 300 113 ttt 100
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)