Fransiscus Setiawan

[...] from the source table if it is not in my updated list, if there is a matched record then I’d like to update the [...]

[...] GO –Create source table DECLARE @UpdatedProducts TABLE ( ProductID INT PRIMARY KEY, ProductName VARCHAR(100), Rate MONEY ) –Insert records into source table INSERT INTO @UpdatedProducts VALUES (1, [...]

I have an Excel file that need to be exported into XML. I have a few files to be converted. One of them was complaining when I’m about to export it [...]

[...] “ViewLocation“, “PartialViewLocation” and “MasterLocation” with our own default location which is “Media” Secondly, we need to override “CreateView” method and “ [...]

In SQL Server 2008, we can do a table synchronisation in one transaction of SQL Command. For example normally, we have a source table and then we have [...]

Simple sample in how to use Table Valued Parameter which is a new feature in SQL Server 2008. I found it very useful to pass bulk data from one SP to [...]

So here is the situation, I need to build a personalization for the user where they can have different View files based on their user preference or al [...]