Viewing 15 posts - 616 through 630 (of 1,048 total)
Good Question but still I have doubts in some cases like:
SELECT ISNUMERIC('.+') -- Returns 0
SELECT ISNUMERIC('+.') -- Returns 1
SELECT ISNUMERIC (',\') -- Returns 0
SELECT ISNUMERIC ('\,') -- Returns 1
:ermm:
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
April 7, 2013 at 11:19 pm
Dineshbabu (4/4/2013)
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
April 5, 2013 at 7:44 am
mamzy.rahman (4/4/2013)
need some help with a query!!!
basically i have a table that has a list of learner with a number of aims. i want to do a query that...
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
April 4, 2013 at 8:26 am
Lon-860191 (4/4/2013)
Changing the where to and will result in the same output from both of the queries.
Sorry Lon,
Changing the WHERE to AND will result in different output rows... that's...
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
April 4, 2013 at 8:24 am
L' Eomot Inversé (4/4/2013)
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
April 4, 2013 at 7:16 am
Hugo Kornelis (4/4/2013)
But ... (isn't there always a "but"?)
When I saw the question in the newsletter, I expected the answer options to be phrased in...
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
April 4, 2013 at 3:04 am
Danny Ocean (4/4/2013)
kapil_kk (4/4/2013)
I also thinks that the options are not well written... Sorry for that 🙁 ..
My point of concern was to to throw light on different behaviors...
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
April 4, 2013 at 12:33 am
Hi all,
I also thinks that the options are not well written... Sorry for that 🙁 ..
My point of concern was to to throw light on different behaviors of AND and...
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
April 4, 2013 at 12:03 am
devaji123 (4/3/2013)
Hi,Use Select max(identity column name) from table name (data inserted table). In one of our scenario we used this it worked. Try this.
Vasu
When we have inbuilt function...
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
April 3, 2013 at 11:21 am
Lynn Pettis (4/3/2013)
kapil_kk (4/3/2013)
But its giving me error that @new_identity parameter...
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
April 3, 2013 at 11:20 am
Hugo Kornelis (4/2/2013)
Dineshbabu (4/1/2013)
Thanks Hugo,I have one more doubt, will ANSI_PADDING set option affects the datastorage?
No and yes.
No, because the working of LEN and DATA_LENGTH are not affected by this...
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
April 2, 2013 at 2:06 am
Good question :-):-)
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
April 1, 2013 at 11:36 pm
chgn01 (4/1/2013)
I found this option in SQL 2020 SP4
:-P:-P
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
April 1, 2013 at 11:34 pm
Ahhhhh........ I lost the chance to grab a lot of points 🙁
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
April 1, 2013 at 12:07 am
Koen Verbeeck (3/29/2013)
Try using a MERGE statement instead.
But I am doing only insertion not updation...Will it be good to use it only for...
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
March 29, 2013 at 5:16 am
Viewing 15 posts - 616 through 630 (of 1,048 total)