I have a table with 100 records. Now I want to generate INSERT statements with the same data. How will you generate?
Open SSMS — Right click on Database — Tasks — Generate scripts — Next — Select specific database objects — select your table — Next — Select the output type — Advanced — Select data only from Types of data to script property — Ok — Next — Next — Click on Finish after completion of execution.
-
What are ACID properties?
ACID properties The acronym ACID stands for Atomicity, Consistency,
-
What is the difference between Deterministic and Non deterministic functions?
Deterministic vs Non deterministic functions: A function is deterministic,
-
What is the Difference between Temporary tables and Table Variables?
My suggestion is go for Table variables when we
hi chandra,
very nice website,covered from very basics in Sql to high level.
Thanks Laavanya.