Interview Questions of SQLServer
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...
Sqlserver - Query to Get Size of the data
Query to get the size of a column data for each row. Select DATALENGTH(<
Query to remove the matching expression SQLServer
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
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 Important Topics
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
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
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
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
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 = @"