Thanks let me try it. definite you are right...

Hello,

First thanks for reply my post....

In this case I can add only data which was inserted in table b , while the foreign key of that table , must...

Hello,

I need to create trigger which allow to insert primary key in main automatically when inserted to it and then automatically inserted in child table

create trigger trg_Eng_Edu_Details on dbo.Eng_Edu_Details

declare

Hello David,

Using your code My Problem was sloved, Thanks for It.

I have another issues. I have one parent table that is Eng_Details and one child table that is ...

How to do it?

Can you give any sample code for it?

I have create a trigger... but it is not working let me know how to do it?

create trigger tgr_change_master_Date on dbo.Eng_Education_Details

for update a

set Curr_Date=GetDate()

from dbo.Engineers_Details a

inner join inserted i

on a.Eng_id=i.Eng_Id

.....

When...

Hello,

When I create table as per code data is inserted in first successfully as ENG_REF value Engg0000000000 but when i insert in second row it showing an error message "Can...

Hello,

I have made changes in trigger and now it will allow to increase the number more then hundrade even up to more then million.

Thanks for giving your suggestion... Have a...

but i need this value can gone upto 4-5 million times, so can take datatype varchar(50) to varchar(max), then might it will allow me to enter increased the value of...

First thanks for giving your valuable time. I am near the solution.

The data was increased value properly. but when I enter name in a table. It show a message transaction...

Hello ,

I have create a table in SQL Server 2008 and create a filed name eng_ref as varchar and set the default value as Engg.

The structure of the file is...

Hello ,

I have create table Test table with primary key id test_Id and auto increment when inserting a record in a table, then i add another field with name of...

You are right ...

if i remove a primary key from this field, but my question is is there any script which can increase the value of this filed by 1...

hello you are right,

when insert a new recordand press tab to new rows then StudentID is automatically changed from null to 2 for 2nd record.

Many many thanks for giving...

Hello,

I have already set the identity as Yes and increse the value by 1. So when I enter a new record there it shows null as in StudentID not showing...