how we can store the value like that 001,003,023 etc in sql
server 2005
Answer Posted / gopi muluka
Using Character Datatypes
See this
CREATE TABLE NumAsVar (Num VARCHAR(50))
INSERT INTO NumAsVar VALUES ('001')
INSERT INTO NumAsVar VALUES ('002')
INSERT INTO NumAsVar VALUES ('021')
SELECT * FROM NumAsVar
Is This Answer Correct ? | 12 Yes | 5 No |
Post New Answer View All Answers
Please differentiate between a local and a global temporary table?
explain how to create a new schema in a database? : Sql server database administration
What is difference between inner join and join?
What is primary key, unique key, and foreign key?
What are extended events in sql server?
Write a SQL queries on Self Join and Inner Join.
What are magic tables in sql server?
What is outer join in sql server joins?
What is sqlservr.exe - process - sql server (sqlex?press)?
When a primary key constraint is included in a table, what other constraints does this imply?
What is 2nf example?
What are 3 ways to get a count of the number of records in a table?
What is normalization of database? What are its benefits?
What Is Rdbms?
What is a unique key constraint?