Generate Script with Data in SQL Server 2008

Generate Script with data in MSSQL Server 2008
 
 Step 1: Log in to your MSSQL Serevr
 
 Step 2: Go to your database and Right Click
 
 Step 3: Task--> Generate Script,It will open a window
 
 Step 4: Click Next-->Ckeck the checkbox-->Next
 
 Step 5: On current window, "Choose script option", go to table/view operation after scroll down.
 
 Step 6: Change "true" from "false" on script data option.
 
 Step 7: Click on next-->next-->finish
 
 The generated script also have script as well as data in insert command.
Ebook Download
View all
Learn
View all