two tables with table name ship(name,year) and battle
(name,year),how to find the latest added year in the table
ship
What is a livelock?
How will you collect the date from current date to last older 6 days date in sql server 2005
How to drop existing views from a database in ms sql server?
Explain about system database?
How many types of Outer Joins?What are they?
Do you know what are various aggregate functions that are available?
How to connect PK and FK?
What is the fastest way to permanently delete a 1 million row table named customers?
How do you optimize Sql queries ?
What are the differences between substr and charindex in sql server.
could you please reply for these question: 1.About Use Apply? 2.Avoid cursors - When we have a situation that we can not avoid the use of cursor than what is the alternate solution? is there anything we can use instead of cursor to perform the desired task? which optiomize the peroformance too. 3.What is computed columns? Thanks in advance. Regards, Rupesh
Explain the difference between HTTP and HTTPS in database?
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)