How do I lock a column, once records are entered into the table they can not be edited. Also how can I lock the field where only certain values are accepted?
Latest Answer : May be you can use Constraints. ...
What is 'no lock' term in SQL, like "select * from table a (no lock)". What is its purpose?
Latest Answer : Define: By default select puts exclusive lock. Specifying no lock puts no lock on the table.Advantage: Improve the peformanceDisadvantage: Dirty reads Suggestion: Use in static table data (with fewer DML operations) ...
SQL Server 2005 Integration Services Review | |
SQL Server 2005 Integration Services using Visual Studio 2005 A Beginner s Guide SQL Server 2005 A offering of Microsoft Corporation for database management the SQL server 2005 is one of the powerful database management systems in the world Available for integration in almost any system that uses Mi
|
|
SQL Server Integration Services | |
SQL Server Integration Services Here is a sample chapter from Beginners Guide to SQL Server Integration Services Using Visual Studio 2005 by Jayaram Krishnaswamy Environment set up for Visual Studio 2005 with respect to SSIS and multiple tasking Connecting to Microsoft Access Text Files Excel S
|
|
Web Server | |
Web Server A web server can be a program or the computer itself which receives the requests from various other browsers and responds to those requests These requests are all requests that are being sent for some documents There are two kinds of web servers available The web server program and the
|
|
Client-Server Models and N-Tier Applications | |
Client Server Models and N Tier Applications One of principal objective of Client Server methods is to provide data to an end user However Client Server architectural methodologies are much more complex Client Server describes the process wherein a client program generates contact with a separate se
|
|
Java and Client Server Models | |
Java and Client Server Models The Role of Client Servers on the Web Client server models provide the essential mechanisms for working with the Internet In fact most of the World Wide Web is built according to this paradigm In client server models the web browsers run by millions of users are the cli
|
|
Web Services and Client Server Technology | |
Web Services and Client Server Technology Introduction to Distributed Computing The Internet and expanded network connectivity established client sever models as the preferred form of distributed computing When talking about Client Server models of networked communication using web services the broa
|
|
Object-Oriented Client-Server Internet | |
Object Oriented Client Server Internet OCSI Environments as IT Infrastructure Client Server Basics Object Oriented Client Server Internet OCSI environments provide the IT infrastructure for supporting OCSI applications For our purposes infrastructure refers to operating systems networks middleware
|
|
N-Tier Client-Server Architecture | |
N Tier Client Server Architecture Description of 1 Tier and 2 Tier Web Applications This article will discuss the various architectures of Client Server environments Perhaps the most influential Client Server environment is the Internet and its global users With the increasing use of web application
|
|
Language Enhancements in SQL Server 2005 | |
The T-SQL has been enhanced to include error handling, recursive query and to support the new database engine capabilities.
Two new relational operators have been introduced—PIVOT and UNPIVOT for use in the FORM clause query. They perform manipulation on an input table valued expression an
|
|
Security enhancements in SQL Server 2005 | |
The trustworthy computing initiative has contributed greatly to help microsoft improve customer experience. A number of customer needs on security have been addressed.
1. Restricting user access to sql server
2. Disabling services and restricting service configuration
3. Reducing the surface are aof
|
|
|
