TSQL

I had a problem where I need to restore database using shared folder on the network. I tried to copy it locally to my local harddrive but then the connection is not stable enough. Hence I…

Here is the scenario, You have a stored procedure that builds dynamic insert SQL which means the “INSERT” statement is being composed on the fly based on the table name but at the same time you…

This is the case: I have a table and basically this table has many redundancy. The solution is to create a link table and this table will contains record association. So what I need to do…

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…

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…

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 (…