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
                        
            
            
        
    


                    

"SQL Authority" Pinal Sir published a tip about $rowguid, which can be used to fetch uniqueidentifier column from a table. It was awesome. You can find the link below. [SQL SERVER – Identifying Column Data Type of uniqueidentifier without Querying S...

"SQL Authority" Pinal Sir published a tip about $rowguid, which can be used to fetch uniqueidentifier column from a table. It was awesome. You can find the link below. [SQL SERVER – Identifying Column Data Type of uniqueidentifier without Querying S...

Today I had a requirement of finding the details of mails that sent using Database Mail feature. "sysmail_allitems" catalog view will contains the details like subject,body,recipients,CC,BCC,status,send date,file attachment etc. check out following quer...

Today I had a requirement of finding the details of mails that sent using Database Mail feature. "sysmail_allitems" catalog view will contains the details like subject,body,recipients,CC,BCC,status,send date,file attachment etc. check out following quer...

I just learned today new thing,"How to delete old e-mail messages from database mail internal tables with using sysmail_delete_mailitems_sp" check out following query. [code] USE MSDB GO Exec sysmail_delete_mailitems_sp @sent_before ='2011/12/14',@s...

I just learned today new thing,"How to delete old e-mail messages from database mail internal tables with using sysmail_delete_mailitems_sp" check out following query. [code] USE MSDB GO Exec sysmail_delete_mailitems_sp @sent_before ='2011/12/14',@s...