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
118 reads
Identity (or AutoNumber) is a column that automatically generates numeric values. A start and increment value can be set, but...
2016-01-26
118 reads
In relational database design, the process of organizing data to minimize redundancy is called normalization. It usually involves dividing a...
2016-01-26
189 reads
An execution plan is basically a road map that graphically or textually shows the data retrieval methods chosen by the...
2015-12-28
814 reads
This question has two crinkle answers –· When the table is already created.
· When the table is to be created run...
2015-11-13
132 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
439 reads
Some time we need to know that who is using database as of now or who all are connected to...
2015-10-07
499 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
1,880 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
427 reads
By Steve Jones
I love Chicago. I went to visit three times in 2023: a Redgate event,...
By Brian Kelley
I have found that non-functional requirements (NFRs) can be hard to define for a...
You can find the slidedeck for my Techorama session “Microsoft Fabric for Dummies” on...
I've inherited a couple of rather large databases from my ex-colleague when I join...
Comments posted to this topic are about the item Identifying Customer Buying Pattern in...
Comments posted to this topic are about the item Finding Marks
I have marked a few transactions in my code. How can I find out which marks were stored in a transaction log?
See possible answers