Software Applications Programming Errors and solutions.

System- Provides base data types and almost 100 classes that deal with situations like exception handling, mathematical functions, and garbage collection. System.CodeDom Provides the classes needed to produce source files in all the .NET languages. System.Collections Provides access to collection classes such as lists, queues, bit arrays, hash tables, and dictionaries. System.ComponentModel Provides classes that are used to implement runtime and design-time behaviors of components and controls. System.Configuration Provides classes and interfaces that allow you to programmatically access the various configuration files that are on your system, such as the web.config and the machine.config files. System.Data Provides classes that allow data access and manipulation to SQL Server and OleDb data sources.These classes make up the ADO.NET architecture. System.Diagnostics Provides classes that allow you to debug and trace your application. There are classes to interact with event logs, perfo

- Drag and Drop design - IntelliSense features - Syntax highlighting and auto-syntax checking - Excellent debugging tools - Integration with version control software such as Visual Source Safe (VSS) - Easy project management

Following list will give you an idea about various types of application that You can develop on .NET. 1. ASP.NET Web applications: These include dynamic and data driven browser based applications. 2. Windows Form based applications: These refer to traditional rich client applications. 3. Console applications: These refer to traditional DOS kind of applications like batch scripts. 4. Component Libraries: This refers to components that typically encapsulate some business logic. 5. Windows Custom Controls: As with traditional ActiveX controls, you can develop your own windows controls. 6. Web Custom Controls: The concept of custom controls can be extended to web applications allowing code reuse and modularization. 7. Web services: They are “web callable” functionality available via industry standards like HTTP, XML and SOAP. 8. Windows Services: They refer to applications that run as services in the background. They can be configured to start automatically when the system boots up.

sql aptitude questions and answers sqlauthority sql aggregat functions sql basic sql books sql commands sql cursor sql certification sql developer sql download sql dba sql express 2008 r2 sql examples sql formatter sql functions sql full form sql fiddle sql group by having sql get date sql guide sql helper class sql history sql interview questions and answers sql injection sql join sql keys sql keywords sql kill porcess sql knowledge sql loader sql like sql language sql managment stuido 2008,2012 sql means sql notes sql not in sql netowrk interfaces error 26 sql notes pdf sql online test sql order by sql operators sql plus download sql pdf sql profiler sql queries pdf,examples sql rowcount sql replace sql reporting services sql rank sql server 2008 sql tutorial pdf sql update sql union query sql unique sql version sql views sql vulnerable sites sql vs mysql sql w3schools sql wiki sql where sql workbench sql xml path,query,x

To get details of protocols used in current connection in sql server you can execute following select query . You could know about Shared Memory,TCP/IP,Named Pipes,VIA (Virtual Interface Adaptor) on using below query. SELECT session_id,connection_id, connect_time, net_transport, net_packet_size, client_net_address FROM sys.dm_exec_connections

To Get total number of processor and processor type  sql server contains you need to write this simple query or need to execute sp xp_msver. exec xp_msver 'processorcount', 'processortype'

To update multiple column values in single shot query in sql you can take help from below query. UPDATE TestTable SET (Col1, Col2, Col3, Col4) = (SELECT a, b, c, d FROM TestTable2 WHERE id =TestTable.Col5)

1. Enabling a disabled log in The following example enables the login  for user name is TestUser5. ALTER LOGIN TestUser5 ENABLE; 2. Changing the password of a login for User TestUser5 The following example changes the password of login TestUser5 to a strong password. ALTER LOGIN TestUser5 WITH PASSWORD = '<enterStrongPasswordHere>'; 3. Changing the name of a login  for user TestUser5 The following example changes the name of login TestUser5 to Abc2. ALTER LOGIN TestUser5 WITH NAME = Abc2; 4. Mapping a login to a credential The following example maps the login Abc2 to the credential Custodian04. ALTER LOGIN Abc2 WITH CREDENTIAL = abc04; 5. Mapping a login to an Extensible Key Management credential The following example maps the login TestUser5 to the EKM credential EKMProvider1. ALTER LOGIN TestUser5 ADD CREDENTIAL EKMProvider1; GO 6. Unlocking a login for user TestUser5 To unlock a SQL Server login, execute the following statement, replacing **** with the desired account

sp_helptext is sql command which gives code help for any type of sql object like stored procedure, views, functions, triggers,tables etc. It will display object information to help you know about sql object. sp_helptext vw_Testing_sp_helptext

Normally you can not create index on view but if You bind schema of base table with view then you can create index on view. To do that first you need to drop existing view then recreate that view with schema binding option. DROP VIEW view TestView CREATE VIEW TestView WITH SCHEMABINDING AS SELECT Id,Name,,Address,Phone,Fax,Email FROM dbo.tableName

To Display current database in sql by select query  you can try following query in sql query editor. SELECT DB_NAME() AS DatabaseName, DB_ID() DataBaseID

If you want know version details for SQL server then you can execute following select query in sql query editor. SELECT @@VERSION AS [Version]

If you are getting following error on restoring database in sql . Error 3154: The backup set holds a backup of a database other than the existing database. Then you can try following line of code to restore database from query editor RESTORE DATABASE TestDb FROM DISK = 'E:\TestDb.bak' WITH REPLACE Second thing is if you do not want to use T-SQL then you need to selection overwrite the existing databse(With replace) option  on restoring database from SSMS

Delete database,table,table data,index in sql by query analyzer 1. To delete all data from table . TRUNCATE TABLE tablename 2. Delete database through query analyzer DROP DATABASE databasename 3. Delete table in sql DROP TABLE tablename 4. Delete index from table in sql. DROP INDEX tablename.indexname To create database in sql you can use following command in sql query analyzer. Create Database in SQL CREATE DATABASE databaseName; Second way is you can right click by mouse and select create new database then set name of database in sql prompt.

o Conduct implementation Gap analysis at the client site(s) o Develop modules; build verticals for the Microsoft Dynamics AX 2009 and 2012 o Integrate Microsoft Dynamics AX installation with legacy data and or systems o Facilitate all required Testing of customized MS Dynamics AX o Participate in the improvement of the implementation processes. o Support/ Conduct Installation at designated site(s) o Manage the user requirements for agreed customization(s) o Manage the agreed change management process with the client(s) o Support the implementation of different modules at the client site o Provide technical support to the end users during the phase before going live o Provide on-the-job training to end users according to agreed requirements.

To enable to  access shared folder to VPC you can try below steps. 1. VPC ->Edit -> Settings-> Shared folders -> browse the location 2. If shared folder is disable then you can install all update virtual machine to enable your folder.