如何比较两个整数值与文本？(How to compare two integer values with text?)

 在Microsoft SQL Server Management Studio中，您可以右键单击要备份的数据库，然后单击“任务” - >“生成脚本”。 
 
 这将弹出一个向导，您可以在其中设置以下内容，以便对数据库执行体面的备份， 即使在远程服务器上也是如此 ： 
 
 
 
 选择您要备份的数据库，然后点击下一步 
 
 
 在它给你的选项中： 
  
 
   
 在2010年：在表/视图选项下，将“脚本数据”和“脚本索引”更改为True，然后再次打开， 
 
   
 2012年：在“一般”下，将“数据类型到脚本”从“仅限模式”更改为“模式和数据” 
 
   
 2014年：在“设置脚本选项”的步骤中，现在将“数据脚本”选项“隐藏”，您必须单击“高级”并将“数据类型到脚本”设置为“架构和数据”值 
 
  
 
 
 在接下来的四个窗口中，点击“全选”，然后点击“ 
 
 
 选择脚本到一个新的查询窗口 
 
 
 一旦完成它的事情，你将有一个备份脚本准备在你面前。 创建新的本地（或远程）数据库，并更改脚本中的第一个“USE”语句以使用新的数据库。 将脚本保存在安全的位置，然后继续运行，并将其运行到新的空数据库中。 这应该创建一个（几乎）重复的本地数据库，然后可以根据需要进行备份。 
 
 如果您有完全访问远程数据库，您可以选择在向导的第一个窗口中检查“脚本所有对象”，然后在下一个窗口中将“脚本数据库”选项更改为True。 请注意，您需要在脚本中执行完全搜索和替换数据库名称到新的数据库，在这种情况下，您不必在运行脚本之前创建。 这应该创建一个更准确的重复，但由于权限限制有时不可用。 

In Microsoft SQL Server Management Studio you can right-click on the database you wish to backup and click Tasks -> Generate Scripts.
 
This pops open a wizard where you can set the following in order to perform a decent backup of your database, even on a remote server:
 
 
 
Select the database you wish to backup and hit next,
 
 
In the options it presents to you: 
  
 
   
In 2010: under the Table/View Options, change 'Script Data' and 'Script Indexes' to True and hit next,
 
   
In 2012: under 'General', change 'Types of data to script' from 'Schema only' to 'Schema and data'
 
   
In 2014: the option to script the data is now "hidden" in step "Set Scripting Options", you have to click the "Advanced" and set "Types of data to script" to "Schema and data" value
 
  
 
 
In the next four windows, hit 'select all' and then next,
 
 
Choose to script to a new query window
 
 
Once it's done its thing, you'll have a backup script ready in front of you. Create a new local (or remote) database, and change the first 'USE' statement in the script to use your new database. Save the script in a safe place, and go ahead and run it against your new empty database. This should create you a (nearly) duplicate local database you can then backup as you like.
 
If you have full access to the remote database, you can choose to check 'script all objects' in the wizard's first window and then change the 'Script Database' option to True on the next window. Watch out though, you'll need to perform a full search & replace of the database name in the script to a new database which in this case you won't have to create before running the script. This should create a more accurate duplicate but is sometimes not available due to permissions restrictions.