Balavardhan Reddy Narani

Interview Questions of SQLServer

March 17 2013 , Written by Balavardhan Reddy Published on #SQL Server2005

Do you know what are User Defined functions. Scalar, Inline Table-Valued and Multi-statement Table-valued. A Scalar user-defined function returns one of the scalar data types. Text, ntext, image and timestamp data types are not supported. These are the...

Repost0

Sqlserver - Query to Get Size of the data

March 17 2013 , Written by Balavardhan Reddy Published on #SQL Server2005

Query to get the size of a column data for each row. Select DATALENGTH(<>) from <> Query to get the size of a column data for each group. Select DATALENGTH(<>), <> from <> Group by <

Query to remove the matching expression SQLServer

October 12 2012 , Written by Balavardhan Reddy Published on #SQL Server2005

A simple query to remove the particular patreen from the entire string, its just like reggular expression in the ASP.Net Query to strip the matching expression charectors from string , Declare @myExpression varchar(50) Declare @queryString varchar(max)...

…

iTextSharp

June 6 2012 , Written by Balavardhan Reddy

Getting Started with iTextSharp For the ASP.NET developers out there, if you need to generate PDF reports from your code, there is an open source library called iText# (iTextSharp) that is worth checking out. iTextSharp is a port of the Java iText library...

ASP.NET

December 29 2011 , Written by Balavardhan Reddy Published on #ASP.Net

ASP.NET ASP.NET, the next version of ASP, is a programming framework used to create enterprise-class Web Applications. These applications are accessble on a global basis leading to effecient information management. The advantages ASP.NET offers is more...

ASP.NET Important Topics

December 29 2011 , Written by Balavardhan Reddy Published on #ASP.Net

1) Asp.net Page Life Cycle & Page Architecture. 2) Assemblies. 3) User Controls & Custom Controls. 4) Gridview Control. 5) Themes, Skins and Style Sheets. 6) Master Pages. 7) Site Maps. 8) State Management. 9) Security(Web.config) (Authentication & Authorization)...

FOR XML - SQL Server

June 9 2010 , Written by Balavardhan Reddy Published on #SQL Server2005

Introduction In Microsoft SQL Server 2000, we introduced the FOR XML clause to the SELECT statement. This clause provides the ability to aggregate the relational rowset returned by the SELECT statement into XML. FOR XML on the server supports three modes—RAW,...

…

SQL Server Rank functions, RANK, NTILE, DENSE_RANK, ROW_NUMBER

April 20 2010 , Written by Balavardhan Reddy Published on #SQL Server2005

Transact-SQL provides the following ranking functions: -RANK -NTILE -DENSE_RANK -ROW_NUMBER Rank() - Applies to monotonically increasing number for each value in the set Row_Number() - simply assigns sequential numbering to the records of a result-set...

Time Delay to Execute a T-SQL Query

March 17 2010 , Written by Balavardhan Reddy Published on #SQL Server2005

A New feature in SQL Server is Time delay to execute a T-SQL Query SQL Server will wait for perticular time to excute the query. Ex : i) SELECT GETDATE() CurrentTime WAITFOR DELAY '00:00:20' ---- 5 Second Delay SELECT GETDATE() CurrentTime Ex: ii) DECLARE...

.text { mso-number-format:\@;..."> Export Gridview data to Excel

February 18 2010 , Written by Balavardhan Reddy Published on #ASP.Net

i) Get the Data from the Database and Bind it to the Gridview ii) Set Gridview Allowpaging property to "False" Write the below code to export the entire Gridview data to Excel sheet private void ExportGridView() { string style = @"