What is indexing and its types?
No Answer is Posted For this Question
Be the First to Post Answer
Equi join and non equi join is possible with sql server?
Their are two tables 'A' and'B'.Table 'A' contains 3 columns named 'eid','ename','dept'. Table 'B'contains 3 columns named'sid','designation','salary'. We have to retrieve the names of employees working in the same department,same designation and same salary. Its urgent can anyone help me out in this problem.
1)what is the difference between Reinitializing a Subscription and synchronization the subscription? 2)when to use reinitializing ? 3)when to use synchronization? 4)when adding table or deleting a table what to do?(reinz.. or syn) 5)when adding a column what to do?
Can we create a clustered index on composite primary key.
What is store procedure? When do you use?
If any possiable to use 2 primary key in single table? How many primary key & foreign key used in each table(min & max)?
Why functions are used in sql server?
What is difference between restoration and recovery in SQLServer?
What are the difference between primary key and unique key? : sql server database administration
How do I shrink an ldf file?
What is unpivot?
How to rename an existing table with the "sp_rename" stored procedure in ms sql server?
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)