Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
trigger question
Hi all, Can i insert into a table from a view by using a trigger on the view. I have 3 tables which I join to create a view. Now i want to create one more table which has all the view columns and one additional new column. I was wondering if i can use an instead of trigger which will insert the...- vindi
- Thread
- Replies: 1
- Forum: Microsoft SQL Server: Programming
-
instead of trigger on a view
Thanks for your reply, I'll try to make things more clear, I have a lot of convoluted data which i need to JOIN from 3 tables to make a view, which is say V.(I said two tables before since i wanted to make it easier to explain). I decided to make a view so that whenever the tables are updated...- vindi
- Post #3
- Forum: Microsoft SQL Server: Programming
-
instead of trigger on a view
Hi all, I have a question about instead of trigger. I have a situation in which I have 2 tables A and B, and a view V which is derived from both these tables. Now I need to have a table T which, gets its values from the view V. However, since we can write only instead of triggers on views, and I...- vindi
- Thread
- Replies: 2
- Forum: Microsoft SQL Server: Programming
-
instead of trigger on a view
Thanks for your reply, I'll try to make things more clear, I have a lot of convoluted data which i need to JOIN from 3 tables to make a view, which is say V.(I said two tables before since i wanted to make it easier to explain). I decided to make a view so that whenever the tables are updated... -
instead of trigger on a view
Hi all, I have a question about instead of trigger. I have a situation in which I have 2 tables A and B, and a view V which is derived from both these tables. Now I need to have a table T which, gets its values from the view V. However, since we can write only instead of triggers on views, and I... -
dsn less connection problems
If i check out the listing in ODBC sources under administative tools in the control panel it says "SQL Server". Also the driver is SQLSRV32.dll which i think is correct. I even installed MDAC and it still doesnt work. I tried using the IP address of the server, along with the port... -
dsn less connection problems
Hi all, I'm trying to set up a dsnless connection to SQL Server using the following code use DBI; my $DSN = 'driver={SQL Server};Server=LAB135_20143;database=test;uid=xxx;pwd=xxx;'; my $dbh = DBI->connect('DBI:ODBC:$DSN') # quit if not able to connect or die "Fatal Error: Couldn't... -
accessing BIOS using PERL
Is there any way to access a computers BIOS over a network using PERL? I need to extract service tag information of computers from the BIOS. VB seems to be able to do it, I was wondering if Perl can too. Thanks -
accessing registry
Hi all, I have a small program that uses the Win32::TieRegistry module to access the registries of computers in the domain. My problem is I want to make this available on the web and its not working because the user does not have previleges. Is it possible to pass userid/password/domain... -
obtaining computer names from network
I am trying to use Perl to create a list of all the computers that are one the network. Is there any function available that I can use? Thanks.
