Web form is nothing but normal .aspx page. When you create web form you see all tags such as <head>,
<body>, <html> etc.
Master page is nothing but a common page which holds a common content so that you can use it across
multiple pages. That means if you want to display menu on 3-4 pages, you can write the code into
master page and use it on all pages. This way you don’t have to write same code again and again on all
3-4 pages.
This is also another type of form which exists with master page, Basically content page is the page which
holds un-common content where master page contains common content among lets say 3-4 pages. You
get <asp:content> tag in this type of paSoolutiom In a normal website, you create a content page by
ticking the “Select Masterpage” checkbox when adding a page. For Web Application Projects, you need
to select Web Content Form to create a content page and a Web Form to add a normal (no masterpage)
page
1. In a normal website, you create a content page by ticking the “Select Masterpage” checkbox when
adding a page. For Web Application Projects, you need to select Web Content Form to create a content
page and a Web Form to add a normal (no masterpage) page..
2. Web content is the textual, visual or aural content that is encountered as part of the user
experience on websites.It may include, among other things: text, images, sounds, videos and
animations.
Stay Tune...
Have a nice day... 'N happy Coding :)
Sunday, May 15, 2011
Friday, May 13, 2011
using locks inside stored procedure
Microsoft® SQL Server™ 2000 uses locking to ensure transactional integrity and database consistency. Locking prevents users from reading data being changed by other users, and prevents multiple users from changing the same data at the same time. If locking is not used, data within the database may become logically incorrect, and queries executed against that data may produce unexpected results.
Lock mode Description. There are six different type of locks given below:
Shared (S) Used for operations that do not change or update data (read-only operations), such as a SELECT statement.
Update (U) Used on resources that can be updated. Prevents a common form of deadlock that occurs when multiple sessions are reading, locking, and potentially updating resources later.
Exclusive (X) Used for data-modification operations, such as INSERT, UPDATE, or DELETE. Ensures that multiple updates cannot be made to the same resource at the same time.
Intent Used to establish a lock hierarchy. The types of intent locks are: intent shared (IS), intent exclusive (IX), and shared with intent exclusive (SIX).
Schema Used when an operation dependent on the schema of a table is executing. The types of schema locks are: schema modification (Sch-M) and schema stability (Sch-S).
Bulk Update (BU) Used when bulk-copying data into a table and the TABLOCK hint is specified.
Lock mode Description. There are six different type of locks given below:
Shared (S) Used for operations that do not change or update data (read-only operations), such as a SELECT statement.
Update (U) Used on resources that can be updated. Prevents a common form of deadlock that occurs when multiple sessions are reading, locking, and potentially updating resources later.
Exclusive (X) Used for data-modification operations, such as INSERT, UPDATE, or DELETE. Ensures that multiple updates cannot be made to the same resource at the same time.
Intent Used to establish a lock hierarchy. The types of intent locks are: intent shared (IS), intent exclusive (IX), and shared with intent exclusive (SIX).
Schema Used when an operation dependent on the schema of a table is executing. The types of schema locks are: schema modification (Sch-M) and schema stability (Sch-S).
Bulk Update (BU) Used when bulk-copying data into a table and the TABLOCK hint is specified.
Have a nice day... 'N happy Coding :)
Wednesday, May 11, 2011
Difference between TRUNCATE & DELETE in SQL
Difference Between DELETE & TRUNCATE Are
1. DELETE is a DML Command & TRUNCATE is a DDL Command
2. After DELETE can rollback the Records & After TRUNATE cannot rollback the records
3. In DELETE Command you can give the conditions in WHERE Clause & In TRUNCATE you cannot give conditions
4. After using DELETE Command The memory will be occupied till the user does not give ROLLBACK or COMMIT & After using TRUNCATE Command The memory realeased immediately
Have a nice day... 'N happy Coding :)
Subscribe to:
Posts (Atom)