Incorrect syntax near ”
Such unexpected problems can appear when you copy the code from a web page or email and the text contains unprintable characters like individual CR or LF and non-breaking spaces.
Database
How to delete from multiple tables in MySQL?
Use a JOIN in the DELETE statement. Alternatively you can use… …to delete only from pets_activities See this. For single table deletes, yet with referential integrity, there are other ways of doing with EXISTS, NOT EXISTS, IN, NOT IN and etc. But the one above where you specify from which tables to delete with an … Read more
SQL Server dynamic PIVOT query?
Dynamic SQL PIVOT: Results:
importing a CSV into phpmyadmin
In phpMyAdmin, click the table, and then click the Import tab at the top of the page. Browse and open the csv file. Leave the charset as-is. Uncheck partial import unless you have a HUGE dataset (or slow server). The format should already have selected “CSV” after selecting your file, if not then select it … Read more
PostgreSQL create table if not exists
This feature has been implemented in Postgres 9.1: For older versions, here is a function to work around it: Call: Notes The columns schemaname and tablename in pg_tables are case-sensitive. If you double-quote identifiers in the CREATE TABLE statement, you need to use the exact same spelling. If you don’t, you need to use lower-case strings. See: Are PostgreSQL column names case-sensitive? pg_tables only contains actual tables. The … Read more
Replacing NULL with 0 in a SQL server query
When you want to replace a possibly null column with something else, use IsNull. This will put a 0 in myColumn if it is null in the first place.
Errors: “INSERT EXEC statement cannot be nested.” and “Cannot use the ROLLBACK statement within an INSERT-EXEC statement.” How to solve this?
This is a common issue when attempting to ‘bubble’ up data from a chain of stored procedures. A restriction in SQL Server is you can only have one INSERT-EXEC active at a time. I recommend looking at How to Share Data Between Stored Procedures which is a very thorough article on patterns to work around … Read more
Is it possible to specify condition in Count()?
If you can’t just limit the query itself with a where clause, you can use the fact that the count aggregate only counts the non-null values: You can also use the sum aggregate in a similar way:
‘NOT LIKE’ in an SQL query
You have missed out the field name id in the second NOT LIKE. Try: The AND in the where clause joins 2 full condition expressions such as id NOT LIKE ‘1%’ and can’t be used to list multiple values that the id is ‘not like’.
Query to display all tablespaces in a database and datafiles
In oracle, generally speaking, there are number of facts that I will mention in following section: Each database can have many Schema/User (Logical division). Each database can have many tablespaces (Logical division). A schema is the set of objects (tables, indexes, views, etc) that belong to a user. In Oracle, a user can be considered … Read more