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
- 9043 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
Where are sql server user names and passwords stored in sql server?
What is create statement?
what is the primary use of the model database? : Sql server administration
Can we install sql server 2016 on windows 7?
Do you know what are acid properties of transaction?
Can the “if update (colname)” statement be used in a delete trigger?
Can a cursor be updated? If yes, how you can protect which columns are updated?
What is the current limitation of the size of SQL Azure DB?
how would you write a sql query to compute a frequency table of a certain attribute involving two joins? What changes would you need to make if you want to order by or group by some attribute? What would you do to account for nulls?
If a stored procedure is taking a table data type, how it looks?
What is the recommended total size of your memory optimized tables?
Explain how you can deploy an SSRS report?
What are the types of containers in ssis?
What should be the fill factor for indexes created on tables? : sql server database administration
What are null values in ms sql server?
