Viewing 15 posts - 31 through 45 (of 1,048 total)
Hardy21 (6/30/2014)
kapil_kk (6/30/2014)
I have a scenario in which I need to capture count of rows returned by execution of stored procedure.
I new we can do it declaring OUTPUT parameter...
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
June 30, 2014 at 4:12 am
only SELECT
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
June 30, 2014 at 4:11 am
is that are SQL functions?
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
May 22, 2014 at 11:08 pm
you can try using table valued parameter for this...
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
May 22, 2014 at 4:58 am
Please check you table structure if any identity property applied on id column
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
May 22, 2014 at 4:45 am
For that you need to use ON DELETE CASCADE
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
May 22, 2014 at 4:42 am
GilaMonster (3/11/2014)
Sure.You ensure that every single piece of code that could ever possibly update the deleteflag of tablA also goes and updates the deleteflag of the other tables.
what if I...
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
March 11, 2014 at 5:44 am
GilaMonster (3/11/2014)
You need a trigger for that.
ok...
do we have any alternative other than trigger....
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
March 11, 2014 at 5:23 am
yes I have unique contraint , nonclusted index exists on tables might be they are causing this issue....
But I dont have any idea that can we disable uniquest constraint or...
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
March 3, 2014 at 1:22 am
after omiting varbinary column from SELECT list, you will stil get the clustered index scan only.....
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
February 28, 2014 at 7:19 am
you need to use SUM aggregate function with group by on CustNum column....
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
February 28, 2014 at 7:03 am
HI Daniel,
I think you are not clear what Gail is asking.
what he is saying that for other than 'Team1' do you have non numeric data in the table....if that exists...
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
February 28, 2014 at 6:52 am
Hi all,
can anyone please tell me how can I get hte value from
<contentRecords locale="en_US">
as value en_US
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
February 25, 2014 at 11:14 pm
heya, I am able to find the problem...
Just change the query to this and it will work:
select X.value('contentId[1]','varchar(1000)') as ContentId,
X.value('content[1]', 'varchar(2000)') as Content
FROM XMLwithOpenXML A
CROSS APPLY A.XMLdata.nodes('/Internationalization/contentRecords/contentRecord') as N(X)
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
February 25, 2014 at 6:58 am
You can use CTE if you dont want to use subquery...
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
February 14, 2014 at 4:08 am
Viewing 15 posts - 31 through 45 (of 1,048 total)