Good tip.......

Found another good reason to avoid using IN clause in your TSQL Queries. See the example below:

 
.userprofile  
{
    color: #36c;
    font-size: 12px; 
	font-weight: bold; 
    text-decoration: none;
}

.userprofile A:VISITED
{
    color: #039;
    font-size: 16px; 
	font-weight: bold; 
    text-decoration: none;
}

.userprofile A:HOVER
{
	font-size: 16px; 
	font-weight: bold; 
	text-decoration: underline;
}


    

        

            
        
        

            satyajitcse
            
            
            

            

                
                    124
                    · 
                        1% · 
                            402
                        
            
            
        
    


                    

Found another good reason to avoid using IN clause in your TSQL Queries. See the example below:

 
.userprofile  
{
    color: #36c;
    font-size: 12px; 
	font-weight: bold; 
    text-decoration: none;
}

.userprofile A:VISITED
{
    color: #039;
    font-size: 16px; 
	font-weight: bold; 
    text-decoration: none;
}

.userprofile A:HOVER
{
	font-size: 16px; 
	font-weight: bold; 
	text-decoration: underline;
}


    

        

            
        
        

            satyajitcse
            
            
            

            

                
                    124
                    · 
                        1% · 
                            402
                        
            
            
        
    


                    

HI Sudeep, you are right....i was forget to mention this. thanks for Comment......

Hello friends today i check foreign key constraint can't support in bulk insert task.please take corrective action when you upload data. Create table Tbl1 ( id int primary key, varname varchar(50), fk_ID int ) Alter table T...

thanks for comment...

Copy And paste Query Create table #temp1 ( id int , Name varchar(50), City varchar(50) ) Create table #Staging_temp2 ( id int, Name varchar(50), City varchar(50) ) insert into #temp1 se...

Hello friends, one interviewer asked that suppose you have two tables Employee_Details, Employee_Details_History now I want to delete original table Employee_details and maintain it’s history to other table. How can it’s possible with only single...

Hello friends, one interviewer asked that suppose you have two tables Employee_Details, Employee_Details_History now I want to delete original table Employee_details and maintain it’s history to other table. How can it’s possible with only single...

Hello friends today i check foreign key constraint can't support in bulk insert task.please take corrective action when you upload data. Create table Tbl1 ( id int primary key, varname varchar(50), fk_ID int ) Alter tabl...