How you can change a cross join into an inner join?


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

Post New Answer

More SQL Server Interview Questions

What are the properties of sub-query?

0 Answers  


How to how to convert numeric expression data types using the convert() function??

0 Answers  


whats the maximum size of view state??

0 Answers  


How to retrieve field values using mssql_result()?

0 Answers  


Where in ms sql server is ’100’ equal to ‘0’?

0 Answers  






What is table value parameters (tvp)?

0 Answers  


When a primary key constraint is included in a table, what other constraints does this imply?

0 Answers  


What is user-defined functions? What are the types of user-defined functions that can be created?

0 Answers  


what is performance tunning in sql server ? explain.

1 Answers   Thomson Reuters,


when u import an excel file into sql if suppose one column has got a date field with system time attached to it what data type u will use in sql to import it in a table? Note: a condition is the excel file has no primary key defined to a column...also u r importing bulk data into sql

1 Answers  


What does the on update no action do?

0 Answers  


What is the difference between NOROW and LOCKROW?

0 Answers   Accenture, Honeywell, Satyam,


Categories