Do you know the different ddl commands in sql?


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

Post New Answer

More SQL Server Interview Questions

What are the different ways of moving data/databases between servers and databases in SQL Server?

1 Answers  


What is a join in sql? What are the types of joins?

0 Answers  


what is the purpose of creating view is sql server 2000

13 Answers   Wipro,


Hi All, I want to display all duplicate records in the table. My query has to fetch all the records which are duplicate(First Name or Last Name). Also I want the ability to also pull names where there might be a middle initial placed in the end of the first name field, (i.e., "Maria Z. " vs. "Maria") as well. Please guide me to find this. Table: ID FirstName LastName 1 Zach H Hoffman 2 Zach Hoffman 3 Troy Hoffman 4 Shawn Livermore 5 Prem S 6 Jony Hoffman H 7 Zach Modan I need the query to filter......... ID FirstName LastName 1 Zach H Hoffman 2 Zach Hoffman 3 Troy Hoffman 6 Jony Hoffman H 7 Zach Modan I hope this example will give you clear idea..... Thanks in Advance Prem

2 Answers  


What is the difference between a unique key and primary key?

0 Answers  


Explain what is row_number function?

0 Answers  


What is nolock?

0 Answers  


What is the template in sql?

0 Answers  


What is table level trigger?

0 Answers  


code to create procedure for taking databse backup in sql server or i have the query for it but what it's query returns means i want to show on my jsp that the databse backup has been taken on the basis of that return value.does it returns 0 or 1.wat is the code for that

0 Answers   IGT,


What is the meaning of lock escalation and why/how to stop this? : sql server database administration

0 Answers  


Explain about extended stored procedure?

0 Answers  


Categories