What is difference between cte and view?
No Answer is Posted For this Question
Be the First to Post Answer
How to use the inserted and deleted pseudo tables?
Can we add our custom code in ssis?
What is normalization and what are the different forms of normalizations?
What are the main control-of-flow T-SQL constructs?
Once setting replication, is it potential to own a publisher as sixty four bit sql server and distributor or subscribers as a thirty two bit sql server?
How to connect PK and FK?
Can a unique index be created on a column, which contains null?
Explain Geography datatype in SQL Server
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
Where is trigger in sql server?
What is the difference between substr and charindex in the sql server?
Why do we use sql limitations? Which constraints can we use while making a database in sql?
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)