When would you use an insert into .. Select option versus an insert into .. Values option? Give an example of each?
No Answer is Posted For this Question
Be the First to Post Answer
What are tables in sql server?
Can a trigger be created on a view?
What is the difference between count and distinct count?
Diff between Composite key, Alternate Key, Candidate Key, Primary Key, Unique Key, Super Key, Foreign Key
How to give a user the option of importing Excel and a delimited text file into a SQL Server Database without manually using SQL DTS?
What is a view?
What is Sqlpaging in SqlServer 2005 ?
How do you manipulate data?
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 do you know about system database? : SQL Server Architecture
What does truncate do?
How do clustered indexes store data?