What is the language structure to add a record to a table?
No Answer is Posted For this Question
Be the First to Post Answer
List all types of constraints in sql server?
How many triggers are possible per table?
Is it possible to import data directly from t-sql commands without using sql server integration services? If so, what are the commands?
You accidentally delete the msdb database what effect does this have on your existing sql databases, and how do you recover?
Explain some DBCC commands?
Explain why variables called the most powerful component of ssis?
How can we solve concurrency problems?
Why do we need different type of parameter?
You are designing a database for your human resources department in the employee table, there is a field for social security number, which cannot contain null values if no value is given, you want a value of unknown to be inserted in this field what is the best approach?
An employee table, with the columns id, name, sal and dob. Query to select emp names of all highest salaries(there are 4-5 people having the same salary which happens to be the highest).
WHAT IS UNIQUE IDENTIFIER DATA TYPE?
In which files does sql server actually store 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)