Database

Mridang Agarwal wrote:

Is it possible to restore a backup of SQL Server 2005 Enterprise/Standard Edition onto a SQL Server 2005 Express Edition DB.

Mridang Agarwal wrote:

I have a small backup file. its really small. Can someone just restore the backup for me and generate an SQL script from it. I need the script.

DECLARE @SQLQuery AS NVARCHAR(500)
DECLARE @ParameterDefinition AS NVARCHAR(100)
DECLARE @appId AS INT 
 
SET @appId = 10
SET @SQLQuery = 'SELECT * FROM ' + @AnswerDetailTable  + ' WHERE appId = @appId'
SET @ParameterDefinition =  '@appId INT'
 
EXECUTE sp_executesql @SQLQuery, @ParameterDefinition, @appId

public virtual ulong
InsertData
(
   string                  TableName
,
   PIEBALD.Data.DataReader TheData
)
{
    System.Text.StringBuilder columns   = new System.Text.StringBuilder() ;
    System.Text.StringBuilder values    = new System.Text.StringBuilder() ;
    string                    comma     = "(" ;

    for ( int runner = 0 ; runner < TheData.FieldCount ; runner++ )
    {
        columns.Append ( comma + this.WrapName ( TheData.GetFieldName ( runner ) ) ) ;
        values.Append ( comma + "@" + TheData.GetFieldName ( runner ) ) ;

        comma = "," ;
    }

    return ( ExecuteNonQuery
    (
        "INSERT INTO " + this.WrapName ( TableName ) + columns.ToString() + ") values" + values.ToString() + ")"
    ,
        TheData
    ) ) ;
}