Database

<br />
create trigger mytrigger on tableone for insert as<br />
begin -- trigger<br />
<br />
declare<br />
@ptr int, -- your loop variable<br />
@code char -- what to insert each time<br />
<br />
-- probably can combine the next two lines if clever<br />
select @code = code from inserted<br />
select @ptr = numstart from inserted<br />
<br />
while @ptr <= (select numend from inserted)<br />
begin -- while<br />
<br />
-- consider a select .. into instead of next<br />
insert into tabletwo (num, code) values (@ptr, @code)<br />
select @ptr = @ptr + 1<br />
<br />
end -- while<br />
<br />
end -- trigger<br />

Mohammed Amine wrote:

because the default relashion gave me 1,n

using System.Data;
using System.Data.SqlClient;

SqlConnection conn = new  SqlConnection();
conn.ConnectionString = "Data Source=(local);Initial Catalog=master;Integrated Security=SSPI";
conn.Open();

SqlCommand myCommand = conn.CreateCommand();
myCommand.CommandText = "EXEC sp_attach_db @dbname = 'ATestDB',@filename1 = 'C:\\TestPath\\ATestDB_Data.MDF',@filename2 = 'C:\\TestPath\\ATestDB_Log.LDF'";
myCommand.ExecuteScalar();

Imports System.Data
Imports System.Data.SqlClient

Dim conn As New SqlConnection
Dim myCommand As SqlCommand

conn.ConnectionString = "Data Source=(local);Initial Catalog=master;Integrated Security=SSPI"
conn.Open()

myCommand = conn.CreateCommand()
myCommand.CommandText = "CREATE DATABASE [ATestDB] ON (FILENAME = 'C:\TestPath\ATestDB_Data.MDF'), (FILENAME = 'C:\TestPath\ATestDB_Log.LDF') FOR ATTACH"

myCommand.ExecuteScalar()