Category Archives: SQL

ENTITY FRAMEWORK WITH SEQUENCE FOR INSERTS

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

Posted in SQL | Leave a comment

SQL Server 2008 – Not able to see my SQL instance in network

I have SQL 2008 Server Express installed on my machine But It was not discoverable in network and this was preventing me to access my sql server instance from another pc. After goggling I came to know this was because … Continue reading

Posted in SQL | Tagged | Leave a comment

Recently we came across one scenario in our project where we have to decide best option to store spreadsheet data in the database. we have finalized four options and out of those options one is to store the data in … Continue reading

Posted on by Suril Patel | Leave a comment

Pivoting in SQL

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

Posted in SQL | Leave a comment

Usefull new features of SQL 2008 for normal developers

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

Posted in SQL | Leave a comment

Saving changes is not permitted – A common error in SQL server management studio

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

Posted in SQL | Leave a comment

Blog for database related issues (from one of the experienced and practical techno guy)

Blog for database related issues (from one of the experienced and practical techno guy)

Continue reading

Posted in SQL | Leave a comment