What is the difference between a stored procedure and a view?
I am confused about a few points: What is the difference between a stored procedure and a view? When should I use stored … Read more
sql
Concatenate multiple result rows of one column into one, group by another column [duplicate]
This question already has answers here: How to concatenate strings of a string field in a PostgreSQL ‘group by’ query? (14 answers) Closed … Read more
Select SQL Server database size
how can i query my sql server to only get the size of database? I used this : use “MY_DB” exec sp_spaceused I … Read more
PostgreSQL: Which Datatype should be used for Currency?
Seems like Money type is discouraged as described here My application needs to store currency, which datatype shall I be using? Numeric, Money … Read more
Counting null and non-null values in a single query
I have a table create table us ( a number ); Now I have data like: a 1 2 3 4 null null … Read more
Storing money in a decimal column – what precision and scale? [closed]
Closed. This question needs details or clarity. It is not currently accepting answers. Want to improve this question? Add details and clarify the … Read more
How to select a record and update it, with a single queryset in Django?
How do I run an update and select statements on the same queryset rather than having to do two queries: – one to … Read more
How to check existence of user-define table type in SQL Server 2008?
I have a user-defined table type. I want to check it’s existence before editing in a patch using OBJECT_ID(name, type) function. What type … Read more
psql invalid command \N while restore sql
I’m trying to restore my dump file, but it caused an error: psql:psit.sql:27485: invalid command \N Is there a solution? I searched, but … Read more
How to concatenate columns in a Postgres SELECT?
I have two string columns a and b in a table foo. select a, b from foo returns values a and b. However, … Read more