List out the differences between global and local temp tables in sql server?
No Answer is Posted For this Question
Be the First to Post Answer
What is difference between rownum and rowid?
Are all views updatable ?
i have made a project i vb.net n created a .exe of it after installing it in to any pc, the database (sql express) is not geting accesed i.e the aplication cuts the link of the database, so plz help in this matter.
i have 4 tables.. T1, T2, T3, T4.. these tables have the same structure and they store the information entered in different years.. T1 stored 2002, T2 stored 2003, T3 stored 2004 and T4 stored 2005.. i want to copy contents in T1 to T2, T2 to T3, T3 to T4 and T4 to T1.. how do i do that? Temp tables cannot be used..
What is difference between clustered index and non clustered index?
What is Cross Join and in which scenario do we use Cross Join?
Can we update data in a view?
What is difference between aggregate and analytic function?
what is database replicaion? What are the different types of replication you can set up in sql server? : Sql server database administration
List some case manipulation functions in sql?
What are constraints in microsoft sql server?
write the query for find the top 2 highest salary in sql server
36 Answers Cranes, Jayanti Software, Medi Assist, Rmax, TCS,
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)