Browse by Tags
All Tags »
Database (
RSS)
It took me quite a while to find a proper example of how to communicate with SQL Reporting Services in order to execute a specific report, I though I might share it. We have Report Server 2008 installed over SQL Server 2005. I needed to extract data of...
Read the full details here . In essence: Filestream will save the files on the filesystem giving you streaming capabities with the use of public filesytem API along with preferred performance over normal BLOB. From the post - Rule of thumb: Data >...
Searched it for a while, thought it might be worth sharing. Following is the T-SQL script to alter a table to apply a UNIQUE constraint on a certain column: ALTER TABLE [TableName] WITH NOCHECK ADD CONSTRAINT UniqueConstraintName UNIQUE ( [ColumnName...
Via this post . I created a column in a certain table to contain various files with "VarBinary(MAX)" as its data type. I wanted to test stuff, so I needed data in the tables. But Oh My, Now What? Should I really write C# Project to insert a...
I decided to place it here in case I would need such a thing in the future :) The select statement selects forum-like data model which supports paging as well. (Where comments will be below the main entry and so on) DECLARE @Level int DECLARE @CurrentID...