Ugh ok I’m terrible at explaining things, so I’ll just give you the quotes and links first: Problem 4b (near bottom): 4b. List the film title and the leading actor for all of ‘Julie Andrews’ films….
Tag: sql
How do you import a large MS SQL .sql file?
I use RedGate SQL data compare and generated a .sql file, so I could run it on my local machine. But the problem is that the file is over 300mb, which means I can’t do copy and paste because the …
How to resolve ambiguous column names when retrieving results?
I have two tables in my database: NEWS table with columns: id – the news id user – the user id of the author) USERS table with columns: id – the user id I want to execute this SQL: SELECT * …
Are there Free SQL Server Mgmt Studio Autocomplete Add-ins? [closed]
Closed. This question does not meet Stack Overflow guidelines. It is not currently accepting answers. We don’t allow questions seeking recommendations for books, tools, software libraries, and more. You can edit the question so it can be answered with facts and citations. Closed 14 days ago. Improve this ques…
is there a PRODUCT function like there is a SUM function in Oracle SQL?
I have a coworker looking for this, and I don’t recall ever running into anything like that. Is there a reasonable technique that would let you simulate it? would yield 30 Answer edit: if col always > 0
SPARQL Query, select everything except things that match?
I am getting comfortable writing regular queries in SPARQL, but I’m still having trouble with fancier stuff. My latest problem is trying to select everything except stuff that matches the where clause. For instance, say I want to find all the husbands who like a car color that their wife doesn’t l…
SQL – Temp Table: Storing all columns in temp table versus only Primary key
I would need to create a temp table for paging purposes. I would be selecting all records into a temp table and then do further processing with it. I am wondering which of the following is a better approach: 1) Select all the columns of my Primary Table into the Temp Table and then being able to select the ro…
What are the most common SQL anti-patterns? [closed]
As it currently stands, this question is not a good fit for our Q&A format. We expect answers to be supported by facts, references, or expertise, but this question will likely solicit debate, arguments, polling, or extended discussion. If you feel that this question can be improved and possibly reopened, …
Table Naming Dilemma: Singular vs. Plural Names [closed]
Closed. This question is opinion-based. It is not currently accepting answers. Want to improve this question? Update the question so it can be answered with facts and citations by editing this post. Closed 8 years ago. Improve this question Academia has it that table names should be the singular of the entity…
Parameterize an SQL IN clause
How do I parameterize a query containing an IN clause with a variable number of arguments, like this one? In this query, the number of arguments could be anywhere from 1 to 5. I would prefer not to use a dedicated stored procedure for this (or XML), but if there is some elegant way specific to SQL Server 2008…