sql Archives - Page 42 of 45

How can I get column names from a table in SQL Server?

I want to query the name of all columns of a table. I found how to do this in: Oracle MySQL PostgreSQL But ...

April 18, 2022
0 Comments

Function vs. Stored Procedure in SQL Server

I’ve been learning Functions and Stored Procedure for quite a while but I don’t know why and when I should use a function ...

April 17, 2022
0 Comments

Exclude a column using SELECT * [except columnA] FROM tableA?

We all know that to select all columns from a table, we can use SELECT * FROM tableA Is there a way to ...

April 17, 2022
0 Comments

Search text in stored procedure in SQL Server

I want to search a text from all my database stored procedures. I use the below SQL: SELECT DISTINCT o.name AS Object_Name, o.type_desc ...

April 16, 2022
0 Comments

Join vs. sub-query

I am an old-school MySQL user and have always preferred JOIN over sub-query. But nowadays everyone uses sub-query, and I hate it; I ...

April 16, 2022
0 Comments

INNER JOIN ON vs WHERE clause

For simplicity, assume all relevant fields are NOT NULL. You can do: SELECT table1.this, table2.that, table2.somethingelse FROM table1, table2 WHERE table1.foreignkey = table2.primarykey ...

April 15, 2022
0 Comments

Save PL/pgSQL output from PostgreSQL to a CSV file

What is the easiest way to save PL/pgSQL output from a PostgreSQL database to a CSV file? I’m using PostgreSQL 8.4 with pgAdmin ...

April 15, 2022
0 Comments

When should I use CROSS APPLY over INNER JOIN?

What is the main purpose of using CROSS APPLY? I have read (vaguely, through posts on the Internet) that cross apply can be ...

April 15, 2022
0 Comments

Parameterize an SQL IN clause

How do I parameterize a query containing an IN clause with a variable number of arguments, like this one? SELECT * FROM Tags ...

April 15, 2022
0 Comments

SQL update from one Table to another based on a ID match

I have a database with account numbers and card numbers. I match these to a file to update any card numbers to the ...

April 15, 2022
0 Comments