What is the need for group functions in sql?
No Answer is Posted For this Question
Be the First to Post Answer
Explain acid?
Explain where clause?
Explain contrast amongst grouped and non-bunched records?
What are the differences between INNER JOIN, LEFT JOIN and RIGHT JOIN in SQL Server?
What is the tcp/ip port on which sql server runs?
How To Make password Protected SQL Server 2005 Database i.e when i open SQL Server database then ask for password.
What are the differences between char and nchar in ms sql server?
what is procedure in sql?
How to assign new column names in a view?
What are system databases in ms 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
How to store and query spatial data?
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)