how can i view structure of table in sql server? tell me
that query.
- 10 Answers
- 16704 Views
- I also Faced
- E-Mail Answers
Answer Posted / r.rajesh
sp_columns table_name
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
Hi, I Created 3 Tables Person(PersID[prkey],Name,Email,Password), Project(ProjName,ProjID[prkey],ProjLeader,ProjManager) & ProjectInvolvement(EntryDate,ProjID[frkey],PersID[frkey],ProjDuration). For this how can i INSERT,UPDATE & DELETE Through PROCEDURE? Please Post the Answer for me. Desai.
How to achieve Paging of records in SQL SERVER?
What is query and its types?
What is deploy, process and build? : sql server analysis services, ssas
what are defaults? Is there a column to which a default can't be bound? : Sql server database administration
what is normalization? Explain different levels of normalization? : Sql server database administration
What is the index requirement in SQL Azure?
Explain what are magic tables in sql server?
What is standby servers? Explain types of standby servers.
What do you understand by integration services in sql server?
Explain error and transaction handling in sql server?
How to use subqueries with the in operators in ms sql server?
What are the differences between lost updates and uncommitted dependencies?
Equi join and non equi join is possible with sql server?
What is linked report?
