sql Archives - Page 5 of 45

Programming, sql

IT Nursery

Is SQL or even TSQL Turing Complete?

This came up at the office today. I have no plans of doing such a thing, but theoretically could you write a compiler ...

May 31, 2022
0 Comments

Programming, sql

IT Nursery

How to check if a table exists in a given schema

Postgres 8.4 and greater databases contain common tables in public schema and company specific tables in company schema. company schema names always start ...

May 31, 2022
0 Comments

Programming, sql

IT Nursery

How can I get column names from a table in Oracle?

I need to query the database to get the column names, not to be confused with data in the table. For example, if ...

May 31, 2022
0 Comments

Programming, sql

IT Nursery

Are database triggers evil? [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, ...

May 31, 2022
0 Comments

Programming, sql

IT Nursery

Equivalent of LIMIT and OFFSET for SQL Server?

In PostgreSQL there is the Limit and Offset keywords which will allow very easy pagination of result sets. What is the equivalent syntax ...

May 31, 2022
0 Comments

Programming, sql

IT Nursery

Add unique constraint to combination of two columns

I have a table and, somehow, the same person got into my Person table twice. Right now, the primary key is just an ...

May 31, 2022
0 Comments

Programming, sql

IT Nursery

Use ‘=’ or LIKE to compare strings in SQL?

There’s the (almost religious) discussion, if you should use LIKE or ‘=’ to compare strings in SQL statements. Are there reasons to use ...

May 31, 2022
0 Comments

Programming, sql

IT Nursery

mySQL :: insert into table, data from another table?

I was wondering if there is a way to do this purely in sql: q1 = SELECT campaign_id, from_number, received_msg, date_received FROM `received_txts` ...

May 31, 2022
0 Comments

Programming, sql

IT Nursery

How do I use ROW_NUMBER()?

I want to use the ROW_NUMBER() to get… To get the max(ROW_NUMBER()) –> Or i guess this would also be the count of ...

May 31, 2022
0 Comments

Programming, sql

IT Nursery

Left Join With Where Clause

I need to retrieve all default settings from the settings table but also grab the character setting if exists for x character. But ...

May 30, 2022
0 Comments