Interested to Buy Any Domain ? << Click Here >> for more details...
how to find number of columns in a table in sql server 2000
and 2005 also
- 7 Answers
- 14349 Views
- HCL, Virtusa, I also Faced
- E-Mail Answers
Answer Posted / naren
sp_help tablename
another command is
select name from syscolumns where id=object_id
('table_name')
| Is This Answer Correct ? | 6 Yes | 3 No |
Post New Answer View All Answers
How to perform backup for certificates in sql server? : sql server security
what is isolation level at dead lock?
What is a sql join?
What is outer join in sql server joins?
What is unique key constraint?
What is a transactions?
How do you start single user mode in clustered installations?
How can I create a new template for import ? : sql server management studio
How will you add a dimension to cube? : sql server analysis services, ssas
How to insert multiple rows with a subquery?
Explain how dts is used to extract, transform and consolidate data?
How to check table values in sql server?
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
how many triggers you can have on a table? : Sql server database administration
What is shared lock?
