how we can store the value like that 001,003,023 etc in sql
server 2005
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
What is difference between drop truncate and delete?
What are the different types of sub-queries?
What is difference between views and stored procedures?
Explain about thread and memory management process of SQL?
What do you understand by mirroring?
What is transaction server distributed transaction?
What is database white box testing?
List the ways in which dynamic sql can be executed?
Explain “@@rowcount” and “@@error” in sql server?
How to get a list of columns using the "sys.columns" view in ms sql server?
Define self join?
What is an execution plan?
but what if you have to create a database with two filegroups, one on drive c and the other on drive d with log on drive e with an initial size of 600 mb and with a growth factor of 15%? : Sql server database administration
What are the built in functions in sql server?
What is tempdb database? : SQL Server Architecture