Where Vs Having / Difference between having and Where clause (gouravverma.blogspot.com)

submitted by gouravverma(60) 4 years, 1 month ago

We always get confused between WHERE and Having clause and make mistakes. Here in this article, I will try to highlight all the major differences between WHERE and HAVING, and things you should be aware of, when using either WHERE or HAVING read more...

1 comment |category: Database |Views: 6

tags: Database another

Limit postbacks with ASP.NET client callbacks (gouravverma.blogspot.com)

submitted by gouravverma(60) 4 years, 1 month ago

isconnected Over the years, there have been various solutions that circumvent the stateless limitation of Web applications, with the focus on reducing the number of page calls or reloads to avoid hampering the user experience. For example, many developers used hidden frames to serve as data sources so data could easily be sent to or retrieved from the hidden frame page. Also, some developers chose to load everything with the initial load, so subsequent page loads are reduced. read more...

add a comment |category: ASP.NET |Views: 5

tags: ASP.NET another

Top ten new features in Sql Server 2005 (gouravverma.blogspot.com)

submitted by gouravverma(60) 4 years, 1 month ago

T-SQL is the native set-based RDBMS programming language offering high-performance data access. It now incorporates many new features including error handling via the TRY and CATCH paradigm, Common Table Expressions (CTEs), which return a record set in a statement, and the ability to shift columns to rows and vice versa with the PIVOT and UNPIVOT commands. read more...

add a comment |category: Database |Views: 6

tags: Database another

Refreshing update panel(gouravverma.blogspot.com)

submitted by gouravverma(60) 4 years, 1 month ago

Basic of refreshing ajax driven update panel read more...

add a comment |category: AJAX |Views: 43

tags: AJAX another

Visual CSharp Debugger(gouravverma.blogspot.com)

submitted by gouravverma(60) 4 years, 2 months ago

Debugging issues ASP.NET Debugging *If you can’t find the error message that you’re looking for in this section, please check the section which deals with general debugging issues or remote debugging issues read more...

1 comment |category: ASP.NET |Views: 37

tags: ASP.NET another

SQL Server 2005 vardecimal storage format(sanjevsharma.blogspot.com)

submitted by sanjev.sharma(579) 4 years, 2 months ago

Added new functionality in the SQL Server 2005 Enterprise Edition to provide an alternate storage format that can be used to minimize the disk space needed to store existing decimal and numeric data types. No application changes area are required to use its benefits. read more...

add a comment |category: ASP.NET |Views: 1

tags: ASP.NET another

Properly Capturing Identity Values in a SQL Server(sanjevsharma.blogspot.com)

submitted by sanjev.sharma(579) 4 years, 2 months ago

When inserting a row into a database table that contains an identity column, I need a way to capture the identity value generated by the database engine after it inserts the row into this table. What can I use to capture this value while also making sure this value is accurate? read more...

add a comment |category: ASP.NET |Views: 1

tags: ASP.NET another

SQL server 2005 : TOP Clause(sanjevsharma.blogspot.com)

submitted by sanjev.sharma(579) 4 years, 2 months ago

There are few enhancements in the TOP clause, (SQL Server 2005). I have pointed out few, which I would like to share with you all. It’s very important to keep ourselves updated with the new features and enhancements, so keep reading when ever you get time. read more...

add a comment |category: ASP.NET |Views: 2

tags: ASP.NET another

SQL server 2005 : OUTPUT Clause(sanjevsharma.blogspot.com)

submitted by sanjev.sharma(579) 4 years, 2 months ago

SQL Server 2005 provides a new clause known as "Output". Output operates on similar lines as that of a trigger i.e. it provides you the details about affected records in logical tables named deleted and inserted. read more...

add a comment |category: ASP.NET |Views: 7

tags: ASP.NET another

AJAX When and where to use ?(sanjevsharma.blogspot.com)

submitted by sanjev.sharma(579) 4 years, 3 months ago

AJAX is certainly a hot topic these days; every body is going for it, which has led to a number of sites using AJAX where it’s even not necessary or appropriate. read more...

add a comment |category: AJAX |Views: 0

tags: AJAX another

Flash Player issues with Secure Sockets Layer (SSL) communication(sanjevsharma.blogspot.com)

submitted by sanjev.sharma(579) 4 years, 3 months ago

flash + SSL + IE = WTF I’ve been working on a project in which we were generating a flash based menu. It was all working fine until we implemented Verisign SSL on the site. read more...

add a comment |category: ASP.NET |Views: 14

tags: ASP.NET another

Auto Refresh update panel on page using AJAX - c#(sanjevsharma.blogspot.com)

submitted by sanjev.sharma(579) 4 years, 7 months ago

In this article, I am going to explain how we can auto refresh data on an ASP.NET page after a certain interval using AJAX UpdatePanel and other controls (assuming you have some basic knowledge of AJAX Toolkit). I am using some Ajax controls and using SQL server database and Data Grid control. Lets for the time, use database north wind and set our interval time for refreshing data as 30 seconds. read more...

1 comment |category: AJAX |Views: 1514

tags: AJAX another

Top 5 Application Security Vulnerabilities in Web.config Files(sanjevsharma.blogspot.com)

submitted by sanjev.sharma(579) 4 years, 7 months ago

Top 5 Application Security Vulnerabilities in Web.config Files read more...

1 comment |category: ASP.NET |Views: 7

tags: ASP.NET another