Database

How to store symbols like sigma, integral etc in sql server 2000

14-Sep-08 22:34

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..

Re: Sql Update Trigger

Ashfield14-Sep-08 23:10

Ashfield

14-Sep-08 23:10

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

Jesu Prabhu.J14-Sep-08 20:49

Re: How to store symbols like sigma, integral etc in sql server 2000

14-Sep-08 20:49

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...........

razov15-Sep-08 0:32

Re: How to store symbols like sigma, integral etc in sql server 2000

15-Sep-08 0:32

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

Jesu Prabhu.J15-Sep-08 0:38

Re: How to store symbols like sigma, integral etc in sql server 2000

15-Sep-08 0:38

I am viewing these values in a rich textbox, but it displays ?? when the application is run.I'm using VB.net 2008

razov15-Sep-08 17:47

Re: How to store symbols like sigma, integral etc in sql server 2000

15-Sep-08 17:47

Is your VB.NET project Unicode enabled?

Razov

Jesu Prabhu.J15-Sep-08 18:11

Re: How to store symbols like sigma, integral etc in sql server 2000

15-Sep-08 18:11

How do one check if VB.net project is Unicaode enabled, Plzzzz help..

razov15-Sep-08 19:00

Re: How to store symbols like sigma, integral etc in sql server 2000

15-Sep-08 19:00

Click Advanced Save Options Encoding should be Unicode (UTF-8).

Razov

Jesu Prabhu.J15-Sep-08 19:17

Re: How to store symbols like sigma, integral etc in sql server 2000

15-Sep-08 19:17

Firstly i thank u,for the help. Again i am facing the problem, there is no Advanced Save Options under the File menu...

razov16-Sep-08 0:11

Re: How to store symbols like sigma, integral etc in sql server 2000 [modified]

16-Sep-08 0:11

Try Save As option for solution there you can check for Encoding option.

Razov

Jesu Prabhu.J16-Sep-08 0:19

16-Sep-08 0:19

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

Indentity Problem

Syed Shahid Hussain14-Sep-08 20:44

Syed Shahid Hussain

14-Sep-08 20:44

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 Smile | :)

Syed Shahid Hussain

Ashfield14-Sep-08 20:56

Ashfield

14-Sep-08 20:56

I believe if you truncate the table that will do it.

Bob
Ashfield Consultants Ltd

Blue_Boy14-Sep-08 22:00

14-Sep-08 22:00

<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.

Syed Shahid Hussain14-Sep-08 22:55

Syed Shahid Hussain

14-Sep-08 22:55

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

Blue_Boy14-Sep-08 23:27

14-Sep-08 23:27

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.

Syed Shahid Hussain15-Sep-08 1:22

Syed Shahid Hussain

15-Sep-08 1:22

Oh! Now It works Goooooooooooooooooooooooooooooooooood.
I'm Happy Man. Laugh | :laugh:

Really Thanks. Rose | [Rose]

Syed Shahid Hussain

Blue_Boy15-Sep-08 1:24

15-Sep-08 1:24

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.

Difference between Truncate and Delete

nelsonpaixao15-Sep-08 12:12

nelsonpaixao

15-Sep-08 12:12

don´t worry with that Rose | [Rose]

let it be

nelsonpaixao@yahoo.com.br

trying to help & get help

r aa j14-Sep-08 19:57

r aa j

14-Sep-08 19:57

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

Re: Difference between Truncate and Delete

Blue_Boy14-Sep-08 21:59

edit view by adding squence number

14-Sep-08 21:59

Difference between Truncate and Delete[^]

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.

mahmoudinirat14-Sep-08 2:12

mahmoudinirat

14-Sep-08 2:12

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

Re: edit view by adding squence number

Blue_Boy14-Sep-08 2:49