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
188 reads
An execution plan is basically a road map that graphically or textually shows the data retrieval methods chosen by the...
2015-12-28
808 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
494 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,863 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
425 reads
By Steve Jones
I was working with a customer and discussing how to do error handling. This...
By DataOnWheels
The 14th annual Ability Summit is a global event that I attended a few...
By Steve Jones
UPDATE: This moved to Apr 9 Join me Tuesday, Apr 9 for a webinar,...
Someone landed a PowerBI mess in my lap, and near as I can tell,...
I want to have a a secondary ready-only database available for reporting, which is...
How does the Resource database in SQL Server 2022 get backed up?
See possible answers