Programming Tips

SQL Server - Get dates between two dates

2015-02-19T05:18:00.003-08:00

DECLARE @MinDate DATE = '2014-01-01',

@MaxDate DATE = '2014-02-06';

SELECT TOP (DATEDIFF(DAY, @MinDate, @MaxDate) + 1)

Date = DATEADD(DAY, ROW_NUMBER() OVER(ORDER BY a.object_id) - 1, @MinDate)

FROM sys.all_objects a

CROSS JOIN sys.all_objects b;

Sql Server Find Percentage Calculation Function

2015-02-18T20:12:00.000-08:00

CREATE FUNCTION [dbo].[Percentage]

(

@Percentage DECIMAL(4,2) ,

@ColumnNameValue DECIMAL(7,2)

)

RETURNS DECIMAL(7,2)

BEGIN

DECLARE

@Output DECIMAL(7,2)

SET @Output = (@Percentage/100)*@ColumnNameValue

RETURN @Output

END

select Percentage(10,1000)

output : 100

Kalman Filter Matlab Code

2015-02-18T09:08:00.002-08:00

clc

clear all

close all

warning off

error = 2;

Xnp = [1 2 3 4];

Zn = [1.1 1.9 3 4];

si = length(Xnp);

A = zeros(si,si);

P = zeros(si,si);

Q = zeros(si,si);

H = zeros(si,si);

R = zeros(si,si)*error;

I = zeros(si,si);

for i = 1:si

A(i,i) = 1;

P(i,i) = 1;

H(i,i) = 1;

R(i,i) = 1;

I(i,i) = 1;

end

Xn = Xnp*A;

Pn = (A*P*A')+Q;

prevXn = [];

while(true)

Kk = (Pn*H')*(((H*Pn*H')+R)');

Xn = Xn+((Zn-(Xn*H))*Kk);

Pn = (I-(Kk*H))*Pn;

if(isempty(prevXn))

prevXn = Xn;

else

con = sum(abs(Xn-prevXn));

if(con==0)

break;

end

FXn = Xn

How to Shrink Your MSSQL Database Log File / Truncate Transaction Log

2015-02-12T09:41:00.001-08:00

Log into Microsoft SQL Server Management Studio
Right click on your database.
Select Properties.
Click on Options.
Change the recovery model to Simple.
Click OK.
Right click on the database.
Select Tasks > Shrink > Database.
Click OK.
Right click on the database.
Select Properties.
Click on Options.
Change the recovery model to Full.
Click OK.

Retrieve List out Clustered Index or Non Clustered Index on Tables for Entire Database

2015-02-12T09:39:00.001-08:00

SELECT COUNT(i.TYPE) NoOfIndex,

[schema_name] = s.name, table_name = o.name

FROM sys.indexes i

INNER JOIN sys.objects o ON i.[object_id] = o.[object_id]

INNER JOIN sys.schemas s ON o.[schema_id] = s.[schema_id]

WHERE o.TYPE IN ('U')

--AND i.TYPE = 1

AND i.TYPE = 2

GROUP BY s.name, o.name

ORDER BY schema_name, table_name

--select * from sys.indexes

select * from sys.objects

How to Find Number of Primarykey and Foreignkey columns in Tables

2015-02-12T09:38:00.000-08:00

-- No Foreign key Tables

SELECT * FROM INFORMATION_SCHEMA.TABLES

WHERE TABLE_NAME NOT IN

(

SELECT OBJECT_NAME(f.parent_object_id) AS TableName

FROM sys.foreign_keys AS f

INNER JOIN sys.foreign_key_columns AS fc

ON f.OBJECT_ID = fc.constraint_object_id

)

AND TABLE_TYPE = 'BASE TABLE'

ORDER BY TABLE_NAME;

--select * from sys.foreign_keys

--select * from sys.foreign_key_columns

select * from sys.objects

-- No primary key Tables

SELECT SCHEMA_NAME(schema_id) AS SchemaName,name AS TableName

FROM sys.tables

WHERE OBJECTPROPERTY(OBJECT_ID,'TableHasPrimaryKey') = 0

ORDER BY SchemaName, TableName;

SELECT SCHEMA_NAME(schema_id) AS SchemaName,name AS TableName

FROM sys.tables

WHERE OBJECTPROPERTY(OBJECT_ID,'TableHasForeignRef') = 0

ORDER BY SchemaName, TableName;

How to Find List of Primary Keys and Foreign Keys in Database in Sql Server

2015-02-12T09:26:00.000-08:00

SELECT

DISTINCT

Constraint_Name AS [Constraint],

Table_Schema AS [Schema],

Table_Name AS [TableName]

FROM INFORMATION_SCHEMA.KEY_COLUMN_USAGE

SELECT OBJECT_NAME(OBJECT_ID) AS NameofConstraint,

SCHEMA_NAME(schema_id) AS SchemaName,

OBJECT_NAME(parent_object_id) AS TableName,

type_desc AS ConstraintType

FROM sys.objects

WHERE type_desc IN ('FOREIGN_KEY_CONSTRAINT','PRIMARY_KEY_CONSTRAINT')

How Column reference in all Tables in Sql Server

2015-02-12T09:22:00.003-08:00



SELECT obj.Name SPName, sc.TEXT SPText

FROM sys.syscomments sc

INNER JOIN sys.objects obj ON sc.Id = obj.OBJECT_ID

WHERE sc.TEXT LIKE '%' + 'Email' + '%'

AND TYPE = 'P'

Related Searches : Query for Table Column reference in all Tables in Sql Server .

How to Find Column reference in all Procedures in Sql Server

2015-02-12T09:16:00.002-08:00



SELECT obj.Name SPName, sc.TEXT SPText

FROM sys.syscomments sc

INNER JOIN sys.objects obj ON sc.Id = obj.OBJECT_ID

WHERE sc.TEXT LIKE '%' + 'CreatedBy' + '%'

AND TYPE = 'P'

Related Searches : Find the column reference in stored procedure Sql server.

How to insert bulk data in Oracle

2015-02-12T09:11:00.000-08:00

Just use @ symbol and path of the sql.




@"C:\database\importData.sql"

Related Searches : Oracle bulk data insert out of memory error,Import sql out of memory error solve,bulk data insert in Oracle.

How to Create a Procedure with Single Column Output

2015-02-12T09:04:00.000-08:00


create or replace PROCEDURE CaseWhenExample(dtType in number,outputResult OUT SYS_REFCURSOR) is

BEGIN

OPEN outputResult FOR

select Name from student

END;

Related Searches : Oracle single column cursor result in Stored Procedure, Make Stored Procedure for single column output.

How to call Procedure in Oracle

2015-02-12T08:56:00.002-08:00


var c refcursor;

execute pkg_name.get_user('14232', '15', 'TDWL', 'SA', 1, :c);

print c;

Related Searches : Oracle Procedure call using command , Stored procedure call using cursor in Oracle.

Oracle if table not exist create or Delete

2015-02-12T08:46:00.001-08:00


declare

   c int;

begin

   select count(*) into c from user_tables where table_name = upper('table1');

   if c = 1 then

      execute immediate 'drop table table1';

   end if;

   execute immediate 'CREATE table table1 (pkey NUMBER)';

end;

Automatic Segmentation of the Pulmonary Lobes From Chest CT Scans Based on Fissures, Vessels, and Bronchi Matlab Code

2013-11-08T02:30:00.001-08:00

Abstract

Segmentation of the pulmonary lobes is relevant in clinical practice and particularly challenging for cases with severe diseases or incomplete fissures. In thiswork, an automated segmentation approach is presented that performs a marker-based watershed transformation on computed tomography (CT) scans to subdivide the lungs into lobes. A cost image for the watershed transformation is computed by combining information from fissures, bronchi, and pulmonary vessels. The lobar markers are calculated by an analysis of the automatically labeled bronchial tree. By integration of information from several anatomical structures the segmentation is made robust against incomplete fissures. For evaluation the method was compared to a recently published method on 20 CT scans with no or mild disease. The average distances to the reference segmentation were 0.69, 0.67, and 1.21 mm for the left major, right major, and right minor fissure, respectively. In addition the results were submitted to LOLA11, an international lung lobe segmentation challenge with publically available data including cases with severe diseases. The average distances to the reference for the 55 CT scans provided by LOLA11 were 0.98, 3.97, and 3.09 mm for the left major, right major, and right minor fissure.

Moreover, an analysis of the relation between segmentation quality and fissure completeness showed that the method is robust against incomplete fissures.

Demo

Code Price : 2500 Rs /-

Matlab code is Available..

Contact : ieeematlabcode@gmail.com

Computerized Detection of Lung Nodules by Means of Virtual Dual-Energy Radiography Matlab Code

2013-11-08T01:43:00.004-08:00

Abstract

Major challenges in current computer-aided detection (CADe) schemes for nodule detection in chest radiographs (CXRs) are to detect nodules that overlap with ribs and/or clavicles and to reduce the frequent false positives (FPs) caused by ribs. Detection of such nodules by a CADe scheme is very important, because radiologists are likely to miss such subtle nodules. Our purpose in this study was to develop a CADe scheme with improved sensitivity and specificity by use of “virtual dualenergy” (VDE) CXRs where ribs and clavicles are suppressed with massive-training artificial neural networks (MTANNs). To reduce rib-induced FPs and detect nodules overlapping with ribs, we incorporated the VDE technology in our CADe scheme. The VDE technology suppressed rib and clavicle opacities in CXRs while maintaining soft-tissue opacity by use of the MTANN technique that had been trained with real dual-energy imaging. Our scheme

detected nodule candidates on VDE images by use of a morphologic filtering technique. Sixty morphologic and gray-level-based features were extracted from each candidate from both original and VDE CXRs. A nonlinear support vector classifier was employed for classification of the nodule candidates. A publicly available database containing 140 nodules in 140 CXRs and 93 normal CXRs was used for testing our CADe scheme. All nodules were confirmed by computed tomography examinations, and the average size of the nodules was 17.8 mm. Thirty percent (42/140) of the nodules were rated “extremely subtle” or “very subtle” by a radiologist. The original scheme without VDE technology achieved a sensitivity of 78.6% (110/140) with 5 (1165/233) FPs per image. By use of the VDE technology, more nodules overlapping with ribs or clavicles were detected and the sensitivity was improved substantially to 85.0% (119/140) at the same FP rate in a leaveone- out cross-validation test, whereas the FP rate was reduced to 2.5 (583/233) per image at the same sensitivity level as the original CADe scheme obtained (Difference between the specificities of the original and the VDE-based CADe schemes was statistically significant). In particular, the sensitivity of our VDE-based CADe scheme for subtle nodules (66.7% = 28/42) was statistically significantly

higher than that of the original CADe scheme (57.1% = 24/42). Therefore, by use of VDE technology, the sensitivity and specificity of our CADe scheme for detection of nodules, especially subtle nodules, in CXRs were improved substantially.

Demo

Code Price : 3000 Rs /-

Matlab code is Available..

Contact : ieeematlabcode@gmail.com

Splat Feature Classification With Application to Retinal Hemorrhage Detection in Fundus Images Matlab Code

2013-11-08T01:00:00.000-08:00

Abstract

A novel splat feature classification method is presented with application to retinal hemorrhage detection in fundus images. Reliable detection of retinal hemorrhages is important in the development of automated screening systems which can be translated into practice. Under our supervised approach, retinal color images are partitioned into nonoverlapping segments covering the entire image. Each segment, i.e., splat, contains pixels with similar color and spatial location. A set of features is extracted from each splat to describe its characteristics relative to its surroundings, employing responses from a variety of filter bank, interactions with neighboring splats, and shape and texture information. An optimal subset of splat features is selected by a filter approach followed by a wrapper approach. A classifier is trained with splat-based expert annotations and evaluated on the publicly available Messidor dataset. An area under the receiver operating characteristic curve of 0.96 is achieved at the splat level and 0.87 at the image level. While we are focused on retinal hemorrhage detection, our approach has potential to be applied to other object detection tasks.

Demo

Code Price : 2500 Rs /-

Matlab code is Available..

Contact : ieeematlabcode@gmail.com

Install sv journal template on your Word

2013-08-16T00:35:00.000-07:00

1. Download Sv-journ template from ftp://ftp.springer.de/pub/Word/journals

2. Extract the zip on your local directory.

3. Double click and open sv-journ.dot open in Word 2010.

4. Check out the Add-Ins tab.then all items are shown.

5. Then create your document and save it.

Latent Semantic Indexing Matlab Code

2013-08-07T23:58:00.000-07:00

In below we give the code of lsi on matlab.


function sim = lsi_calc(A,q,k)

[m,n] = size(A);

[U,S,V] = svds(A,k);

qc = q'*U*inv(S);

for i = 1:n % Loop over all documents

    sim(i) = (qc * V(i,:)') / (norm(qc) * norm(V(i,:)));

end;

MATLAB code for read image from webcam

2013-08-07T00:23:00.001-07:00

In below code to read image from web cam then write the image on your local directory.


vid = videoinput('winvideo',1);

testpic = getsnapshot(vid);

imwrite(testpic,'image1.jpg');

imshow(testpic);

Face Detection Matlab Code

2013-08-02T00:23:00.000-07:00

Following code used to detect the face.

faceDetection.m


function detectfce = faceDetection(I)



faceDetector = vision.CascadeObjectDetector;  



% Read input image



% Detect faces

bbox = step(faceDetector, I);



% Create a shape inserter object to draw bounding boxes around detections

shapeInserter = vision.ShapeInserter('BorderColor','Custom','CustomBorderColor',[255 255 0]);



% Draw boxes around detected faces and display results             

snapshot0 = step(shapeInserter, I, int32(bbox));   



detectfce = I(bbox(2):bbox(2)+bbox(3),bbox(1):bbox(1)+bbox(4),:,:,:);

Main.m


[filename, pathname] = uigetfile({'*.jpg;*.tif;*.png;*.pgm','All Image Files';...

          '*.*','All Files' },'mytitle');

file = [pathname filename];





FileNames = file;

rgbImage = imread(FileNames);

detectfce = faceDetection(rgbImage );

figure;imshow(detectfce );

Neural Network with hidden Layers Example on Matlab | Matlab Neural Network with 2 hidden Layers

2013-08-02T00:14:00.001-07:00

Neural network is one of the artificial intelligence technique,it solve problems in more areas ,like as patter recognition,clustering ,fitting and ect.

Neural network Steps as follow

1.Create the network

2.Train the network

1.Create the network

1st thing we design a network for our inputs for ex we have 2 input and 1 output.

ex:-
>>input = [2 2;4 5;6 7; 7 8; 9 10];
>>output = [1;1;2;2;2];

we create neural network with default hidden layer as follow.

>>net = newff(input,output);

if we want design with users hidden layers then we design as follow.

>>net = newff(input,output,[3 4]);

here [3 4] are two hidden layer. Each layer has each neurons.ex 1st hidden layer has 3 neurons and 2nd one 4 neurons.

2.Train Network

Its train our input data on neural network.

ex:

>>net = train(net,input,output);

Change date format from dd-mm-yyyy to yyyy-mm-dd in java

2013-07-29T21:53:00.001-07:00


import java.util.Collections;

import java.util.Vector;



/**

 *

 * @author RajBharath

 */

public class nCrCombination{



    /**

     * @param args the command line arguments

     */

    public static void main(String[] args) {

        // TODO code application logic here

       

        int count = 5;

        Vector prev = new Vector();

        Vector my_list = new Vector();

        for(int tot_item = 0;tot_item<=count;tot_item++)

        {

            prev.add(tot_item);

            my_list.add(tot_item);

        }

        Vector prev1 = new Vector();

        for(int tot_item = 0;tot_item<=count;tot_item++)

        {

                //System.out.println("Size = "+prev.size());

                for(int k = 0;k<prev.size();k++)

                {

                    String tmp = prev.get(k).toString();



                    String tmp_val[] = tmp.split(",");

                    int start = (int)Double.parseDouble(tmp_val[tmp_val.length-1]);

                    for(int item = start+1;item<=count;item++)

                    {

                        prev1.add(tmp+","+item);

                        my_list.add(tmp+","+item);

                        System.out.println(tmp+","+item);

                    }

                }   

               

                prev.clear();

                //System.out.println("Size = "+prev1.size());

                prev.addAll(0,prev1);

                //prev = prev1;

                prev1.clear();

        }

        System.out.println("Tot size = "+my_list.size());

           

    }

   

}

Get all Possible nCr Combinations in Java

2013-07-29T21:50:00.002-07:00

In below code to give the results of 1 2 3 4 5. 11 12 13 14 15 nCr combination values.


import java.util.Collections;

import java.util.Vector;



/**

 *

 * @author RajBharath

 */

public class nCrCombination{



    /**

     * @param args the command line arguments

     */

    public static void main(String[] args) {

        // TODO code application logic here

       

        int count = 5;

        Vector prev = new Vector();

        Vector my_list = new Vector();

        for(int tot_item = 0;tot_item<=count;tot_item++)

        {

            prev.add(tot_item);

            my_list.add(tot_item);

        }

        Vector prev1 = new Vector();

        for(int tot_item = 0;tot_item<=count;tot_item++)

        {

                //System.out.println("Size = "+prev.size());

                for(int k = 0;k<prev.size();k++)

                {

                    String tmp = prev.get(k).toString();



                    String tmp_val[] = tmp.split(",");

                    int start = (int)Double.parseDouble(tmp_val[tmp_val.length-1]);

                    for(int item = start+1;item<=count;item++)

                    {

                        prev1.add(tmp+","+item);

                        my_list.add(tmp+","+item);

                        System.out.println(tmp+","+item);

                    }

                }   

               

                prev.clear();

                //System.out.println("Size = "+prev1.size());

                prev.addAll(0,prev1);

                //prev = prev1;

                prev1.clear();

        }

        System.out.println("Tot size = "+my_list.size());

           

    }

   

}

Calling Matlab function from Java

2013-07-29T21:46:00.001-07:00

Download matlabcontrol-4.1.0.jar library from https://code.google.com/p/matlabcontrol/

then try below code


import matlabcontrol.*;

import matlabcontrol.MatlabProxyFactory;

import matlabcontrol.MatlabProxyFactoryOptions;



/**

 *

 * @author RajBharath

 */

public class MatlabCommunication{



    /**

     * @param args the command line arguments

     */

    public static void main(String[] args)  throws Exception

    {

         // create proxy

        MatlabProxyFactoryOptions options = new MatlabProxyFactoryOptions.Builder()

             .setUsePreviouslyControlledSession(true)

             .build();

        MatlabProxyFactory factory = new MatlabProxyFactory(options);

        MatlabProxy proxy = factory.getProxy();



        proxy.eval("disp('hello world')");



        // call user-defined function (must be on the path)

       



        // close connection

        proxy.disconnect();



    }



}

Java Code for Resource Allocation

2013-07-29T21:42:00.000-07:00

Here we give the sample for resource allocation to processor.Its process based on resource execution time.


import java.io.*;

import java.util.Random;

/**

 *

 * @author RajBharath

 */

public class ResourceAllocation

{

     int job[]=null,process[]=null;

     int pointer=0;

    ResourceAllocation()

    {

        String str="";

        int n,n1,i;

      

        Random randomGenerator = new Random();

      

        //--------------Resource Allocation

      

        BufferedReader buffer = new BufferedReader(new InputStreamReader(System.in));

        System.out.println("Enter the number of Resource : ");

        try

        {

            str = buffer.readLine();

        }

        catch(Exception e){}

        

        n = Integer.parseInt(str);

        job = new int[n];

        System.out.println("Each Resource Execution Time Randomly generated");

        System.out.println("-----------------------");

        for(i = 0;i<n;i++)

        {

            int randomInt = 1 + randomGenerator.nextInt(10);

            job[i] = randomInt;

            System.out.println(" Job - "+(i+1)+" : "+randomInt);

        }

      

        //--------------Processor Allocation

      

        System.out.println("Enter the number of processor : ");

        try

        {

        str = buffer.readLine();

        }

        catch(Exception e)

        {       

        }

        n1 = Integer.parseInt(str); 

        //--------------Tread Allocation

        

        for (i=0;i<n1;i++)

        {

            try

            {

                ThreadClass thread1 = new ThreadClass(job[pointer],n,n1,i);

                thread1.start();

                pointer++;

            }

           catch(Exception e)

            {

            }

        }

    }

  

    class ThreadClass extends Thread

    {

        String message;

        int n,n1,job1,i;

        //int pointer;

        ThreadClass(int job,int n,int n1,int i)

        {

                this.job1=job;

                //this.pointer=pointer;

                this.n=n-1;

                this.n1=n1-1;

                this.i=i;

        }

        public void run()

        {

            while(true)

            {

               try

                {

                     sleep(job1);

                     if (pointer>=n1)

                     {

                         System.out.println("processor="+ i +"--> job="+job1);

                         if (pointer>n)

                         {

                             break;

                         }

                         else

                         {

                         try

                         {

                             pointer++;

                             job1 = job[pointer];

                             this.start();

                            

                         }

                         catch(Exception e){}   

                         }

                    }

                }

                catch(Exception e)

                {

                    System.out.print("Thread Error");

                } 

             }

        }

    }

    public static void main(String arg[]) throws Exception

    {

       new ResourceAllocation();

    }



}