Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / kishore
select count(*) NoOfColumns from SYSCOLUMNS
WHERE id= (Select id from SYSOBJECTS where name = 'city')
In this querry may name is Tablename
| Is This Answer Correct ? | 0 Yes | 5 No |
Post New Answer View All Answers
Define inner join in sql server joins?
Can two tables have the same primary key?
What do you understand by SQL*Net?
What are the basic functions for master, msdb, model, tempdb and resource databases?
What is molap and its advantage? : sql server analysis services, ssas
Ms sql server index?
You have a stored procedure, which execute a lengthy batch job. This stored procedure is called from a trigger you do not want to slow the data entry process you do not want trigger to wait for this batch job to finish before it completes itself what you can do to speed up the process?
What is the difference between an index and a unique index?
Can we make the the chages By Using the Sql if u know any function or process please inform me Actuall result: BRK1 Break 1 Part 1 00:01:00:00 60 BRK1 Break 1 Part 2 00:01:00:00 60 BRK2 Break 2 Part 1 00:01:00:00 60 BRK2 Break 2 Part 2 00:01:00:00 60 BRK2 Break 2 Part 3 00:01:00:00 60 BRK3 Break 3 Part 1 00:01:00:00 60 BRK3 Break 3 Part 2 00:01:00:00 60 Desired O/P: BRK1 Break 1 Part 1 00:01:00:00 60 Part 2 00:01:00:00 60 BRK2 Break 2 Part 1 00:01:00:00 60 Part 2 00:01:00:00 60 Part 3 00:01:00:00 60
Can group functions be mixed with non-group selection fields in ms sql server?
How to connect to SQL Azure Database by using sqlcmd?
What is difference between count (*) and count column?
Ways to improve the performance of a SQL Azure Database?
Explain Normalization and DE normalization
What does sql server mean?
