The purpose of this code is to create a T-SQL output that can be execute on SQL Server (2005 and higher) to recofigure the SQL server as compared to the settings on which you have executed this code from.
2010-10-14 (first published: 2010-10-05)
1,377 reads
A Flexible Day Of Week Function where a criteria can be passed as an integer to a stored procedure.
2010-10-13 (first published: 2010-10-06)
1,393 reads
This SP will monitor T-Log space and sends mail to DBA if log space usage is above threshold value
2010-10-05 (first published: 2010-10-03)
3,503 reads
2010-10-04 (first published: 2010-09-29)
2,922 reads
I came across a project which required a list of all columns within a server and thought I would post it here in case anyone else had this requirement.
2010-09-30 (first published: 2010-09-28)
1,569 reads
2010-09-29 (first published: 2010-09-28)
1,630 reads
I was asked to do so by one of my colleague. So, I thought to share it with you how to use multiple LIKE conditions.
2010-09-16 (first published: 2010-09-15)
3,786 reads
This script shows you code that retrives schema of a routine (Stored procedure or a function).
2010-09-09 (first published: 2010-09-04)
1,987 reads
2010-09-08 (first published: 2010-09-02)
2,366 reads
Do you need to take your mind off of the SQL mess you are dealing with? Try my funny words generator.
2010-09-03 (first published: 2010-08-27)
2,661 reads
If you've ever loaded a 2 GB CSV into pandas just to run a...
By James Serra
What problem is Fabric Ontology trying to solve? For years, most data conversations have...
By Steve Jones
Recently I ran across some code that used a lot of QUOTENAME() calls. A...
Comments posted to this topic are about the item Database Mail in SQL Server...
Comments posted to this topic are about the item Stairway to Reliable Database Deployment...
Comments posted to this topic are about the item QUOTENAME Quote Parameters
We create the following table and then insert some records in it:
create table t1 ( id int primary key, category char(1) not null, product varchar(50) ); insert into t1 values (1, 'A', 'Product 1'), (2, 'A', 'Product 2'), (3, 'A', 'Product 3'), (4, 'B', 'Product 4'), (5, 'B', 'Product 5');What happens if we execute the following query in both Sql Server and PostgreSQL?
select id,
category,
string_agg(product, ';')
over (partition by category order by id
rows between unbounded preceding and unbounded following) as stragg
from t1; See possible answers