What is an Identity?
Identity (or AutoNumber) is a column that automatically generates numeric values. A start and increment value can be set, but...
2016-01-26
129 reads
Identity (or AutoNumber) is a column that automatically generates numeric values. A start and increment value can be set, but...
2016-01-26
129 reads
In relational database design, the process of organizing data to minimize redundancy is called normalization. It usually involves dividing a...
2016-01-26
200 reads
An execution plan is basically a road map that graphically or textually shows the data retrieval methods chosen by the...
2015-12-28
858 reads
This question has two crinkle answers –· When the table is already created.
· When the table is to be created run...
2015-11-13
139 reads
How we can convert Comma Separated Value to Rows and Vice Versa?
Basic fundamental
While we are working on reporting some circumstances...
2015-10-08
449 reads
Some time we need to know that who is using database as of now or who all are connected to...
2015-10-07
569 reads
Table values parameters
How we can pass multiple rows in stored procedure or function as a parameter?
Table-valued parameters are a new...
2015-10-06
2,001 reads
Utility link for excel import to SQL
Save Excel Data into Databases
http://www.savetodb.com/Connect to databases, edit data, and save changes back. Edit data...
2015-09-30
442 reads
By Steve Jones
I had an idea for an animated view of a sales tool, and started...
Next Monday, February 9, 2026, my one-day live online training SQL Server Query Tuning...
By Steve Jones
One of the features we advocates have been advocating for is a better way...
Comments posted to this topic are about the item Level 28: DAX Text Functions:...
Comments posted to this topic are about the item Creating JSON I
Comments posted to this topic are about the item Expensive CPUs
On SQL Server 2025, what happens when I run this code:
SELECT JSON_OBJECTAGG( 'City':'Denver') GOSee possible answers