|
hey its ok the stored procedure works
|
|
|
|
|
Hello everyone,
I need ur help to write a trigger. I have 3 tables (Ex: Employee master,Employee salary details and Employee in_out details),if i update any value in the Employee master table, the value must be automatically updated in other related tables.
Plzzzzzzzzzz help urgent!!!!!!
Thanks.
|
|
|
|
|
Jesu Prabhu.J wrote: Plzzzzzzzzzz help urgent!!!!!!
Not, its not urgent.
Jesu Prabhu.J wrote: I need ur help to write a trigger.
So write your version and if it doesn't work post it and someone will help. A clue, you need a trigger on Employee for insert and update which will select the values from the inserted table and update the other two tables.
There you go, now google triggers.
Bob
Ashfield Consultants Ltd
|
|
|
|
|
I am using SQL Server 2000, If i change any value Ex: Employee Name in the (Employee Master) the value Employee Name must get updated in the other 2 tables..
Thanks for the Reply..
|
|
|
|
|
Jesu Prabhu.J wrote: I am using SQL Server 2000, If i change any value Ex: Employee Name in the (Employee Master) the value Employee Name must get updated in the other 2 tables..
Yes, I assumed you were using SQL Server. You still need a trigger on Employee Master. There are hundreds of examples on Google.
Bob
Ashfield Consultants Ltd
|
|
|
|
|
Plzzzzzz help me out with this problem, i have to store special symbols like integral, sigma, pi etc in tha database. I'm using the nvarchar datatype, but getting unexpected results..
Thanks in advance...........
|
|
|
|
|
I think using nvarchar should be sufficient.
Although you'll not be able to see these characters in 'Query Analyzer' or 'Enterprise Manager' (you will see boxes instead) but when this data is called by client application e.g. C# you can see correct depiction of the character.
Razov
|
|
|
|
|
I am viewing these values in a rich textbox, but it displays ?? when the application is run.I'm using VB.net 2008
|
|
|
|
|
Is your VB.NET project Unicode enabled?
Razov
|
|
|
|
|
How do one check if VB.net project is Unicaode enabled, Plzzzz help..
|
|
|
|
|
Click Advanced Save Options Encoding should be Unicode (UTF-8).
Razov
|
|
|
|
|
Firstly i thank u,for the help. Again i am facing the problem, there is no Advanced Save Options under the File menu...
|
|
|
|
|
Try Save As option for solution there you can check for Encoding option.
Razov
|
|
|
|
|
Thanks a ton, for ur timely help. Looking forward for your help in future also...
Bye n Thanks once more..
modified on Tuesday, September 16, 2008 6:30 AM
|
|
|
|
|
Hello
I've inserted many records while testing and now I want to start indentity column from 1.
How can it be possible??
Please Reply,
Thanks
Syed Shahid Hussain
|
|
|
|
|
I believe if you truncate the table that will do it.
Bob
Ashfield Consultants Ltd
|
|
|
|
|
<br />
DBCC CHECIDENT (tablename, RESEED, 0)
I Love T-SQL
"Don't torture yourself,let the life to do it for you."
If my post helps you kindly save my time by voting my post.
|
|
|
|
|
Thanks But
I'd tried (test is table name)
DBCC CHECIDENT (test, RESEED, 0)
and also
DBCC CHECIDENT ('test', RESEED, 0)
And receive this error message
Server: Msg 2526, Level 16, State 2, Line 2
Incorrect DBCC statement. Check the documentation for the correct DBCC syntax and options.
have u any idea about that?
Thanks
Syed Shahid Hussain
|
|
|
|
|
My apologize it iwas my write mistake,the syntax is: DBCC CHECKIDENT (tablename, RESEED, 0)
I Love T-SQL
"Don't torture yourself,let the life to do it for you."
If my post helps you kindly save my time by voting my post.
|
|
|
|
|
|
Never mind dude,I am glad that worked for you.
I Love T-SQL
"Don't torture yourself,let the life to do it for you."
If my post helps you kindly save my time by voting my post.
|
|
|
|
|
don´t worry with that let it be
nelsonpaixao@yahoo.com.br
trying to help & get help
|
|
|
|
|
hi all....
what is the difference between truncate and Delete...I have used following code but both are rollback....if anybody knows please reply me..
BEGIN TRANSACTION;
delete from one
rollback TRANSACTION
BEGIN TRANSACTION;
Truncate table one
rollback TRANSACTION
Thanks
Raaj
|
|
|
|
|
|
i have view with 2 columns name and salary i want to add a new column with id name the value of this column will changed every 3 rows one time
Example:
id name salary
1 ma 500
1 hh 300
1 uu 200
2 ff 100
2 rr 500
2 tt 111
3 re 333
---
--
-
thank you for help
|
|
|
|