<div>
Do it in a transaction, so that either entire insert get successful or nothing will insert, No partial inserts. 
</div>


Do it in a transaction, so that either entire insert get successful or nothing will insert, No partial inserts.

<div>
i am using stored procduers
</div>


<div>
But, yes, if you have more than one INSERT statement in one batch, it could be possible that few INSERT statement works and later few wouldn't. in that case, transaction would be helpful
</div>


But, yes, if you have more than one INSERT statement in one batch, it could be possible that few INSERT statement works and later few wouldn't. in that case, transaction would be helpful

<div>
how can i prevent that in stored procedures?<br />
<br />
on a insert statement.
</div>


how can i prevent that in stored procedures?

on a insert statement.

<div>
how do i do a transaction in a stored procedure?
</div>


how do i do a transaction in a stored procedure?

<div>
see this link:<br />
<br />
<a href="http://www.4guysfromrolla.com/webtech/080305-1.shtml" rel="ugc">http://www.4guysfromrolla.com/webtech/080305-1.shtml</a>
</div>


see this link:

http://www.4guysfromrolla.com/webtech/080305-1.shtml [http://www.4guysfromrolla.com/webtech/080305-1.shtml]

<div>
this can be helpful too<br />
<a href="http://blog.sqlauthority.com/2010/06/02/sql-server-stored-procedure-and-transactions/" rel="ugc">http://blog.sqlauthority.c<wbr />om/2010/06<wbr />/02/sql-se<wbr />rver-store<wbr />d-procedur<wbr />e-and-tran<wbr />sactions/</a>
</div>


this can be helpful too
http://blog.sqlauthority.com/2010/06/02/sql-server-stored-procedure-and-transactions/ [http://blog.sqlauthority.com/2010/06/02/sql-server-stored-procedure-and-transactions/]

<div>
<div class="content wysiwyg-content">
Hey guys, i have an mdf database and want to know what happens if i insert into a database and the internet cuts off?<br />
<br />
the half the information be entered?<br />
<br />
or do i need to write a trigger to rollback my transaction?<br />
<br />
i am using sql 2008 server where my database is kept.
</div>
</div>


Hey guys, i have an mdf database and want to know what happens if i insert into a database and the internet cuts off?

the half the information be entered?

or do i need to write a trigger to rollback my transaction?

i am using sql 2008 server where my database is kept.

database

The successor to Active Server Pages, ASP.NET websites utilize the .NET framework to produce dynamic, data and content-driven web applications and services. ASP.NET code can be written using any .NET supported language. As of 2009, ASP.NET can also apply the Model-View-Controller (MVC) pattern to web applications

ASP.NET

Microsoft SQL Server 2008 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. Major improvements include the  Always On technologies and support for unstructured data types.

Microsoft SQL Server 2008

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.