<< < 13 14 15 16 17 18 19 20 21 22 23 > >>   Sort: Rank

What is the purpose of using COLLATE in a query?
What is the purpose of using COLLATE in a query? Answer1. Collation refers to a set of rules that determine how data is sorted and compared. Character data is sorted using rules that define the correct character sequence, with options for specifying case-sensitivity, accent marks, kana character typ...
2014-10-10, 1313👍, 0💬

Using query analyzer, name 3 ways you can get an accurate count of the number of records in a table.
Using query analyzer, name 3 ways you can get an accurate count of the number of records in a table. Answer1. a. Select count(*) from table1 b. SELECT object_name(id) ,rowcnt FROM sysindexes WHERE indid IN (1,0) AND OBJECTPROPERTY(id, ‘IsUserTable’) = 1 c. exec sp_table_validation @table = ‘authors...
2014-10-08, 1368👍, 0💬

How to find the SQL server version from Query Analyser
How to find the SQL server version from Query Analyser Answer1 To determine which version of Microsoft SQL Server 2005 is running, connect to SQL Server 2005 by using SQL Server Management Studio, and then run the following Transact-SQL statement: SELECT SERVERPROPERTY(’productversion ’),SERVERPROPE...
2014-10-08, 1115👍, 0💬

Which command using Query Analyzer will give you the version of SQL Server and Operating System?
Which command using Query Analyzer will give you the version of SQL Server and Operating System? @@VERSION Returns version, processor architecture, build date, and operating system for the current installation of SQL Server.
2014-10-06, 1238👍, 0💬

Tell few steps for optimizing (for speed and resource) ASP page/application.
Tell few steps for optimizing (for speed and resource) ASP page/application. Avoid mixing html code with asp code
2014-10-06, 1269👍, 0💬

How many types of cookies are there?
How many types of cookies are there? Answer1 Two type of cookeies. a) single valued eg request.cookies(”UserName”).va lue=”Mahesh”b)Multivalued cookies. These are used in the way collections are used. e.g. request.cookies(”CookiName”)(” UserName”)=”Mahesh”request.cookies(”CookiName”)(” UserID”...
2014-10-03, 1219👍, 0💬

Explain differences between ADO and DAO.
Explain differences between ADO and DAO. dao- can access only access database ado- can access any databases
2014-10-03, 1212👍, 0💬

What is State?
What is State? It is the property of the web forms. ASP.NET provides four types of state: Application state Session state Cookie state View state.
2014-10-01, 1196👍, 0💬

Name atleast two methods of response object other than Transfer.
Name atleast two methods of response object other than Transfer. a) Response.ClearContent( ) Clears the content of the current output stream. b) Response.ClearHeaders( ) Clears the HTTP headers from the current output stream.
2014-10-01, 1197👍, 0💬

Name atleast three methods of response object other than Redirect.
Name atleast three methods of response object other than Redirect. Answer1 a) Response.Clear( ) Clears the content of the current output stream. b) Response.Close( ) Closes the network socket for the current response. c) Response.End( ) Stops processing the current request and sends all buffered con...
2014-09-29, 1216👍, 0💬

What does Server.MapPath do?
What does Server.MapPath do? Answer1 srver.mappath() maps the path given in the argument to the server’s physical path. Answer2 It returns the complete(absolute) path of the file used in parameter. Answer3 It returns a string containing the physical path in the server’s file system that corresponds ...
2014-09-29, 1043👍, 0💬

Is there any inbuilt paging (for example shoping cart, which will show next 10 records without refreshing) in ASP? How will you
Is there any inbuilt paging (for example shoping cart, which will show next 10 records without refreshing) in ASP? How will you do pating? Use DataGrid control which has in-built paging features for the purpose.
2014-09-26, 1145👍, 0💬

Which DLL file is needed to be registered for ASP?
Which DLL file is needed to be registered for ASP? The dll needed for the ASP.net is SYSTEM.WEB.dll
2014-09-26, 1294👍, 0💬

How many objects are there in ASP?
How many objects are there in ASP? Answer1 8 objects, they are request,response, server,application,session,fil e,dictionary, textstream. Answer2 There are 6 objects in ASP.net a) Server b) Session c) Application d) ObjectContext e) Response f) Request
2014-09-24, 1270👍, 0💬

Specify the best ways to store variables so that we can access them in various pages of ASP.NET application?
Specify the best ways to store variables so that we can access them in various pages of ASP.NET application? Declare the variables in Global.aspx
2014-09-24, 1212👍, 0💬

What are the XML files that are important in developing an ASP.NET application?
What are the XML files that are important in developing an ASP.NET application? The XML file necessary for the for developing an asp.net application is Web.config
2014-09-22, 1362👍, 0💬

Explain similarities and differences between Java and.NET?
Explain similarities and differences between Java and.NET? Comparing Java and .NET is comparing apples and oranges. Either the question needs to be to compare Java and C# or J2EE and .NET.
2014-09-22, 1200👍, 0💬

How can you deploy an asp.net application ?
How can you deploy an asp.net application ? You can deploy an ASP.NET Web application using any one of the following three deployment options. a) Deployment using VS.NET installer b) Using the Copy Project option in VS .NET c) XCOPY Deployment
2014-09-19, 1268👍, 0💬

If there is a calendar control to be included in each page of your application, and and we do not intend to use the Microsoft-pr
If there is a calendar control to be included in each page of your application, and and we do not intend to use the Microsoft-provided calendar control, how do you develop it? Do you copy and paste the code into each and every page of your application? Create the Calendar User Control The control we...
2014-09-19, 1178👍, 0💬

SQL
How do you update 100 rows with single query with variable data populating each row ?
2014-09-19, 2014👍, 0💬

How do you separate business logic while creating an ASP.NET application?
How do you separate business logic while creating an ASP.NET application? There are two level of asp.net debugging 1. Page level debugging For this we have to edit the page level debugging enable the trace to true in the line in the html format of the page. %@ Page Language=”vb” trace=”true”AutoEve...
2014-09-17, 1279👍, 0💬

How do you define an integer in SQL Server?
How do you define an integer in SQL Server? We define integer in Sql server as var_name int
2014-09-17, 1140👍, 0💬

What is the maximum length of a varchar in SQL Server?
What is the maximum length of a varchar in SQL Server? Answer1 VARCHAR[(n)] Null-terminated Unicode character string of length n, with a maximum of 255 characters. If n is not supplied, then 1 is assumed. Answer2 8000 Answer3 The business logic is the aspx.cs or the aspx.vb where the code is being w...
2014-09-15, 1099👍, 0💬

How do you call and execute a Stored Procedure in.NET? Give an example.
How do you call and execute a Stored Procedure in.NET? Give an example. Answer1 ds1=new DataSet(); sqlCon1=new SqlConnection(connectionstring );String strCom1=”byroyalty”; sqlCom1=new SqlCommand(strCom1,sqlCon1); sqlCom1.CommandType=CommandTyp e.StoredProcedure;sqlDa1=new SqlDataAdapter(sqlCom1); Sq...
2014-09-15, 1105👍, 0💬

<< < 13 14 15 16 17 18 19 20 21 22 23 > >>   Sort: Rank