INSERT INTO Table by selecting similar table with selected columns

Filed in Uncategorized 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)), “)”)

Create New code templates in SQL Server

Filed in Uncategorized 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 Uncategorized 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 Uncategorized Leave a comment

Nice article at below link

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

TOP