|
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![Rose | [Rose]](https://codeproject.freetls.fastly.net/script/Forums/Images/rose.gif) 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.
|
|
|
|
|
Not enough experience to know a really silly request when it turns up. God knows what the real business requirement is?
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
well, let's hope they get better with time.
|
|
|
|
|
For whatever reason, you could do the following...
select ceiling(cast(row_number() over (order by [field] asc) as float) / 3) as id, *
from [table]
Ryan
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
Oh! Now It works Goooooooooooooooooooooooooooooooooood.
![Rose | [Rose]](https://codeproject.global.ssl.fastly.net/script/Forums/Images/rose.gif)
