Software Applications Programming Errors and solutions.

- 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