Run an SQL Query With a Parameter from Excel 2007
Dunno why MS has made this so complicated, You will have to use Microsoft Query. Click on Data -> From External Sources -> … Read more
query
Querying a CSV file
Have you tried LogParser? Log parser is a powerful, versatile tool that provides universal query access to text-based data such as log files, … Read more
Does an anchor tag come before the query string or after?
Best practice is to append the named anchor at the end. The technical name is a fragment identifier, and the syntax is in … Read more
Stored procedure executes too long
We use SQL Server 2008. When I am watching in SQL Server Profiler I found some queries that take for example 20 seconds. … Read more
Generating two rows from one source row
I have a table which has columns: txn_id from_user_id to_user_id price I want a query that produces two rows for each source row. … Read more
An UPDATE runs unexpectedly on MySQL 5.7 whereas it runs as expected on prior versions
I use a column called sequence on tables where I have to re-sort blocks of rows into an arbitrarily order. CREATE TABLE `tkmemberstage` … Read more
PostgreSQL how to return data from anonymous code block?
I have a table mytable (id, “someLongURI”, status, “userId”) and a working query: UPDATE mytable SET status=”IN_WORK” WHERE “someLongURI” IN ( SELECT “someLongURI” … Read more
How to change Postgres primary key column values?
My postgres database has a column called “id” that runs from 40,000,000 to about 50,000,000. The “id” column is the primary key. I … Read more
Speed up search across multiple columns
We have a table: user_info (user_id,domain_id,first_name,middle_name,last_name,work_place,.,.,.) Now, we have a user search that search across three columns first_name,last_name and work_place. If a user … Read more
Checking a wide table for nulls [duplicate]
This question already has answers here: Closed 10 years ago. Possible Duplicate: Test if any fields are NULL I am new here. I … Read more
