Skip to main content

Posts

Showing posts from April, 2019

Oracle How to reset Sequence without dropping it

In this article, we will learn how to reset Sequence to a particular value without dropping it. Let's suppose the current value of the sequence e.g seq_person_id is 10234 and we want to reset it to 100. Step 1 alter sequence  seq_person_id increment by -10134 minvalue 0 Note : MINUS sign with 10134. Step 2 select  seq_person_id.nextval from dual Step 3 alter sequence  seq_person_id  increment by 1 minvalue 0; The sequence is now reset to 100. 

SQL Reporting Services Missing in Action in Visual Studio 2017

Microsoft RDLC Report Designer for Visual Studio To install these extensions: Launch Visual Studio 2017 -> Go to Tools Menu -> Select Extensions and Updates -> In the Extensions and Updates dialog box, select the Online option -> Click in the Search Visual Studio Marketplace dialog box, top right hand corner -> Type in Report -> Press return -> Select Microsoft Rdlc Report Design for Visual Studio -> Press the Download button -> Select Microsoft Reporting Services Project -> Press the Download button -> Press the Close button -> Close Visual Studio 2017 The extensions will install Open Visual Studio 2017 SQL Server Reporting Services will be installed ___Stay Happy_____________

No 'Access-Control-Allow-Origin' header is present on the requested resource.

//No 'Access-Control-Allow-Origin' header is present on the requested resource__ Access-Control-Allow-Origin error mostly when you access web api without client like from ajax or javascrip call Issue can be resolved in following steps. 1) Goto global aspx calss of WebApi 2) After default start method add below mentioned code in step 3 3) protected void Application_BeginRequest(object sender, EventArgs e) { HttpContext.Current.Response.AddHeader("Access-Control-Allow-Origin", "*"); if (HttpContext.Current.Request.HttpMethod == "OPTIONS") { HttpContext.Current.Response.AddHeader("Access-Control-Allow-Methods", "POST, PUT, DELETE"); HttpContext.Current.Response.AddHeader("Access-Control-Allow-Headers", "Content-Type, Accept"); HttpContext.Current.Response.AddHeader("Access-Control-Max-Age", "1728000&