| HOME > RSS Feeds > Databases | ||
| Add To: | 
|
 |
database transaction is an important concept to understand for all those programmer and developer who wants to work in database be it Oracle, MySQL or SQL Server. to protect database consistency from ...
Access Database Getting Started Guide
For small systems, creating a database with Access is your best bet. An Access database is used to hold and retrieve large amounts of information. This could be as simple as keeping track of the DVD’s...
10 Example of SELECT queries in SQL
Select statement in SQL is used to retrieve data from database and sued to generate reports out of database. SELECT statement is very powerful and very versatile and there are many way one can use SEL...
Difference between truncate and delete command in SQL
If you are working in a huge table you need to be very very careful while executing any query because due to large data any query can run at very long duration or return very huge results which can po...
60 Most Creative and Attractive Business Cards Design
Business cards are cards bearing business information about a company or individual personnel. They are shared during formal introductions as a convenience and a memory aid. Normally a business card c...
Delete duplicate rows without primary key in ms sql server
Learn how to delete duplicate rows without any primary key in ms sql server database. This is the most common question asked in interview.
simple mysql function example
Tutorial on how to create a simple mysql function and result.
How to check if table exists or not in ms sql server database
In this programming tutorial we will learn how to check if table exists or not in ms sql server database. Doing so is quite easy in ms sql server. sp_help command is use for this purpose. So let's hav...
Query to get the all column names of a given table in ms sql server
In this programming tutorial you will learn the query to get the all column names of a given table in ms sql server. Its quite easy. Lets have a look over the query.
List all tables in a mysql database
In this programming tutorial we will learn how to list all tables in a mysql database. Sometimes you may want to get the table names of a mysql database; in that case the below mentioned show command ...