|
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
|
|
|
|
|
You have to add new values in one of tables which is included in view.
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.
|
|
|
|
|
that a strange question?
can you insert the 3 row in one single procedure or add more columns?
what are you trying to achieve?
nelsonpaixao@yahoo.com.br
trying to help & get help
|
|
|
|
|
I really think you need to review your requirements.
|
|
|
|