What is openrowset sql server?


No Answer is Posted For this Question
Be the First to Post Answer

Post New Answer

More SQL Server Interview Questions

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

0 Answers  


How you provide security to cube? : sql server analysis services, ssas

0 Answers  


Which stored procedure will you be running to add a linked server?

1 Answers  


What is inline variable assignment?

0 Answers  


Can we join two tables without primary key?

0 Answers  






What is the system function to get the current user's user id?

3 Answers   TCS,


What is difference between views and stored procedures?

0 Answers  


Explain timestamp datatype?

0 Answers  


Explain the properties of subqueries in sql server?

0 Answers  


Write an sql query to sort a table according to the amounts in a row and find the second largest amount.

0 Answers   Amazon,


explain the difference between oracle- sql and sql server sql ? if both are same y we r using 2 sw.s?

0 Answers   ADP, iSoft,


Define candidate key, alternate key, and composite key.

0 Answers  


Categories