Automating CRUD procedures generation using T-SQL (enhanced).
In this post I will describe the helper procedure that based on metadata generates numerous database objects around views and...
2019-01-03
381 reads
In this post I will describe the helper procedure that based on metadata generates numerous database objects around views and...
2019-01-03
381 reads
In this article I continue to explore the ways to secure the data via contextual views and describe the technique...
2018-10-18
519 reads
In this post we will discuss how to fetch data from a large dataset for web applications using pagination technique....
2018-10-17
405 reads
This post helps in deciding between choosing foreign key and check constraints in case we need to constraint the data...
2018-10-16
444 reads
We are often required to pass the data between different database procedures and functions. In this post I will review...
2018-09-06
315 reads
In this post I will show how in some cases we can split a long procedure to a small and...
2018-05-23
1,763 reads
In this post you will find two small functions that convert binary value to a decimal one and vice versa.
2018-05-19
414 reads
Deployment process equally responsible for deploying both database objects as well as an initial state of the database/applications. In this...
2018-05-10
612 reads
I try to avoid dynamic SQL as much as possible and consider it as a necessary evil. However, in some...
2018-05-21 (first published: 2018-05-09)
2,501 reads
Designing implementation of interface is as critical as designing interface itself. In this post we will discuss some advice on...
2018-04-14
1,294 reads
By Daniel Janik
The circle cylinder of life Maybe you’ve noticed all the twenty somethings tight rolling...
By Chris Yates
In today’s data-driven economy, organizations are no longer asking if they should invest in...
By Rohit Garg
PostgreSQL, often referred to as Postgres, is a powerful, open-source object-relational database system that...
Comments posted to this topic are about the item How a Legacy Logic Choked...
Comments posted to this topic are about the item Databases and Disasters
Comments posted to this topic are about the item Automating SQL Server Access Review
I have this table in SQL Server 2022:
CREATE TABLE CustomerLarge (CustomerID INT NOT NULL IDENTITY(1, 1) CONSTRAINT CustomerLargePK PRIMARY KEY CLUSTERED , CustomerName VARCHAR(20) , CustomerContactFirstName VARCHAR(40) , CustomerContactLastName VARCHAR(40) , Address VARCHAR(20) , Address2 VARCHAR(20) , City VARCHAR(20) , CountryCode CHAR(3) , Postal VARCHAR(20) ) GOIf I check the columns_updated() function return in a trigger, what is the data returned? See possible answers