Sql Script Generator

During project development you might have come across a situation where you need Insert script along with values from SQL Table.

 Found a very useful tool SQL Script Generator at CodePlex. 

 SQL Script Generator is a tool for generate INSERT/UPDATE statement SQL script. With SQL Script Generator you can create script to copy data from one database to another.

Comments

Post a Comment

Popular posts from this blog

Yellow Background issue in Word to PDF conversion

Image
For those who are use to save Word file as PDF might have faced the issue of Yellow background in PDF file post saving (see screenshot)  Below are the simple steps to resolve this issue. You can set a background color for a Word document, but it is only visible in  Web Layout . The background will appear white in  Print Layout . Use the  View  tab's  Document Views  group,  Web Layout  command to see it one has been set. If it has, it can be removed from the  Page Layout  tab's  Page Background ,  Page Color  options. Normally, the colored page background would not print. However, there is a Word Option to  Print background colors and images . Click the  Office button, Word options, Display  and look in the bottom section,  Printing Options  for  Print background colors and images  and unchecked it. Hope this help.
Read more

WCF WSDL location address Issue resolved when hosted over HTTPS with basicHTTPBinding

Image
Recently I was working on a WCF web service which needs SSL implementation using basicHttpBinding, so that the service remains inter-operable and cater to native clients. Everything was going well, I was able to host my web service over HTTPS (I will detail out the configuration for the same in section below). But when I deployed on Server, following errors were received when proxy is generated: " Metadata contains a reference that cannot be resolved: " " The WSDL document contains links that could not be resolved." The issue lies with the WSDL which generates the location url with client machine name, which restricts generation of appropriate proxy over Internet because it will never be able to resolve machine name over internet. Here is what the Soap Address location and WSDL Import location look like in my WSDL: < soap:address location ="https://MachineName.mydomain.com/MyService/Service.svc" /> < wsdl:import   locati...
Read more

Display Percentage Values on a Pie Chart (Report Builder and SSRS)

By default, categories are shown in the legend to identify each value. If you have labeled the pie chart using category labels, you may want show percentages in the legend. To display percentage values as labels on a pie chart Type  #PERCENT  for the  Label data  option. (Optional) To specify how many decimal places the label shows, type "#PERCENT{P n }" where  n  is the number of decimal places to display. For example, to display no decimal places, type "#PERCENT{P0}". Click here  for Microsoft Technet Article for more details.
Read more