Simple way to creating
the update query for the table in SQL Server
Declare @TableName sysname = 'MemberRegistration'
Declare @result varchar(max) = ''
Declare @StartString varchar(max) = 'Update '+@TableName+' Set'
SELECT
@result =
@result + '
[' + ColumnName +
']=@' +
ColumnName +','
FROM (SELECT
REPLACE(col.name, ' ', '_') ColumnName,
...
Tuesday, December 23, 2014
Simple way to creating the insert query for the table in SQL Server
Simple way to creating
the insert query for the table in SQL Server
Declare @TableName sysname = 'MemberRegistration'
Declare @result varchar(max) = ''
Declare @StartString varchar(max) = 'Insert into '+@TableName+''
SELECT
@result =
@result + '
[' + ColumnName +
'],' + +''
FROM (SELECT
REPLACE(col.name, ' ', '_') ColumnName,
column_id,
...
How to disable the unwanted SSRS report export formats using asp.net c#
How to disable the
unwanted SSRS report export formats using asp.net c#
/// <summary>
/// Disable Unwanted Export Formats
/// </summary>
public void DisableUnwantedExportFormats()
{
FieldInfo
info;
...
Subscribe to:
Posts (Atom)