Interested to Buy Any Domain ? << Click Here >> for more details...
what is the difference between delete table and truncate table commands? : Sql server database administration
- 0 Answers
- 1033 Views
- I also Faced
- E-Mail Answers
No Answer is Posted For this Question
Be the First to Post Answer
How to select nth record from a table?
13 Answers DELL, Microsoft, Ramco,
What are the main control-of-flow T-SQL constructs?
Tell me what is normalization? Explain different forms of normalization?
What are all new concepts in SQL Server 2008? That is Exactly Difference between 2005 to 2008
2) Consider a Table name A which has below records ID --- 5 5 5 5 5 Consider another table B which has below records ID -- 5 5 5 5 5 5 5 5 How many rows will be returned by each of the below queries a) select * from A inner join B on A.id = b.ID b) select * from A left join B on A.id = b.ID c) select * from A right join B on A.id = b.ID
Can sql servers link to other servers like oracle?
What is the default schema of your login session in ms sql server?
Can we update data in a view?
What is the cpu pressure?
How can sql server instances be hidden?
Is truncate autocommit?
How many clustered indexes can be created on a table? I create a separate index on each column of a table. what are the advantages and disadvantages of this approach?
-
Oracle (3259) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3330)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
