Do you know data definition language, data control language and data manipulation language?
No Answer is Posted For this Question
Be the First to Post Answer
What is the significance of null value and why should we avoid permitting null values?
Can we linked SharePoint to a SQL database?
0 Answers Sans Pareil IT Services,
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 would you write a sql query to compute a frequency table of a certain attribute involving two joins? What changes would you need to make if you want to order by or group by some attribute? What would you do to account for nulls?
What is user-defined inline table-valued function?
What is a full text index?
What is nolock?
What is database mirroring?
HOW TO RENAME A COLUMN NAME
How many levels of sp nesting is possible?
How can sql injection be stopped? : sql server security
What is Trigger?
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)