INSERT INTO Table by selecting similar table with selected columns

Filed in SQL Leave a comment

INSERT INTO Item (ItemID, ItemName, ItemDescription, Manufacturer, Authentication_Info, NDC, DEA_Schedule, PedigreeItem, SaleDescription, ItemCost, ItemPrice, AWP, CF_Size)

SELECT ItemID, ItemName, ItemDescription, Manufacturer, Authentication_Info, NDC, DEA_Schedule, PedigreeItem, SaleDescription, ItemCost, ItemPrice, AWP, CF_Size from ParagonDB.dbo.TblItem

WHERE CatID IN(1,2,3,4,5,6,7,8,9,10,11,12) AND SubCatID IN(1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17) AND SVPG IS NULL

Excel formula for String manipulation

Filed in Uncategorized Leave a comment

For converting “CId = @CId” to CId = ISNULL(@CId, CId)” in excel below is the formula:

=CONCATENATE(MID(F2,1,(FIND(“@”,F2)-1)),” ISNULL(“,MID(F2,FIND(“@”,F2),LEN(F2)),”, “,MID(F2,FIND(“@”,F2)+1,LEN(F2)), “)”)

Could not load type 'System.ServiceModel.Activation.HttpModule' from assembly 'System.ServiceMode

Filed in .Net | ASP.Net Configuration Leave a comment

We have a dotnet web site which is built on framework 4.0 and is running over windows 2008 R2 server.

Today we added an application role to the server and defined framework 3.5 to be installed alongwith that. After doing this we suddenly started receiving the below error:

Could not load type ‘System.ServiceModel.Activation.HttpModule’ from assembly ‘System.ServiceMode…..

After doing some googling I found the solution which suggests that register the asp.net again with the appropriate version so I registered the asp.net (using aspnet_regiis -i command in the v4.0 folder of the dotnet framework) and that resolved my problem.

Found the solution at : 

Create New code templates in SQL Server

Filed in SQL Leave a comment

In Management Studio in Menu > Click View > Template Explorer > In this explorer you see different templates. Right click in the Template Explorer > New > Template. It create a new template file, name your template and then right click that template file and click edit. Now you make you new template and save it. That’s it!

Now whenever you click on this new template it create a new Query window with the same code which you write on the template.

Physically file are located on the below path:

C:\Program Files\Microsoft SQL Server\100\Tools\Binn\VSShell\Common7\IDE\SqlWorkbenchProjectItems\Sql

IIS 7.0 does not show 256-bit encryption in browser certificate information

Filed in IIS Configuration Leave a comment

Solution in below article

http://www.carbonwind.net/blog/post/A-quick-one-Setting-the-preferred-TLS-Cipher-Suite-on-TMG-Forefront-Beta-3-adding-a-little-bit-of-ephemerality.aspx

Some good information is also available on the below article too.

http://blogs.technet.com/b/edgeaccessblog/archive/2009/05/14/how-to-configure-iag-to-use-aes-256-encryption.aspx

gridview Row merging asp.net

Filed in .Net Leave a comment

Nice article at below link

http://csharpdotnetfreak.blogspot.com/2009/07/merge-gridview-cells-columns-aspnet.html

TOP