how can i view structure of table in sql server? tell me
that query.
- 10 Answers
- 16729 Views
- I also Faced
- E-Mail Answers
Answer Posted / murli manohar
sp_tables @table_type = "'TABLEName'"
| Is This Answer Correct ? | 5 Yes | 9 No |
Post New Answer View All Answers
Define cross join in sql server joins?
can an automatic recovery be initiated by a user? : Sql server administration
What is difference between view and materialized view?
When would you use a before or after trigger?
What is a DBMS, query, SQL?
What are “lock” hints?
What is default constraint?
What is snapshot report?
What are exact numeric data types in ms sql server?
What is use of except clause?
What is SQL Server?
What are a scheduled jobs?
Tell me what are cursors and when they are useful?
What is the use of nvl work?
I have a table Events Events containing cardno,time,id,name--each id has a cardno my requirement is every day each employee swipe the card several times i want to calculate first and last time of each card the output should be name 1 2 6 7 in out in out holiday holiday xxx 09:30 06:30 09:40 06:45 where 1,2...... are dates for example january 1,2, etc. 6 and 7 are saturday and sunday how it is posssible
