Category Archives: SQL

In Oracle there is no support for Identity column which we have in SQL. You have to use Sequence to achieve the same functionality in Oracle. When we develop the MVC application with Entity Framework which is multi DB supported … Continue reading →

This post has good example of using PIVOT to get the row data in column format. http://beyondrelational.com/modules/2/blogs/88/Posts/14196/changing-rows-to-columns-using-pivot-dynamic-columns-for-pivoting-in-sql-server.aspx Here is example created by taking reference of this. create table #table(tid int,tname varchar(10)) create table #column(cid int,tid int,cname varchar(10)) create table #data(tid … Continue reading →

New Data Types DATE – ANSI-compliant date data type TIME – ANSI-compliant time data type with variable precision DATETIMEOFFSET – timezone aware/preserved datetime DATETIME2 – like DATETIME, but with variable precision and large date range GEOMETRY – “flat earth” spatial … Continue reading →

Many times i came across with the error “Saving changes is not permitted” which doesn’t allow you to save the changes we applied on tables.To change this option, on the Tools menu, click Options, expand Designers, and then click Table … Continue reading →