1.what are diff types of joins , and explain diff between cross join and full outer join 2.diff types of views 3. Diff types of index 4. What is diff b/w stores procedure and function procedure 5.diff between double and int in SQL 6.diff between char and varchar in SQL. 7.Oracle or SQL whice you will preferred and why.290
what is checksum in sql server.........???
in a table is b in column k (manikanta,sivananda,muralidhar) i want result like (mnikanta,sivnanda,murlidhar) please slove it231
how can you select rexcord(rows) from table A which is not present in Table B . Id being the FK in Table B referencing to ID Table A297
What is Lock table in SQL?174
Can we call a function that has out parameter in select statement19
Call by value and call by reference in procedure and function, with NOCOPY.78
If we delete pack Spec what will be the status of pack Body ?108
Delete duplicate rows without using rowid.113
What is RMS migrations?
Why do you want to join software field as you have done your BE in Electronics?
What is the difference between MVC and Teir Architecher? Plz explain with Layyered Programming example...? Thanks
In my application I have a process which picks the scanned files (tif format) from a shared location and it links to application and shown on it.The actuall issue is that my process picks the file before it is completly written or scanned which results in displaying few parts of the image or incomplete image.I need to check if the file is not completly scanned or written then do not link it to application.Please help if any body tell me that how can i check that file is in written phase or locked through DTS.thanking you in advance
Help!!!!!!!!!!!! My database has gone offline, it is highlighted as 'Suspect'. Foolishly, i haven't got a recent back up. Is there a way of quickly restoring the database? Thank you
what are questions asked in TCS for database tester (sqlserver)for 2-3 exp?
How do you Implement SSIS Packages in your Project?
What is Lock table in SQL?
how to do partition in sqlserver
hi, how to link a text file and a .rpt file in my tables of sql server and to retrieve those records for further use. reply me as soon as possible.
How do use Having,Group by,Group function in SQL?
How should i optimize the time for execution of stored procedure having single input and many output from the different tables?
If a stored procedure is taking a table data type, how it looks?
How retrieve field names from the table in SQL through JAVA code?
explain the difference between oracle- sql and sql server sql ? if both are same y we r using 2 sw.s?