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
            
            
            

            

                
                    125
                    · 
                        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
            
            
            

            

                
                    125
                    · 
                        1% · 
                            402
                        
            
            
        
    


                    

@dmitri, I could not understand what you want to tell. The example you gave can be executed without making it dynamic. CREATE VIEW dbo.test AS SELECT * FROM sys.objects This statement can be executed directly to create a view in any databas...

Output clause can be used with DML commands (insert, update, delete). It works using magic tables of **deleted** and **inserted**. If you re-write the above query as delete from Employee_Details OUTPUT deleted.*; It will retu...

"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...

"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...

I have used ident_current function and it did not gave wrong value any time....

I have used ident_current function and it did not gave wrong value any time....