Interested to Buy Any Domain ? << Click Here >> for more details...
How do I list the available tables in a database I'm
querying?
- 4 Answers
- 7203 Views
- I also Faced
- E-Mail Answers
Answer Posted / shraddha
sp_tables
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
You are designing a strategy for synchronizing an SQL Azure database and multiple remote Microsoft SQL Server 2008 databases. The SQL Azure database contains many tables that have circular foreign key relationships?
explain different types of cursors? : Sql server database administration
How do I start sql server?
Is sql server implemented as a service or an application? : Sql server database administration
what changed between the previous version of sql server and the current version? : Sql server database administration
What is log shipping? Can we do logshipping with SQL Server 7.0 - Logshipping is a new feature of SQL Server 2000. We should have two SQL Server - Enterprise Editions. From Enterprise Manager we can configure the logshipping. In logshipping the transactional log file from one server is automatically updated into the backup database on the other server. If one server fails, the other server will have the same db and we can use this as the DR (disaster recovery) plan.
Explain the concepts and capabilities of sql server?
Explain what is lock escalation and what is its purpose?
Do you know what is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure?
What is the difference between drop table and truncate table?
Write query to return all rows sql?
How do triggers work?
Can we use having clause without group by?
Explain insert into select statement?
How to convert a unicode strings to non-unicode strings?
