Interested to Buy Any Domain ? << Click Here >> for more details...
how we can store the value like that 001,003,023 etc in sql
server 2005
- 7 Answers
- 9358 Views
- I also Faced
- E-Mail Answers
Answer Posted / sathish kondaveeti
create table value(num int(3))
insert into value values(001)
insert into value values(003)
insert into value values(023)
to see this table
select * from value
| Is This Answer Correct ? | 0 Yes | 10 No |
Post New Answer View All Answers
How can we call UDF(User Define Function) using C# code in ASP.net ?
How can you fetch alternate records from a table?
What are the advantages of using a stored procedure?
How to create a dynamic cursor with the dynamic option?
What is merge statement?
what are statistics, under what circumstances they go out of date, how do you update them? : Sql server database administration
How to create new tables with "select ... Into" statements in ms sql server?
what protocol both networks use? : Sql server database administration
Can you explain how long are locks retained within the repeatable_read and serializable isolation levels, during a read operation with row-level locking?
What is exporting utility?
sql database suspect We have a sql database that is showing as suspect. How can we recover?
What are user defined functions in ms sql server?
What are some of the pros and cons of not dropping the sql server builtinadministrators group? : sql server security
What happens if null values are involved in bitwise operations?
You are designing a database for your human resources department in the employee table, there is a field for social security number, which cannot contain null values if no value is given, you want a value of unknown to be inserted in this field what is the best approach?
