Viewing 15 posts - 1 through 15 (of 18 total)
Let's take for example Nothwind database. There are tables Products, [Order Details], and Orders. We need to insert new batch of orders. My sample below doing that in two steps....
November 17, 2016 at 8:16 am
Great article. However, it could be even better, if you add OUTPUT in combination with MERGE statement to provide INSERT for third normal form. Do you have such as example?...
November 17, 2016 at 6:27 am
What SSRS version do you using, this problem was corrected in SSRS 2008
February 23, 2015 at 11:27 am
To send a table from .NET, you need to use DataTable. I wrote number of applications using this technique, now issues were found. If I have any issues, then I...
February 6, 2014 at 6:44 am
I have tested CLR to split a delimited string, much slower and take bigger resources. This why I did include CLR option in my posting.
February 6, 2014 at 5:59 am
On this article, my goal was to bring different varieties on techniques how to work with multiple values sent to a stored procedure. The final choice on the reader. I...
February 6, 2014 at 5:54 am
INSTALL function (code below) and use it to split a value
CREATE FUNCTION [dbo].[StringToTable]
(@RawString nvarchar(4000), @Delimiter nvarchar(10) )
@VList TABLE (RowID int...
August 13, 2010 at 2:17 pm
Just declare as many variables as you need, convert report parameters to delimited string send to sproc ... use the same scenario. Let me know if you have any problem.
August 13, 2010 at 1:49 pm
For internal SQL only - Yes.
April 21, 2009 at 1:29 pm
Irina, I will research this problem for you. I believe that you need to check array count, Then throw an error when count greater then expected value.
April 21, 2009 at 7:33 am
Most of my fellow audience miss the point. For some reason your focus comes to how to parse a string, however this article how prevent array passing to stored procedure.
April 21, 2009 at 7:29 am
In real project I never used comma. I am using any non-keybord character, for example ASCII = 135. The comma was used for simplisity.
April 21, 2009 at 7:25 am
You could use select * from sys.objects where is_ms_shipped = 0 as well. I am not INFORMATION_SCHEMA fan. This is personal preference.:D
October 10, 2008 at 6:25 am
Thanks to everyone for good response (and bad as well). Sorry for broken C# link, but it’s nothing to do with the article.
October 10, 2008 at 6:22 am
Believe it on not – I did. This is was while ago, but when I joined to project, all sprocs named as SP_. It took about a month to convince...
October 10, 2008 at 6:18 am