how we can store the value like that 001,003,023 etc in sql
server 2005
Answer Posted / nadeem
create table t(NUM int(22))
insert into t values(001)
insert into t values(002)
insert into t values(023)
Is This Answer Correct ? | 1 Yes | 9 No |
Post New Answer View All Answers
Explain comment on transactions?
how many clustered indexes can be created on a table? : Sql server database administration
What is coalesce and check constraint in sql server?
How to find out the list schema name and table name for the database?
Define indexes?
What does null mean?
How to connect to SQL Azure Database by using sqlcmd?
How to add additional conditions in SQL?
Which Model uses the SET concept
When would you use an insert into .. Select option versus an insert into .. Values option? Give an example of each?
You have a table ‘test’ which is a copy of northwind employee table you have written a trigger to update the field ‘hiredate’ with the current date
What are the advantages of using stored procedures in sql server?
How to test odbc dsn connection settings?
When would you use it?
Explain about analysis services?