sql Archives - Page 32 of 45

SQL query to select dates between two dates

I have a start_date and end_date. I want to get the list of dates in between these two dates. Can anyone help me ...

May 10, 2022
0 Comments

Error 1046 No database Selected, how to resolve?

Error SQL query: -- -- Database: `work` -- -- -------------------------------------------------------- -- -- Table structure for table `administrators` -- CREATE TABLE IF NOT EXISTS ...

May 10, 2022
0 Comments

How to implement one-to-one, one-to-many and many-to-many relationships while designing tables?

Can anyone explain how to implement one-to-one, one-to-many and many-to-many relationships while designing tables with some examples? 4 Answers 4

May 9, 2022
0 Comments

Convert INT to VARCHAR SQL

I am using Sybase and I am doing a select which returns me a column called “iftype”, but its type is int and ...

May 9, 2022
0 Comments

Get all table names of a particular database by SQL query?

I am working on application which can deal with multiple database servers like “MySQL” and “MS SQL Server”. I want to get tables’ ...

May 9, 2022
0 Comments

What is the equivalent of ‘describe table’ in SQL Server?

I have a SQL Server database and I want to know what columns and types it has. I’d prefer to do this through ...

May 9, 2022
0 Comments

How can I select the first day of a month in SQL?

I just need to select the first day of the month of a given DateTime variable. I know it’s quite easy to do ...

May 9, 2022
0 Comments

What is the difference between SQL, PL-SQL and T-SQL?

What is the difference between SQL, PL-SQL and T-SQL? Can anyone explain what the differences between these three are, and provide scenarios where ...

May 9, 2022
0 Comments

SQL Server – Return value after INSERT

I’m trying to get a the key-value back after an INSERT-statement. Example: I’ve got a table with the attributes name and id. id ...

May 9, 2022
0 Comments

Best way to test if a row exists in a MySQL table

I’m trying to find out if a row exists in a table. Using MySQL, is it better to do a query like this: ...

May 9, 2022
0 Comments