Click here to Skip to main content
15,915,867 members

Comments by Rachana Gaur (Top 8 by date)

Rachana Gaur 19-Oct-12 6:13am View    
what type of update query will be use

Give an example
Rachana Gaur 19-Oct-12 6:10am View    
sqlserver 2005
Rachana Gaur 19-Oct-12 6:07am View    
But i will get same output as I say 25/11/1987 25/11/1987

30/12/1968 30/12/1968
09/01/1984 09/01/1984
31/01/1983 31/01/1983
08/04/1956 08/04/1956
03/05/1959 03/05/1959
02/02/1988 02/02/1988
9/10/1975 9/10/1975
01/11/1980 01/11/1980
08/10/1987 08/10/1987
22/11/1972 22/11/1972
20/12/1972 20/12/1972
26/03/1999 26/03/1999
25/10/2005 25/10/2005
12/08/1985 12/08/1985
28/08/1988 28/08/1988
04/10/1979 04/10/1979
14/11/1981 14/11/1981
14/11/1981 14/11/1981
20/09/1976 20/09/1976
27/12/2008 27/12/2008
24/12/1970 24/12/1970
12/07/1970 12/07/1970
28/02/1962 28/02/1962
18/08/2000 18/08/2000
10/01/2011 10/01/2011
16/05/1955 16/05/1955
01/07/1957 01/07/1957
12/12/1952 12/12/1952
10/03/1969 10/03/1969
NULL NULL
02/05/1978 02/05/1978
19/10/2004 19/10/2004
24/08/1945 24/08/1945
03/03/1975 03/03/1975
20/11/1944 20/11/1944
18/02/1958 18/02/1958
19/01/1987 19/01/1987
09/09/1986 09/09/1986




12/08/1986 12/08/1986
03/11/1979 03/11/1979
12/06/1966 12/06/1966
07/08/2001 07/08/2001
26/06/1965 26/06/1965
13/09/1966 13/09/1966
19/12/1981 19/12/1981
31/10/1989 31/10/1989
15/06/2012 15/06/2012
06/08/1984 06/08/1984
21/12/1953 21/12/1953
13/11/1959 13/11/1959
14/03/1974 14/03/1974

30/10/1951 30/10/1951
06/03/1956 06/03/1956
08/10/1972 08/10/1972
14/12/1952 14/12/1952
24/01/1982 24/01/1982
15/08/1985 15/08/1985
20/04/1959 20/04/1959
19/07/2001 19/07/2001
06/10/1997 06/10/1997
06/10/1953 06/10/1953
13/02/0960 13/02/0960
06/11/1957 06/11/1957
16/12/1968 16/12/1968
03/12/1999 03/12/1999
25/11/1997 25/11/1997


24/07/1982 24/07/1982
29/08/1971 29/08/1971
28/03/1974 28/03/1974
07/12/1985 07/12/1985
01/11/1980 01/11/1980
10/07/1984 10/07/1984
03/01/1982 03/01/1982
19/06/1961 19/06/1961
26/12/1998 26/12/1998
12/05/2009 12/05/2009
20/06/1967 20/06/1967
17/05/1983 17/05/1983
25/08/2001 25/08/2001
29/12/1986 29/12/1986
17/02/1960 17/02/1960
25/03/1985 25/03/1985
12/02/1987 12/02/1987
26/03/1959 26/03/1959
30/03/1958 30/03/1958
01/03/2002 01/03/2002
25/09/1970 25/09/1970
15/06/1981 15/06/1981
8/1/1979 8/1/1979
11/02/1985 11/02/1985
22/09/1988 22/09/1988
10/12/1986 10/12/1986
Rachana Gaur 19-Oct-12 6:03am View    
I will see same value like we have 16/03/2012 & After this query I had get 16/03/2012
Rachana Gaur 19-Oct-12 5:58am View    
what should I do for this