Explain the difference between delete,drop and truncate in SQL Server?
No Answer is Posted For this Question
Be the First to Post Answer
What is meant by Active-Passive and Active-Active clustering setup?
How to get @@error and @@rowcount at the same time?
When we are using this query to shrink the log file,what exactly it will execute internally? Do we lose any data when we run this script? which data it will truncate in the log file and where it is saved. Please let me know... USE DatabaseName GO DBCC SHRINKFILE(<TransactionLogName>, 1) BACKUP LOG <DatabaseName> WITH TRUNCATE_ONLY DBCC SHRINKFILE(<TransactionLogName>, 1) GO
hi i am working as a testengineer , so i want to no the backend data base connection can any one tell mwe in detail
Why I have to use stored procedures?
What is sql stored procedure?
What are the methods used to protect against sql injection attack?
What are views in ms sql server?
How to verify a user name with sqlcmd tool?
Define indexes?
What is attribute? : sql server analysis services, ssas
What are different types of data sources?
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)