Programing Concept

Dear Friends we can use command of command prompt in sqlserver   use   xp_cmdshell   for fire batching command   Like   EXEC   xp_cmdshell   ' Command String ' EXEC xp_cmdshell 'dir *.exe'   to get all directory information EXEC xp_cmdshell 'mkdir kunal' to Create New Directory is deafult path system32 you can set Reference From : http://www.c-sharpcorner.com/Blogs/9569/create-directory-using-sqlserver.aspx 

We can get all values of a column in a single coma separated string this query.  Declare @id  varchar(Max) Select @id = coalesce(@id + ',' ,'') + Cast(ItCode as varchar(10)) From ItMast Select @id  After you will get result like this Reference From : http://www.c-sharpcorner.com/Blogs/9637/get-a-column-value-in-a-single-coma-separated-string-in-sql.aspx

CREATE   TABLE   [dbo] . [tblDupRecord] (       [id] [int]   NULL,       [name] [varchar] ( 50 )   COLLATE   SQL_Latin1_General_CP1_CI_AS   NULL,       [marks] [int]   NULL )   ON   [PRIMARY] GO insert   into   [tblDupRecord]   values ( 1 , 'Name1' , 25 ) insert   into   [tblDupRecord]   values ( 2 , 'Name2' , 50 ) insert   into   [tblDupRecord]   values ( 3 , 'Name3' , 35 ) insert   into   [tblDupRecord]   values ( 4 , 'Name4' , 40 ) insert   into   [tblDupRecord]   values ( 5 , 'Name5' , 45 ) insert   into   [tblDupRecord]   values ( 6 , 'Name6' , 45 ) GO   select   *   from   tblDupRecord  a where   2 =   ( select   count (   distinct ( b . marks ))   from   tblDupRecord b   where  ...

Select    Qry .*,   Case   When   Qry . Door   =   ''   Then   Qry . Door   Else     Substring ( Qry . Door ,   3 , Len ( Qry . Door )   -   2 )   End   As   Door From     ( SELECT   dbo . tblHardware . Cmp_Id ,   Hardware_Id   ,   Hardware_Code   AS   [Hardware Code] , ( Select   ', '   +   cast ( Door_Name   as   varchar )   FROM   tbldoor                            WHERE   tbldoor . Hardware_Id   = tblHardware . Hardware_Id   FOR   XML   path ( '' ))   Door FROM   dbo . tblHardware   WHERE   ( dbo . tblHardware . Is_Deleted   =   0 ) )   As   Qry    Reference By http://www.c-sharpcorn...

ROUTINE_TYPE =   'PROCEDURE' OR     'Function' Select   ROUTINE_TYPE , SPECIFIC_NAME , ROU TINE_DEFINITION FROM      INFORMATION_SCHEMA.ROUTINES WHERE     OBJECTPROPERTY ( OBJECT_ID ( SPECI FIC_NAME ), 'IsMSShipped' )   = 0          AND   ROUTINE_DEFINITION    like   '%prcleave%'          AND   ROUTINE_TYPE = 'PROCEDURE'

Winners believe!! Winners believe in themselves….in what they do. Belief drives passion… passion for a definite purpose. If we believe in ourselves, believe in our personal vision with unyielding determination, we succeed.  “Whatever the mind can conceive and believe… it can achieve.”                   – Napoleon Hill One of the important lessons I have learned from decades of experiencing the cycles of life is that how we view the world is all in our minds. If we think we “can’t”….then we “can’t”. If we only “try”, then we are not fully committed and leave the door open for failure. Our lives become what we truly believe, and what we believe creates our lives.  I believe….. first in my marriage, and have the best marriage of anyone I know. I believe…. in myself (sometimes less than perfect,) and have developed strong self confidence. Self confidence attracts others… it’s contagious. We all need ...