kapil_kk

Forum Replies Created

Viewing 15 posts - 571 through 585 (of 1,048 total)

RE: storing output of a Stored Procedure in a vairable

yess I can do it 🙂
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/

April 23, 2013 at 7:41 am

#1609057
RE: Nested triggers 1

Hugo Kornelis (4/23/2013)
The first sentence of the explanation should probably have read "Instead of triggers can cascade regardless of the setting of the nested trigger server option."
The question IDEA is...
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/

April 23, 2013 at 6:49 am

#1609026
RE: Nested triggers 1

gr8888 question Tom 🙂
Thanks a lot!!
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/

April 23, 2013 at 12:03 am

#1608942
RE: Handling NULL

One minor mistake i found that, You need output like "Apr 9 2013 11:38AM", But below all queries give today day. oops !!! 🙂
Hi Vinay,
Actually, I run this scenario...
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/

April 21, 2013 at 11:42 pm

#1608587
RE: Master Database

Kenneth.Fisher (4/19/2013)
You can use the object property isMSShipped to help you find user created objects.
SELECT *
FROM sys.objects
WHERE objectproperty(object_id, 'ismsshipped')=0
good one Kenneth..
I was not aware of property 'ismsshipped'
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/

April 20, 2013 at 1:05 am

#1608455
RE: Updation using fuction

Thanks Lynn and Sean I will implement in this manner and let you guys know after implementing in that way 🙂
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/

April 19, 2013 at 10:10 pm

#1608448
RE: Updation using fuction

kapil_kk (4/19/2013)
Sean Lange (4/19/2013)
kapil_kk (4/19/2013)
Sean Lange (4/19/2013)
You can't do updates/insert/deletes in a function. You would need to make this a stored proc instead. Have you considered MERGE? I think you...
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/

April 19, 2013 at 8:51 am

#1608271
RE: Updation using fuction

Sean Lange (4/19/2013)
kapil_kk (4/19/2013)
Sean Lange (4/19/2013)
You can't do updates/insert/deletes in a function. You would need to make this a stored proc instead. Have you considered MERGE? I think you could...
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/

April 19, 2013 at 8:27 am

#1608253
RE: Updation using fuction

Sean Lange (4/19/2013)
You can't do updates/insert/deletes in a function. You would need to make this a stored proc instead. Have you considered MERGE? I think you could probably turn this...
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/

April 19, 2013 at 7:52 am

#1608228
RE: Triggers 1

IgorMi (4/19/2013)
kapil_kk (4/18/2013)
oopes,
I think I have misunderstood the way to execute the given query...
After seeing comments First Attempts, second, third I executed one by one those insert query and forget...
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/

April 19, 2013 at 5:13 am

#1608147
RE: Triggers 1

Hugo Kornelis (4/19/2013)
kapil_kk (4/18/2013)
oopes,
I think I have misunderstood the way to execute the given query...
Oohhh, I am so sorry that the comments in the code made you misunderstand the question....
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/

April 19, 2013 at 2:10 am

#1608108
RE: Triggers 1

oopes,
I think I have misunderstood the way to execute the given query...
After seeing comments First Attempts, second, third I executed one by one those insert query and forget about the...
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/

April 18, 2013 at 11:40 pm

#1608080
RE: Sum and Count

Dineshbabu (4/18/2013)
I think it's more about CROSS JOIN than SUM & COUNT.. Nice One..
Right Dinesh 😛
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/

April 18, 2013 at 6:42 am

#1607702
RE: Sum and Count

Danny Ocean (4/17/2013)
kapil_kk (4/17/2013)
Nice question... learn something new today.. 🙂
But can anyone plz explain me about the SUM part which is returning 12, I am not clear with this section...
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/

April 17, 2013 at 11:39 pm

#1607537
RE: Sum and Count

Nice question... learn something new today.. 🙂
But can anyone plz explain me about the SUM part which is returning 12, I am not clear with this section :w00t:
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/

April 17, 2013 at 11:20 pm

#1607530

Viewing 15 posts - 571 through 585 (of 1,048 total)