<div>
Thank You very much. Works like a charm!<br />
PS: Tks for being so fast!
</div>


Thank You very much. Works like a charm!
PS: Tks for being so fast!

<div>
I thing ginolatinao fails to select the way he accept the solution, its so clear that the solution I provided is correct and he accepted it.
</div>


I thing ginolatinao fails to select the way he accept the solution, its so clear that the solution I provided is correct and he accepted it.

<div>
<div class="content wysiwyg-content">
Experts,<br />
<br />
I have two tables. Table USERS with PK userid and the other is USERPROFILE with PK profileid Among other fields.<br />
I need one trigger for when inserting new users to USERS table the trigger creates <b>one record on USERPROFILE table with the value of userdId from users.</b>...<br />
<br />
Yes, simple but ! Sorry to bother. I need help cake doe!!
</div>
</div>


Experts,

I have two tables. Table USERS with PK userid and the other is USERPROFILE with PK profileid Among other fields.
I need one trigger for when inserting new users to USERS table the trigger creates one record on USERPROFILE table with the value of userdId from users....

Yes, simple but ! Sorry to bother. I need help cake doe!!

SQL Trigger for Insert

Microsoft SQL Server 2005 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. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.

Microsoft SQL Server 2005

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

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.