By:
On:
In: Article, Database, SQL, SQL Server
Tagged: , ,

Problem: A few days ago, while migrating data from one database to another, I encountered an interesting problem which user faced a lot. “I have two databases, I have to copy tables data from one database to another. My query is how can I copy table schema from one database to another with its schema and data” In this blog, we will learn the easiest solution on how you can solve that query. Solution There are plenty of methods on how you can copy table schema and data from one database to another like Generate script wizard, Import/Export Wizard etc. But these methods are quiteRead More →

Database_Scripts_With_Data_Select_Option

By:
On:
In: Article, Database, SQL, SQL Server
Tagged: , , ,

In this post we will discuss about how we can generate SQL Server scripts of our database with existing data, once we generate the script, the result will give you all the insert query with other queries so that the data also will get inserted in your new database. We are going to use the option ‘Schema and data’ in SQL server for this task. I hope the screen shots given will help you generate the script with insert queries. Background I was working with an article which has so many database transactions/actions. So I thought of attaching the database scripts with data also inRead More →

By:
On:
In: Article, Q&A, SQL, SQL Server
Tagged: , , , , ,

Introduction Hi All, How are you today? In this article we will see a solution for a fix that we usually encounter when you work in Microsoft SQL server. The error message will be “Saving changes is not permitted,The changes you have made require the following table to be dropped and re-created. You have either made changes to the table that can’t be re-created or enabled the option Prevent saving changes that require the table to be re-created.”. Let us see how we can solve this issue. I hope you will like it. Background As the error message says, it is because of you haveRead More →

By:
On:
In: Article, Q&A, SQL, SQL Server
Tagged: , , , ,

Introduction Hi All, I hope you are fine. We all are using SQL parameter in our application right?Yeah it is a good way to restrict the Injections are hijacks. But still if you pass those parameters in the right way, you will face lots of problems. In this article I am going to share you such an Issue. I hope you will like it. Background Morning I was working in a grid control which editable, and I selected a row to edit and started editing. In a date field I edited the date and clicked update button. I was expecting an output result as “SuccessfullyRead More →

By:
On:
In: Code Snippets, SQL, SQL Server
Tagged: , ,

This code helps you to find out the missing Indexes in SQL [sql] SELECT d.[object_id], s = OBJECT_SCHEMA_NAME(d.[object_id]), o = OBJECT_NAME(d.[object_id]), d.equality_columns, d.inequality_columns, d.included_columns, s.unique_compiles, s.user_seeks, s.last_user_seek, s.user_scans, s.last_user_scan INTO #missingindexes FROM sys.dm_db_missing_index_details AS d INNER JOIN sys.dm_db_missing_index_groups AS g ON d.index_handle = g.index_handle INNER JOIN sys.dm_db_missing_index_group_stats AS s ON g.index_group_handle = s.group_handle WHERE d.database_id = DB_ID() AND OBJECTPROPERTY(d.[object_id], ‘IsMsShipped’) = 0; select * from #missingindexes [/sql]Read More →