what is a schema in sql server 2005? Explain how to create a new schema in a database? : Sql server database administration
No Answer is Posted For this Question
Be the First to Post Answer
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
what are constraints? Explain different types of constraints? : Sql server database administration
Do you know how to send email from database?
what is the difference between delete table and truncate table commands? : Sql server database administration
What is transact-sql ddl trigger?
What are the difficulties faced in cube development? : sql server analysis services, ssas
What is the difference between Temporary table variable and a Table variable? Or Which Table variable I should use inside Stored procedure?
3 Answers Microsoft, TCS, Techastrum,
What is optimization and its types?
how do you test proper tcp/ip configuration windows machine? : Sql server database administration
What can be used instead of trigger?
what is the use of database index(apart from the last searching of records) and what is the use of composite key?
Write a program to fetch first 10 records from a file?
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)