I am confused about a few points: What is the difference between a stored procedure and a view? When should I use stored procedures, and when should I use views, in SQL Server? Do views allow the creation of dynamic queries where we can pass parameters? Which one is the fastest, and on what basis … Read more
This question already has answers here: How to concatenate strings of a string field in a PostgreSQL ‘group by’ query? (14 answers) Closed 9 years ago. I’m having a table like this Movie Actor A 1 A 2 A 3 B 4 I want to get the name of a movie and all actors in … Read more
how can i query my sql server to only get the size of database? I used this : use “MY_DB” exec sp_spaceused I got this : database_name database_size unallocated space My_DB 17899.13 MB 5309.39 MB It returns me several column that i don’t need, maybe there is a trick to select database_size column from this … Read more
Seems like Money type is discouraged as described here My application needs to store currency, which datatype shall I be using? Numeric, Money or FLOAT? 6 Answers 6
I have a table create table us ( a number ); Now I have data like: a 1 2 3 4 null null null 8 9 Now I need a single query to count null and not null values in column a 26 Answers 26
Closed. This question needs details or clarity. It is not currently accepting answers. Want to improve this question? Add details and clarify the problem by editing this post. Closed 1 year ago. Improve this question I’m using a decimal column to store money values on a database, and today I was wondering what precision and … Read more
How do I run an update and select statements on the same queryset rather than having to do two queries: – one to select the object – and one to update the object The equivalent in SQL would be something like: update my_table set field_1 = ‘some value’ where pk_field = some_value 7 Answers 7
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 from the enumeration should be passed for user-defined table types? N’U’ like for user defined table doesn’t work, i.e. IF OBJECT_ID(N’MyType’, N’U’) IS NOT NULL 5 Answers 5
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 I didn’t get a clear answer. 16 Answers 16
I have two string columns a and b in a table foo. select a, b from foo returns values a and b. However, concatenation of a and b does not work. I tried : select a || b from foo and select a||’, ‘||b from foo Update from comments: both columns are type character(2). 8 … Read more
