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 is meant by the error ‘String or binary data would be truncated. The statement has been terminated’?
String or binary data would be truncated This is
-
What is a Dirty page?
Dirty page When we do any modification in the
-
What is the foreign key constraint and what is the need of it on a Table?
Foreign key Foreign key is a field or combination
Leave a Reply
This site uses Akismet to reduce spam. Learn how your comment data is processed.
hi chandra,
very nice website,covered from very basics in Sql to high level.
Thanks Laavanya.