Database | Blogger India

Archive | database

RSS feed for this section

Graph Based Database

Posted on 29 October 2009 | Visited 1201 times, 3 so far today

Neo Technology Commercializes Next Generation Graph Based Database

Share on Facebook

Posted in databaseComments (0)

Tags: SQL

ISO Country List with Abbreviations (SQL Table)

Posted on 05 October 2009 | Visited 1479 times, 6 so far today

This script will create and then populate a SQL table with a list of the names and ISO 3166 codes for countries in existence.

Share on Facebook

Posted in databaseComments (0)

We are familiar with formatting dates inside SQL Server. The common approach is:
convert (varchar, getdate(), 103)
Here’s a summary of the different date formats that come standard in SQL Server as part of the CONVERT function.
Share on Facebook

Share on Facebook

Posted in databaseComments (0)

Find and Delete Duplicates value from SQL table

Posted on 16 September 2009 | Visited 1294 times, 3 so far today

Here a query for finding duplicates in a table. Suppose you want to find all ‘Coupon Code’ in a table that exist more than once
Share on Facebook

Share on Facebook

Posted in databaseComments (0)

Tags: database, SQL 2008

SQL Server 2008 Management Studio – Saving changes is not permitted error.

Posted on 12 August 2009 | Visited 978 times, 2 so far today

Saving Changes in not permitted. The changes you have made require the following tables to be dropped and re-created. You have either made changes to a table that can’t be re-created or enabled the option Prevent saving changes that require the table to be re-created
Share on Facebook

Share on Facebook