kr.roopesh

Getting Started with Adobe After Effects - Part 6: Motion Blur

First Time? You can support us by signing up. It takes only 5 seconds. Click here to sign up. If you already have an account, click here to login.

Friends


	Request Friendship

Upload Image

My Sections

My Activities

Blogs	7
Just Learned	27
Pages	1

kr.roopesh

818 · 0% · 35

kr.roopesh - Just Learned

Home (27) · Posts (3) · Tips (24) · Points (27)

Another good reason to avoid using IN clause in your TSQL Queries

kr.roopesh Liked 7 Months ago through Just Learned | 1 Point

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

Another good reason to avoid using IN clause in your TSQL Queries

kr.roopesh Learned 7 Months ago through Just Learned | 1 Point

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

How to create the VIEW in another database

kr.roopesh Commented 7 Months ago through Just Learned | 1 Point

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

dsorokin

616 · 0% · 57

Delete Original Data and maintain history with single SQl statement......

kr.roopesh Commented 7 Months ago through Just Learned | 1 Point

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

nirav.gandhi

38 · 5% · 1503

SQL Server - $identity returns the identity column details of a table in SELECT statement

kr.roopesh Learned 11 Months ago through Just Learned | 1 Point

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