Answer / Sachin Gupta

"SQL Server English Query (SEQ) allows users to write T-SQL statements using natural language instead of traditional structured query syntax. It uses machine learning and AI technologies to convert the natural language into valid T-SQL code, making it easier for non-technical users to interact with SQL Server databases."

What is the dbcc command and why is it used?

1 Answers  

---

Do you know the cursor types?

1 Answers  

---

Which data type can be used only on OUTPUT parameters of the stored proceduer?

2 Answers  

---

What is the minimum and maximum number of partitions required for a measure group? : sql server analysis services, ssas

1 Answers  

---

Write a stored procedure for emplpoyee and department table to get DeptName which having no employee. Table Structure- Emp-Emp_Id,Emp_Name,Dept_id Dept-Dept_Id,Dept_Name

7 Answers   TCS,

---

Can multiple columns be used in sql group by clause in ms sql server?

1 Answers  

---

Tell me what do you understand by a view? What does the with check option clause for a view do?

1 Answers  

---

Can you give me some DBCC command options?(Database consistency check) - DBCC CHECKDB - Ensures that tables in the db and the indexes are correctly linked.and DBCC CHECKALLOC - To check that all pages in a db are correctly allocated. DBCC SQLPERF - It gives report on current usage of transaction log in percentage. DBCC CHECKFILEGROUP - Checks all tables file group for any damage.

1 Answers   iSoft,

---

What is the difference between delete and truncate statements?

1 Answers  

---

Explain the working of sql privileges?

1 Answers  

---

What are the different subsets of sql?

0 Answers  

---

What is b tree index?

1 Answers  

---