sql Archives - Page 36 of 45

SQL Server SELECT into existing table

I am trying to select some fields from one table and insert them into an existing table from a stored procedure. Here is ...

May 6, 2022
0 Comments

How to get multiple counts with one SQL query?

I am wondering how to write this query. I know this actual syntax is bogus, but it will help you understand what I ...

May 6, 2022
0 Comments

Postgres DB Size Command

What is the command to find the size of all the databases? I am able to find the size of a specific database ...

May 6, 2022
0 Comments

updating table rows in postgres using subquery

Using postgres 8.4, My goal is to update existing table: CREATE TABLE public.dummy ( address_id SERIAL, addr1 character(40), addr2 character(40), city character(25), state ...

May 6, 2022
0 Comments

SQL/mysql – Select distinct/UNIQUE but return all columns?

SELECT DISTINCT field1, field2, field3, ...... FROM table I am trying to accomplish the following sql statement but I want it to return ...

May 6, 2022
0 Comments

Entity Framework VS LINQ to SQL VS ADO.NET with stored procedures? [closed]

Closed. This question does not meet Stack Overflow guidelines. It is not currently accepting answers. Want to improve this question? Update the question ...

May 6, 2022
0 Comments

How to use GROUP BY to concatenate strings in SQL Server?

How do I get: id Name Value 1 A 4 1 B 8 2 C 9 to id Column 1 A:4, B:8 2 ...

May 6, 2022
0 Comments

How Stuff and ‘For Xml Path’ work in SQL Server?

Table is: Id Name 1 aaa 1 bbb 1 ccc 1 ddd 1 eee Required output: Id abc 1 aaa,bbb,ccc,ddd,eee Query: SELECT ID, ...

May 6, 2022
0 Comments

What is the meaning of the prefix N in T-SQL statements and when should I use it?

I have seen prefix N in some insert T-SQL queries. Many people have used N before inserting the value in a table. I ...

May 5, 2022
0 Comments

What are DDL and DML?

I have heard the terms DDL and DML in reference to databases, but I don’t understand what they are. What are they and ...

May 5, 2022
0 Comments