sql Archives - Page 37 of 45

Is there any efficiency difference in an explicit vs implicit inner join? For example: SELECT * FROM table a INNER JOIN table b ...

I’m looking for an efficient way to convert rows to columns in SQL server, I heard that PIVOT is not very fast, and ...

Why doesn’t the following work? SELECT name FROM (SELECT name FROM agentinformation) I guess my understanding of SQL is wrong, because I would ...

I want to update the top 100 records in SQL Server. I have a table T1 with fields F1 and F2. T1 has ...

I have the below error when I execute the following script. What is the error about, and how it can be resolved? Insert ...

How do you return 1 value per row of the max of several columns: TableName...

I am using SQL Server 2008 Management Studio and have a table I want to migrate to a different db server. Is there ...

I use ON DELETE CASCADE regularly but I never use ON UPDATE CASCADE as I am not so sure in what situation it ...

It appears that there is no concept of AUTO_INCREMENT in Oracle, up until and including version 11g. How can I create a column ...

What is the difference between the EXISTS and IN clause in SQL? When should we use EXISTS, and when should we use IN? ...