Can you explain different types of locks in sql server?
No Answer is Posted For this Question
Be the First to Post Answer
Explain primary key in sql server?
How to find the date and time of last updated table?
What is the difference RDBMS and Graph Database?
What is the meaning of sql server?
How can i give the restrictions for the data entry, if i wish to enter only I ,II, III, IV in the grade actegory of student table?
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
What command do we use to rename a database?
What is Covering Indexes? Plz explain with example
What is normalization 1nf 2nf 3nf?
What is the default order of an order by clause?
How do you manipulate data?
Is truncate autocommit?