how we can store the value like that 001,003,023 etc in sql
server 2005
- 7 Answers
- 9751 Views
- I also Faced
- E-Mail Answers
Answer Posted / mohammad saddam
CREATE TABLE NumAsVar (Num nvarchar(50))
INSERT INTO NumAsVar VALUES ('001')
INSERT INTO NumAsVar VALUES ('002')
INSERT INTO NumAsVar VALUES ('021')
| Is This Answer Correct ? | 5 Yes | 1 No |
Post New Answer View All Answers
How to connect php with different port numbers?
What is standby servers? Explain types of standby servers.
Is it possible to have clustered index on separate drive from original table location?
What is a coalesce function?
What are the properties of the transaction?
List out the different types of locks available in sql server?
How can I check that whether automatic statistic update is enabled or not?
You have a stored procedure, which execute a lengthy batch job. This stored procedure is called from a trigger you do not want to slow the data entry process you do not want trigger to wait for this batch job to finish before it completes itself what you can do to speed up the process?
Disadvantages of the indexes?
explain different types of backups avaialabe in sql server? Given a particular scenario, how would you go about choosing a backup plan? : Sql server database administration
How to enter binary string literals in ms sql server?
Why and when do stored procedure recompile?
Explain “row_number()” in sql server with an example?
If you're given a raw data table, how would perform etl (extract, transform, load) with sql to obtain the data in a desired format?
Can we shrink data file in sql server?
