How to run sql server 2005 books online on your local system?
No Answer is Posted For this Question
Be the First to Post Answer
What is table value parameters (tvp)?
When is the use of update_statistics command?
How to recreate an existing index in ms sql server?
How to execute function in stored procedure sql server?
please give me query code of unique fuction select UNIQUE (name) from emp_info Incorrect syntax near the keyword 'UNIQUE'.
do you know how to configure db2 side of the application? : Sql server database administration
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 is the use of @@spid?
What are locks in sql?
Explain the various types of concurrency problem?
How to create a simple table to test triggers in ms sql server?
If a table does not have a unique index, can a cursor be opened on it?