Wordpress - hspinfo.wordpress.com - HP's Blog
General Information:
Latest News:
Microsoft SQL Server: ROLLBACK TRANSACTION request has no corresponding BEGIN TRANSACTION 24 Aug 2011 | 01:14 am
I have noticed that If we are using a transaction within any Stored Procedure like CREATE PROCEDURE .... AS BEGIN BEGIN TRANSACTION ... IF @@Error <> 0 GOTO Rollback_Transaction ... IF @@Error <> 0 GO...
Microsoft SQL Server 2008: Fulltext and Stoplist Association, Manage Multiple Stoplists 27 Jul 2011 | 06:38 pm
Today after having so many days effort, I finally able to find out how we can manage multiple stoplists for a database? “Why MS-SQL Server 2008 is providing facility to create multiple custom stoplist...
Protected: ASP.NET Handling Browser’s Close Event And Perform Session Abandon 12 Jul 2011 | 09:46 pm
There is no excerpt because this is a protected post.
How do I get result of dynamic SQL into a variable? 2 May 2011 | 11:00 pm
DECLARE @SQLQuery VARCHAR(4000) SET @SQLQuery = 'SELECT @Query_Result_Count = Count(Column_1) FROM table_A' DECLARE @Outer_Variable AS INT EXEC Sp_executesql @query = @SQLQuery, @params = N'@Query_Res...
ASP.Net – How to delete file from server after download is finished 30 Apr 2011 | 09:59 pm
Here I am providing the code snippet that will allow us to delete the file once the file is downloaded on the client’s machine. Below are the code snippets C# private void DownloadFile() { Response.Co...
ASP.Net – How to delete file from server after download is finished 30 Apr 2011 | 05:59 pm
Here I am providing the code snippet that will allow us to delete the file once the file is downloaded on the client’s machine. Below are the code snippets C# private void DownloadFile() { Response.Co...
How to use Union and Group By in MS SQL? 16 Sep 2009 | 08:20 pm
I found some problem using Union and Group By clause together, and I later realized that my technique of using these words together is not proper. Most of the users are making the same mistakes when t...
How to disable Anchor tag in IE and Firefox? 16 Sep 2009 | 07:34 pm
I have searched many sites for to disable anchor and I know that IE supports ‘disable’ property for anchor tag, however Firefox does not support this. So whenever you try with ‘disable’ property of an...
How to get comma separated values from a database table without using cursor 25 Aug 2009 | 06:06 pm
You can retrieve comma separated values from a database table using following type of SQL scripts DECLARE @varList VARCHAR(1000) SET @varList = SPACE(0) SELECT @varList = @varList + ', ' + ContactName...
Auto refresh the page and keep the viewstate of the page on each refresh 21 Aug 2009 | 04:41 pm
Today I am writing about how you can auto-refresh the page and still how you can manage the view-state of the page. There may be requirement to fill up a long lasting form and this might take you a lo...
