Answer Posted / hr@tgksolutions.com
• Primary Key: A unique identifier for a table’s record (e.g., id in a table).
• Foreign Key: A column in a table that refers to the primary key of another table, establishing a relationship between tables.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What are the dmvs?
When would you use a before or after trigger?
What are the advantages of using cte?
How to create and drop temp table in sql server?
List the data types available in mssql?
Explain mixed authentication mode of sql server?
What is the new security features added in sql server 2016? : sql server security
What is user-defined scalar function?
How to list all stored procedures in the current database using ms sql server?
State the difference between union and union all?
How to provide default values to stored procedure parameters?
but what if you have to create a database with two filegroups, one on drive c and the other on drive d with log on drive e with an initial size of 600 mb and with a growth factor of 15%? : Sql server database administration
What are .mdf files?
You have a table with close to 100 million records recently, a huge amount of this data was updated now, various queries against this table have slowed down considerably what is the quickest option to remedy the situation?
How can sql server instances be hidden?