Recent Answers What is difference between string and stringbuilder? Vinit Kumar answered: string -the object of this class are immutable i.e. we can not change any character that is c.... How Just in Time Compiler Works? Johndecruse answered: When you execute the program, i.e. the intermediate code, the Just-In-Time (JIT) compiler com.... If I have an external aspx page? How do u integrate with existing sharepoint site? I want to publish it over t.... Satyen Kasturi answered: what you want is to use Application pages. These are located in Layouts directory. Within .... where are the different file to content query webpart? To design a page? uday answered: content query webpart displays a dynamic view of sites ,pages have worked in BDC? Mike answered: BDC stands for Business Data Catalog. It is a new feature introduced in Microsoft Office SharePoint .... How do I connect database and infopath in sharepoint? jiten_keswani answered: \\.\pipe\mssql$microsoft## ssee\sql\query (for Sharepoint 2007) or \\.\pipe\mssql$sharepoin.... What's new in .Net Framework 3.0? Daniel answered: Visual Studio 2008 and the .NET Framework 3.5 enable developers to rapidly create connected applic.... What's new in .Net Framework 3.0? resumedocket answered: WPF provides new features for making more interesting, effective, and dynamic user interface.... What is "out" keyword in C#? Johndecruse answered: “out Keyword” in C#.out keyword is used for passing a variable for output purpose. It has sam.... What is a SharePoint Site Collection and how can we create it? resumedocket answered: To create a SharePoint site, you must be a member of a site group that has the Create Subsit.... 1 2 3 4 5 6 7 8 9

SQL Server Interview Questions and Answers What is the maximum length of a varchar field in SQL Server? Variable-length data with a maximum of 8,000 characters. Category: SQL Server Date: 10/30/2009 7:51:03 AM What authentication mechanisms does Microsoft SQL Server support? SQL Server supports following two type of authentication mechanisms: 1) Windows Authentication (via.... Category: SQL Server Date: 10/15/2009 4:43:44 AM What is the difference between UNION and UNION ALL Statements? UNION command selects distinct and related information from two tables while UNION ALL selects all t.... Category: SQL Server Date: 10/7/2009 3:19:40 AM What is the difference between VARCHAR and NVARCHAR type? VARCHAR is a variable length string of ASCII characters while NVARCHAR is a variable length string o.... Category: SQL Server Date: 10/7/2009 3:09:18 AM What is SQL injection attack? SQL injection is an attack in which malicious code is inserted into strings that are later passed to.... Category: SQL Server Date: 10/2/2009 7:12:03 AM Why we use SET ROWCOUNT statement in SQL Server? It causes SQL Server to stop processing the query after the specified number of rows (e.g. SET ROWCO.... Category: SQL Server Date: 10/2/2009 7:03:39 AM How can we delete the duplicate rows from a table? Lets consider if we have a table Employee with rowid, name and email columns. Then we can use follow.... Category: SQL Server Date: 9/19/2009 4:58:46 AM How can we find the number of rows in a table? Following SQL statements can be used to get the number of rows in a table: SQL Query - 1: SELECT CO.... Category: SQL Server Date: 9/19/2009 4:51:20 AM Write down the general syntax for a SELECT statement covering all the options. SELECT select_list [INTO new_table] FROM table_source [WHERE search_condition] [GROUP BY group_by_ex.... Category: SQL Server Date: 9/19/2009 4:24:23 AM Whatis the difference between DELETE TABLE and TRUNCATE TABLE commands? DELETE TABLE command is used to delete all the rows in a table. It is a logged operation, means the .... Category: SQL Server Date: 9/19/2009 4:17:27 AM What is a Stored Procedure? Stored procedure is a named group of SQL statements that have been previously created and stored in .... Category: SQL Server Date: 9/19/2009 4:11:48 AM