SQL

Is it possible to import data directly from T-SQL commands without using SQL Server Integration Services? If so, what are the commands?

Can a stored procedure call itself or recursive stored procedure? How many level SP nesting possible?

If you’re attempting to predict a customer’s gender, and you only have 100 data points, what problems could arise?

Write a SQL query to find the 7th highest employee salary from an Employee Table. If that employee is male, shift to the next employee in alphabetical order. Explain your answer.

You notice a system uses a lot of triggers to enforce foreign key constraints, and the triggers are error-prone and difficult to debug. What changes can you recommend to reduce the use of triggers?

Suppose in class, you have 3n boys and 2n girls with their names tabulated along with their weight and gender. Write a SQL query to separate students alphabetically who are over-weight (55kg for girls, 75kg for boys)

Name Designation Joining_Date Salary Ashutosh Singla HR 2019-12-15 80,000 Chandan Garg Admin 2019-10-09 60,000 Himanshi Kaur HR 2019-03-13 75,000 Mohit Dharm HR 2019-05-27 85,000 Meena Batra Accountant 2019-07-11 50,000 Omkar Singh Accountant 2019-01-05 45,000 Pratham Garg Admin 2019-05-27 65,000 Rakesh Sharma HR 2018-06-30 75,000 Sharadha Gupta Accountant 2019-09-18 50,000 Arrange the employees with respect to their Joining date, most experienced employee coming on the top followed by others. (Hint- In case of same date, preference should be HR>Admin>Accountant)

Name Designation Joining_Date Salary Ashutosh Singla HR 2019-12-15 80,000 Chandan Garg Admin 2019-10-09 60,000 Himanshi Kaur HR 2019-03-13 75,000 Mohit Dharm HR 2019-05-27 85,000 Meena Batra Accountant 2019-07-11 50,000 Omkar Singh Accountant 2019-01-05 45,000 Pratham Garg Admin 2019-05-27 65,000 Rakesh Sharma HR 2018-06-30 75,000 Sharadha Gupta Accountant 2019-09-18 50,000 The company has decided to give a pay raise of 5,000 to Accountants with a salary of less than 50,00. Find the employees satisfying the condition and create a new table ...

Name Designation Joining_Date Salary Ashutosh Singla HR 2019-12-15 80,000 Chandan Garg Admin 2019-10-09 60,000 Himanshi Kaur HR 2019-03-13 75,000 Mohit Dharm HR 2019-05-27 85,000 Meena Batra Accountant 2019-07-11 50,000 Omkar Singh Accountant 2019-01-05 45,000 Pratham Garg Admin 2019-05-27 65,000 Rakesh Sharma HR 2018-06-30 75,000 Sharadha Gupta Accountant 2019-09-18 50,000 Demonstrate how to write a query to show details of an HR whose name starts with M.

Consider the following database schema for an e-commerce website: Given the following schema of tables: Event table (no index/key) – contains event data recorded when an event occurs: event_name [VARCHAR], user_id [VARCHAR], time [TIMESTAMP]Transaction table (no index / key) – contains ...