Linq.Binary(SQL Image Data Type) Type to File Stream
I got a column with Data Type of Image in SQL Server. What I would like to do is to omit this data to a FileStream or to a file. I tried to read the data…
-
-
SQL Methods in LINQ
I’m trying to implement DateDiff in LINQ. I would like to get all records with the same date and ignoring the timestamp. Here is my code snippet which doesn’t work public int tblExpReceiptFileUniqueID(string chCreateStaffCode, string vcFileName,…
-
Check Existence of temp table in memory
How to check whether the temp table is exists on the memory or not?The reason why you need this is because your stored procedure can throw the error when you try to drop a temp table…
-
Find Index in all the tables SQL Server
This is a query to find all the indexes in your table including when it was last updated Find all indexes on all tables SELECT OBJECT_NAME(OBJECT_ID) AS ‘Table Name’, [name] as ‘Statistic’, STATS_DATE(object_id, index_id) AS ‘Last…
-
CSV parsing in SQL server
I’ve got this SQL Function to parse comma separated value into a table. We need this function when our application commit separated comma value in a text. We normally do this when we want to send…
-
Dynamic Order By in ROW_NUMBER()
How to do order by in your paging using ROW_NUMBER() feature on SQL Server 2005 SELECT a.CurrentPrice, a.LotQuantity, a.IsAuction, a.AuctionID, a.AuctionName, a.DateStart, a.DateFinish, a.StartingPrice, a.ReservePrice, a.FixedPrice, a.BidIncrement, p.ProductID, p.CategoryID, p.BrandID, p.ProductName, p.ContentID, p.ThumbImageID, Row_Number() OVER (…
-
Using Transaction Scope on .NET
Basic Requirements: 1. Have the MSDTC(Distributed Transaction Coordinator) windows service running on your machine 2. Be talking to a SQL 2000 or 2005 Database configured likewise 3. Run this registry script to fix the windows XP…
-
Paging through strored procedure in sql server
This is very important for the most web developers. This stored procedure accept parameter of page index and page size. By using this paging, you don’t need to store everything in your viewstate which in the…