<script type="text/javascript">
var adfly_id = 11343933;
</script>
<script src="https://cdn.adf.ly/js/display.js"></script>
1. How will you pass a table returned by a SP as parameter to another SP.
2. Where is the table name stored in SQL Server?
Answer :-
3. Write a query to get all the table names.
4. Consider a subquery is used in more than one query in a SP. How will you achieve this? That is how will you write a query that reuses a subquery?
5. Table A has 5 rows and table B has 7 rows. How many rows does "Select * from A, B" return?
var adfly_id = 11343933;
</script>
<script src="https://cdn.adf.ly/js/display.js"></script>
1. How will you pass a table returned by a SP as parameter to another SP.
2. Where is the table name stored in SQL Server?
Answer :-
3. Write a query to get all the table names.
4. Consider a subquery is used in more than one query in a SP. How will you achieve this? That is how will you write a query that reuses a subquery?
5. Table A has 5 rows and table B has 7 rows. How many rows does "Select * from A, B" return?
No comments:
Post a Comment