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

My Badges

Request Friendship



Upload Image

28 years old
India
Male
Shivendra Kumar Yadav
60 · 3% · 936

Shivendra Kumar Yadav's Home

My name is Shivendra Kumar Yadav. I live in Navi Mumbai, India. I work as Sql Server Developer cum DBA at D2K Technology Pvt. Ltd..
  • Sql server - Getting Stored procedure Column headers without Result Data

    Shivendra Kumar Yadav Learned 2 Months ago through Just Learned
    Just learned from Pinal's blog that we can get the Column headers of a result set with out executing the stored procedure. By setting SET FMTONLY ON, we can get Column headers without Result Data. However it will be replaced by A DMV in next version....
    Rami Reddy
    2 · 40% · 12972
  • Sql server - Getting Stored procedure Column headers without Result Data

    Shivendra Kumar Yadav Liked 2 Months ago through Just Learned
    Just learned from Pinal's blog that we can get the Column headers of a result set with out executing the stored procedure. By setting SET FMTONLY ON, we can get Column headers without Result Data. However it will be replaced by A DMV in next version....
    Rami Reddy
    2 · 40% · 12972
  • GROUP BY Clause behavior with NULL in SQL SERVER

    Shivendra Kumar Yadav Posted 2 Months ago through Blogs
    We all play with “GROUP BY” clause almost daily basis and it is very common clause to deal with. But here I am going to describe its behavior with “NULL” values.As we know the mystery of “NULL”. It is UNKOWN; means it could be anything even if we try to...
  • Implicit conversion in the column alias name

    Shivendra Kumar Yadav Learned 10 Months ago through Just Learned
    It is self explanatory. Run these and see the output. It is wonder how clever SQL Server is to give a column alias [code]select 7A,7EF,7EE,7E2T[/code]......
    Madhivanan JR
    3 · 40% · 12935
  • Implicit conversion in the column alias name

    Shivendra Kumar Yadav Liked 10 Months ago through Just Learned
    It is self explanatory. Run these and see the output. It is wonder how clever SQL Server is to give a column alias [code]select 7A,7EF,7EE,7E2T[/code]......
    Madhivanan JR
    3 · 40% · 12935
  • Local Temporally table's scope

    Shivendra Kumar Yadav Posted 10 Months ago through Ask
    Hi, I just wonder to see the following query. I did this before but when my colleague were asking me then I thought that why it is happening? Kindly put some light. As per definition the local temp tables are valid for a single session but in ...
  • DROP command with multiple tables

    Shivendra Kumar Yadav learned 11 Months ago through Blogs
    ...
    Madhivanan JR
    3 · 40% · 12935
  • DROP command with multiple tables

    Shivendra Kumar Yadav Liked 11 Months ago through Blogs
    ...
    Madhivanan JR
    3 · 40% · 12935
  • COALESCE Vs ISNULL

    Shivendra Kumar Yadav Posted 11 Months ago through Just Learned
    Its a interesting point about COALESCE & ISNULL function in sql server that the output of COALESCE function is depends upon datatype of resultant value where as ISNULL function depends upon input value's datatype. Check this out. .... Declare @S...
  • How to Bind Transaction Isolation Level with DB User ?

    Shivendra Kumar Yadav Commented 12 Months ago through Ask
    Hello Chirag, First of all; after a long time I am saying something in this topic but while reading this post I realized that we can achieve your requirement by using SNAPSHOT ISOLATION LEVEL. For enabling it one setting we have to s...
    chiragce
    197 · 1% · 238
Previous 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | ... Next

Managed Windows Shared Hosting by OrcsWeb

Copyright © Rivera Informatic Private Ltd.