I had the same problem, I run two scripts then my problem is solved. Try this: In this query you can get user schema as a result for AdventureWorks database: USE AdventureWorks; SELECT s.name FROM sys.schemas s WHERE s.principal_id = USER_ID(‘your username’); after take schema name you can alter authorization on schema like this: ALTER … Read more
“The “X” property on “Y” could not be set to a ‘null’ value. You must set this property to a non-null value of type ‘Int32’.” In your EDMX, if you go under your Y table and click on X column, right-click, click on Properties, scroll down to Nullable and change from False to True. If … Read more
If your 200+ packages work as intended with “old fashioned” syntax, let it be. SQL will not start to perform better after migration to ANSI syntax – it’s just different syntax. All that being said, ANSI syntax is cleaner – you are not going to normal join if you forget (+) in some multi-column outer … Read more
This is what I did to format SQL queries: Install the SQLTools extension Open your query Press Ctrl+Shift+P Select “Format Document With” Select SQLTools
As a rule of thumb, indexes should be on any fields that you use in joins or where clauses (if they have enough different values to make using an index worthwhile, field with only a few possible values doesn’t benefit from an index which is why it is pointless to try to index a bit … Read more
This should get you started: Dim db As DAO.Database Dim qdf As DAO.QueryDef Set db = CurrentDB() For Each qdf In db.QueryDefs Debug.Print qdf.SQL Next qdf Set qdf = Nothing Set db = Nothing You can use the File System Object or the built-in VBA File I/O features to write the SQL out to a … Read more
put GO after PRINT ‘Creating Player View’ and it should work: PRINT ‘Creating Player View’ GO CREATE VIEW playerView AS
Use the COALESCE function to replace NULL values with an empty string. SELECT Column1 + COALESCE(Column2, ”) AS Result FROM YourTable
SELECT post.id, post.title, comment.id, comment.message FROM post OUTER APPLY ( SELECT TOP 1 * FROM comment с WHERE c.post_id = post.id ORDER BY date DESC ) comment or SELECT * FROM ( SELECT post.id, post.title, comment.id, comment.message, ROW_NUMBER() OVER (PARTITION BY post.id ORDER BY comment.date DESC) AS rn FROM post LEFT JOIN comment ON comment.post_id … Read more
You simply can’t do that in SQL. You have to explicitly list the fields and concat each one: SELECT CONCAT(field1, “https://stackoverflow.com/”), CONCAT(field2, “https://stackoverflow.com/”), … FROM `socials` WHERE 1 If you are using an app, you can use SQL to read the column names, and then use your app to construct a query like above. See … Read more