Update a table with data from another existing table

Update a table with data from another existing table:

UPDATE tableToBeUpdated
SET fldToBeUpdate = (SELECT tblSource.fldToUpdate FROM tblSource WHERE tblSource.idOrder = tableToBeUpdated.idOrder)
WHERE EXISTS (SELECT tblSource.fldToUpdate FROM tblSource WHERE tblSource.idOrder = tableToBeUpdated.idOrder)

Create a new table with same schema and data from an existing table

Create a new table with same schema and data from an existing table

SELECT * INTO NEWtABLEnAME FROM FROMtABLEnAME

Solution to SQL Server Error "Divide by zero error encountered"

DECLARE @input int
SET @input = 25*5
SELECT (CASE @input when 0 then 1 else @input end)

SELECT (CASE 25/0 when 0 then 1 else 25/0 end)

Generate Script for SQL Server Database with Schema and Data

Microsoft Windows XP [Version 5.1.2600]
(C) Copyright 1985-2001 Microsoft Corp.

C:\Documents and Settings\Shahid Khan>E:


E:\>"C:\Program Files\Microsoft SQL Server\90\Tools\Publishing\sqlpubwiz" script
-d dssbdDB "C:\dssbdDB.sql" -u dev -p 12345
Microsoft (R) SQL Server Database Publishing Wizard
Version 1.1.1.0
Copyright (c) Microsoft Corporation. All rights reserved.

Unrecognized command line argument '-u'
Missing/wrong number of arguments.

Usage:

sqlpubwiz script ( -C connection_string | -d local_database_name ) (output_file)
[switches]

switches:


Output options:

[-f] : Overwrite existing files
[-noschemaqualify] : Output script does not qualify object names with
schema name.
[-schemaonly] : Only script schema
[-dataonly] : Only script data
[-targetserver] : Specifies what version of SQL Server the script
should target. Valid versions are "2000", "2005".
Default Value: 2005
[-q] : Suppress output
[-nodropexisting] : Default Value: False

Local connection related:

[-C connection_string] : Connection string
[-d local_database_name] : Database name to script
[-U local_user_name] : Username
[-P local_password] : Password
[-S local_server_name] : Server name



E:\>"C:\Program Files\Microsoft SQL Server\90\Tools\Publishing\sqlpubwiz" script
-d dssbdDB -U dev -P 12345 -S (local)\SQLEXPRESS "dssbdDB.sql"
Microsoft (R) SQL Server Database Publishing Wizard
Version 1.1.1.0
Copyright (c) Microsoft Corporation. All rights reserved.

Generating script for database dssbdDB
- Generating script targeted for SQL Server 2005
Gathering list of objects to script
Scripting objects
.........
Writing script to disk
Writing default DF_tblAdminsInfo_IsAuthorized
Writing default DF_tblAdminsInfo_IsDeleted
Writing default DF_Table_1_ParentSectorID
Writing default DF_tblCompanyInfo_IsAuthorized
Writing default DF_tblCompanyInfo_IsVisible
Writing default DF_tblCompanyInfo_IsDeleted
Writing default DF_tblCoupon_IsDeleted
Writing default DF_tblProductInfo_IsHotProduct
Writing default DF_tblProductInfo_IsSpecialDiscounted
Writing default DF_tblProductInfo_IsFeatured
Writing default DF_tblProductInfo_IsAuthorized
Writing default DF_tblProductInfo_IsVisible
Writing default DF_tblProductInfo_IsDeleted
Writing default DF_tblSectorInfo_ParentSectorID
Writing default DF_tblSectorInfo_IsAuthorized
Writing default DF_tblSectorInfo_IsVisible
Writing default DF_tblSectorInfo_IsDeleted
Writing default DF_tblUserInfo_IsAuthorized
Writing default DF_tblUserInfo_IsDeleted
Writing default DF_tblUserInfo_VisitCount
Writing storedprocedure dbo.sp_CreateDataLoadScript
Writing table dbo.tblSectorInfo
Writing table dbo.tblProductInfo
Writing table dbo.tblCoupon
Writing table dbo.tblCompanyInfo
Writing table dbo.tblUserInfo
Writing table dbo.tblSectorCompanyRel
Writing table dbo.tblAdminsInfo
Writing table dbo.tblAdminsInfo
Writing table dbo.tblSectorCompanyRel
Writing table dbo.tblUserInfo
Writing table dbo.tblCompanyInfo
Writing table dbo.tblCoupon
Writing table dbo.tblProductInfo
Writing table dbo.tblSectorInfo
Writing storedprocedure dbo.sp_CreateDataLoadScript
Writing default DF_tblAdminsInfo_IsAuthorized
Writing default DF_tblAdminsInfo_IsDeleted
Writing default DF_Table_1_ParentSectorID
Writing default DF_tblCompanyInfo_IsAuthorized
Writing default DF_tblCompanyInfo_IsVisible
Writing default DF_tblCompanyInfo_IsDeleted
Writing default DF_tblCoupon_IsDeleted
Writing default DF_tblProductInfo_IsHotProduct
Writing default DF_tblProductInfo_IsSpecialDiscounted
Writing default DF_tblProductInfo_IsFeatured
Writing default DF_tblProductInfo_IsAuthorized
Writing default DF_tblProductInfo_IsVisible
Writing default DF_tblProductInfo_IsDeleted
Writing default DF_tblSectorInfo_ParentSectorID
Writing default DF_tblSectorInfo_IsAuthorized
Writing default DF_tblSectorInfo_IsVisible
Writing default DF_tblSectorInfo_IsDeleted
Writing default DF_tblUserInfo_IsAuthorized
Writing default DF_tblUserInfo_IsDeleted
Writing default DF_tblUserInfo_VisitCount

Scripting completed for database dssbdDB.

E:\>exit