Hi friends,
I have implemented a trigger for keeping a check whether the PLNo is 8 digits everytime the table is updated or inserted
It works well for insertion but while updation it creates the following problem: When i update a PLNo 12345678 to 1234567 it shows error message as it should do but when i again update it to 12345678 it still shows the error message even if the PLNo is 8 digits
CREATE TRIGGER...
nairdeepthi2000
Last Activity: May 19 '07, 03:49 PM
Joined: Apr 12 '07
Location:
-
Trigger problem while updating
-
Triggers
Hi friends
I am trying to use triggers in sql server 2000 with VB.Net...but am ending up with lot of syntax errors
I want to keep check in a table whenever a row is inserted that its two fields Nominee1 and Nominee2 dont be same...can i use triggers for this purpose
If someone can kindly tell me the syntax of creating triggers or any tutorials for the same in sql server 2000 I will be very than... -
How to copy a sql server database to disk
Hi friends
I want to copy a sql server database to my pendrive but i am not able to just copy paste it, I m using sql server first time so have no idea about it
Pleez help me out -
Problem in creating Crystal reports
Hello friends,
I m stuck up with crystal reports. I have used crystal report viewer , but when I run it , i am asked database login , I have used Windows Integrated security what userid and password should I supply
Kindly help me out -
Problem in creating Crystal reports
Hello friends,
I am creating crystal reports, I have used a crystal report viewer, but when i run it , i am asked the database login, I have set the windows NT Integrated security,so what userID and Password i should supply?
Kindly help me out -
Hi,
If learning joins is the thing to make it into seperate tables , I have used joins in my tables like a table transcPerMember joining transaction details and Member details.
But i am worried about the redundancy.
Can u pleez tell me , If i go with multiple tables i will have same Mem_ID repeating in all of them then how wont i end up with redundancy.... -
Hi
Thank u so much, u were a great help...Leave a comment:
-
Hi ,
Thank u friend for ur response
Yes I m recording history of member name changes, address changes, loan details by storing the old report files.
And can u pleez tell me how can I end up with duplicated data if I go with a single table...Leave a comment:
-
Null value
Hi
I have a database for a credit society which gives loans in that there are 2 fields for a Member table , loan amount taken and guarantor alongwith the other fields like age,address etc .
A person may just be a member and may have not taken any loan yet , so i have kept loan amount as NULL , but when a person takes a loan he must have a guarantor . But if I dont keep the guarantor field as NULL it will... -
hi
If i dont club the data n 1 table and create different tables for each like address details, nominee details , transaction details etc with Member_ID as PK will t giv rise to redundant data with the same Member_ID repeating?
Kindly reply as soon as possible, it would be a great helpLeave a comment:
-
hi dear friend
thank u so much for ur response it was really helpful
In my case a person can take a loan only f he has refunded his previous loan so no question of multiple loans arises , and in each type of details there is only a single record for each Member_ID eg nominee details there are 2 nominees for each member so i have taken t as nominee1 , nominee2 for each Member_ID and at the end of each month a transaction...Leave a comment:
-
Many tables or a big table with views
Hi ,
I have some data of members of a credit society, like address details,nominee details,loan(if taken) details etc,now i m confused whether put all these data in same table with a ID as PK and create views to access different data (eg address) or create different tables like address details , nominee details and so with the member ID as PK , which would be better and why
pleez help me out
No activity results to display
Leave a comment: