How to get script of SQL Server data? [duplicate]

by

From the SQL Server Management Studio you can right click on your database and select:

Tasks -> Generate Scripts

Then simply proceed through the wizard. Make sure to set ‘Script Data’ to TRUE when prompted to choose the script options.

SQL Server 2008 R2

alt text

Further reading:

More Related Contents:

  1. Export table data from one SQL Server to another
  2. Is it possible to write single query on two table which are not connected to each other?
  3. select yesterday date in where condition
  4. Can I use CASE statement in a JOIN condition?
  5. Import CSV file into SQL Server
  6. How to create a table from select query result in SQL Server 2008 [duplicate]
  7. Are there any disadvantages to always using nvarchar(MAX)?
  8. Creating an index on a table variable
  9. Is there a LastIndexOf in SQL Server?
  10. SQL Server – stop or break execution of a SQL script
  11. What is the difference between using a cross join and putting a comma between the two tables?
  12. Bulk DELETE on SQL Server 2008 (Is there anything like Bulk Copy (bcp) for delete data?)
  13. Pivot Table and Concatenate Columns
  14. How do I calculate a running total in SQL without using a cursor?
  15. Transfer data from one database to another database
  16. Equivalent of Oracle’s RowID in SQL Server
  17. Concat field value to string in SQL Server
  18. How to update and order by using ms sql
  19. How to store image in SQL Server database tables column [duplicate]
  20. SQL “between” not inclusive
  21. SQL performance: WHERE vs WHERE(ROW_NUMBER)
  22. Benefits Of Using SQL Ordinal Position Notation?
  23. SQL Server replace, remove all after certain character
  24. Does UNION ALL guarantee the order of the result set [duplicate]
  25. Inserting rows into a table with one IDENTITY column only [duplicate]
  26. How to find sum of multiple columns in a table in SQL Server 2005?
  27. How to retrieve field names from temporary table (SQL Server 2008)
  28. When using GETDATE() in many places, is it better to use a variable?
  29. Group consecutive rows of same value using time spans
  30. SQL add filter only if a variable is not null

Leave a Comment