The expression stringexpression = ” yields: TRUE .. for ” (or for any string consisting of only spaces with the data type char(n)) NULL .. for NULL FALSE .. for anything else So to check for: “stringexpression is either NULL or empty”: (stringexpression = ”) IS NOT FALSE Or the reverse approach (may … Read more
Why is it that you need to place columns you create yourself (for example “select 1 as number”) after HAVING and not WHERE in MySQL? WHERE is applied before GROUP BY, HAVING is applied after (and can filter on aggregates). In general, you can reference aliases in neither of these clauses, but MySQL allows referencing … Read more
See populate a database in the PostgreSQL manual, depesz’s excellent-as-usual article on the topic, and this SO question. (Note that this answer is about bulk-loading data into an existing DB or to create a new one. If you’re interested DB restore performance with pg_restore or psql execution of pg_dump output, much of this doesn’t apply … Read more
You should supply the SqlParameter instances in the following way: context.Database.SqlQuery<myEntityType>( “mySpName @param1, @param2, @param3”, new SqlParameter(“param1”, param1), new SqlParameter(“param2”, param2), new SqlParameter(“param3”, param3) );
That’s unnecessary. Just use SELECT CONVERT(column USING utf8) FROM….. instead of just SELECT column FROM…
You can not update identity column. SQL Server does not allow to update the identity column unlike what you can do with other columns with an update statement. Although there are some alternatives to achieve a similar kind of requirement. When Identity column value needs to be updated for new records Use DBCC CHECKIDENT which … Read more
Not sure if there is an easier way in 2008 version. USE [Database Name] SELECT COLUMN_NAME,* FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = ‘YourTableName’ AND TABLE_SCHEMA=’YourSchemaName’
You will only see the difference if you have ties within a partition for a particular ordering value. RANK and DENSE_RANK are deterministic in this case, all rows with the same value for both the ordering and partitioning columns will end up with an equal result, whereas ROW_NUMBER will arbitrarily (non deterministically) assign an incrementing … Read more
I believe this error is caused because the local server and live server are running different versions of MySQL. To solve this: Open the sql file in your text editor Find and replace all utf8mb4_unicode_520_ci with utf8mb4_unicode_ci Save and upload to a fresh mySql db Hope that helps
From the command prompt, start up sqlcmd: sqlcmd -S <server> -i C:\<your file here>.sql Just replace <server> with the location of your SQL box and <your file here> with the name of your script. Don’t forget, if you’re using a SQL instance the syntax is: sqlcmd -S <server>\instance. Here is the list of all arguments … Read more