 |  |  |  |  |  |  |  |
Loops in Sql Server Triggers and Stored Procedures
Please support our ASP.NET advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases
 |
Hi all
I am here again ,and this time i returned back and with my hand a problem in SQL server not in asp.net .
The problem is the following :
I wish if some one can help me .
Thank you very much
I am here again ,and this time i returned back and with my hand a problem in SQL server not in asp.net .
The problem is the following :
- I am in a project that contains a table of users(user_tbl) and another table of groups(Group_tbl) . and each group can contains multi-user by Group_Id which is foreign key in user_tbl .
- I am now about creating a trigger that happens when inserting in permissions_tbl (contains users and group permissions) . It should insert all users of the inserted group into the permissions_tbl also with the same values the group taked.
- So , I need Loops very much to loop in the user_tbl and get the users of the inserted group then insert them in the permissions_tbl .
I wish if some one can help me .
Thank you very much
Life Is A Big Code
Rushdy Ibrahim
Egypt
Rushdy Ibrahim
Egypt
|
Similar Threads
- Freelance .NET / MS SQL developer (Web Development Job Offers)
- SQL Server DBA (Software Development Job Offers)
- Connecting to a SQL Server Database using VB (VB.NET)
- Triggers Loop or Stored Procedures Loop (MS SQL)
- Saving information from .NET Listbox into SQL Server 2000 (ASP.NET)
- Ms Sql Server 2000 (MS SQL)
- Simple ASP.Net Login Page (Using VB.Net) (ASP.NET)
- SQL Server vs MYSQL vs MSQL (i'm stopping now) (MS SQL)
Other Threads in the ASP.NET Forum
- Previous Thread: Help Writng and reading cookie
- Next Thread: My Visual Studio.NET won't open ASP.NET projects
Views: 15613 | Replies: 1
| Thread Tools | Search this Thread |
Latest ASP.NET Posts
- Today's Posts
- Unanswered Threads
Related Forum Features
Tag cloud for ASP.NET
.net 2.0 3.5 ajax appliances application asp asp.net beginner box browser businesslogiclayer button c# cac chat checkbox child class compatible complex content contenttype control countryselector courier database datagrid datagridview datalist deployment development dgv dialog dropdown dropdownmenu dynamic dynamically edit embeddingactivexcontrol feedback fileuploader fill findcontrol flash flv folder form gridview gudi identity iis image javascript languages list maps menu mobile mssql nameisnotdeclared novell opera order problem profile ratings redirect refer registration relationaldatabases response.redirect rows search security select serializesmo.table sessionvariables silverlight smoobjects software sql ssl tracking treeview typeof validatedate validation vb vb.net vista visual-studio visualstudio vs2008 web webapplications webarchitecture webdevelopment wizard xsl
