STRING_AGG is not introduced in SQL SERVER 2016. It is introduced in SQL SERVER 2017. In the MSDN link you have provided it is mentioned THIS TOPIC APPLIES TO : SQL Server 2017 not SQL SERVER 2016. At the time of the question, this version was known by the code name “vNext”, described as: SQL … Read more
you want to use FROM E.g : select … FROM fn_GetConfigurationByProfile(‘DEFAULTPROFILE’) SQL Server User-defined Functions
source works for me. # — foo.sql DROP TABLE foo; source bar.sql # — bar.sql CREATE TABLE bar (i INT NOT NULL); $ mysql … < foo.sql Now table foo is gone and bar is created.
In your environments/production.rb config.log_level = :debug Remember you need to restart the web server to apply the changes.
The ANY and ALL operators allow you to perform a comparison between a single column value and a range of other values. For instance: select * from Table1 t1 where t1.Col1 < ANY(select value from Table2) ANY means that the condition will be satisfied if the operation is true for any of the values in … Read more
You can’t have a join in an update statement. It should be update articles set num_comments = (select count (*) from comments where comments.article_id = articles.id) This will update the entire articles table, which may not be what you want. If you intend to update only one article then add a ‘where’ clause after the … Read more
As documented under Data Type Default Values: If the column can take NULL as a value, the column is defined with an explicit DEFAULT NULL clause. (I think they meant implicit, not explicit). Moreover, as documented under CREATE TABLE Syntax: If neither NULL nor NOT NULL is specified, the column is treated as though NULL … Read more
DB2 is strongly typed, so you need to tell DB2 what kind of column your NULL is: select … cast(NULL as int) as column_A, cast(NULL as varchar(128)) as column_B, … FROM …
SELECT id, SUM(amount) AS amount FROM yourtable GROUP BY id
I published a nuget package (SqlBulkTools) to solve this problem. Here’s a code example that would achieve a bulk upsert. var bulk = new BulkOperations(); var books = GetBooks(); using (TransactionScope trans = new TransactionScope()) { using (SqlConnection conn = new SqlConnection(ConfigurationManager .ConnectionStrings[“SqlBulkToolsTest”].ConnectionString)) { bulk.Setup<Book>() .ForCollection(books) .WithTable(“Books”) .AddAllColumns() .BulkInsertOrUpdate() .MatchTargetOn(x => x.ISBN) .Commit(conn); } trans.Complete(); … Read more