What are the new features introduced in SQL Server 2000 (or the latest release of SQL Server at the time of your interview)? What changed between the previous version of SQL Server and the current version?
No Answer is Posted For this Question
Be the First to Post Answer
Explain tablesample?
What are subqueries in sql server?
What is the difference between Normalization and De-normalization?
Can a table be moved to different filegroup?
What are the types of constraints?
How to delete multiple rows with one delete statement in ms sql server?
What is meant by datasource?
What is an etl file?
How to create a user to access a database in ms sql server using "create user" statements?
What the different components of Replication and what is their use?
2) Consider a Table name A which has below records ID --- 5 5 5 5 5 Consider another table B which has below records ID -- 5 5 5 5 5 5 5 5 How many rows will be returned by each of the below queries a) select * from A inner join B on A.id = b.ID b) select * from A left join B on A.id = b.ID c) select * from A right join B on A.id = b.ID
Can group functions be mixed with non-group selection fields 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)