Viewing 10 posts - 46 through 55 (of 55 total)
use temporary table.
create index if necessary.
Be cautious for using function [ sum(value(parameter)) ] with large number of data
September 20, 2013 at 5:45 am
use truncate statement. it has many adventages
Because truncate has not where clause and you need some data, then you can save them in another temp table, truncate base table and...
September 20, 2013 at 2:29 am
use this
create table tableColumn1 (db varchar(300), tableName varchar(1000), columnName varchar(1000))
sp_msforeachdb 'insert into tableColumn1 select "?" AS db, a.name tableName, b.name columnname from [?].sys.tables a join [?].sys.columns b on...
September 19, 2013 at 8:32 am
first check on linked server in ( component services -> computer -> mycomputer -> distributedTransaction there is local DTC.) On local DTC properties tab security allow remote access.
if you do...
September 18, 2013 at 5:56 am
Hi sasia
you need to define output parameter to your procedure
for example
create procedure HowMoneyIsInTheWallet
(
@IDOsoby int,
@Wallet int OUTPUT
)
AS
-- your code where you set value to @Wallet
return @Wallet
call the stored procedure
...
September 8, 2013 at 10:17 am
i think problem is in calculation in select statement.
try in this way
Select @Voucher = i.ap101_voucher,
i.ap101_amt,
i.AP101_GL_ACCT into #temp
from inserted i
select @VATPERCENT=( sum(case when AP101_GL_ACCT in ('70102501110', '70102501120') then ap101_amt...
September 6, 2013 at 6:31 am
Hi, SSC-Dedicated
Based on your experience,
i would be appreciate if you explain in detail how SQL Injection will pass this.
P.S.
maybe in this case it's no so important, this select statement is...
August 30, 2013 at 2:18 am
Input format is wrong and this line
MC.materialItemContainerCode IN (" + @containerCodes +")'
August 29, 2013 at 12:52 am
Hi Junglee_George,
make your query dynamic.
declare @sqlText varchar(max)
set @sqlText = 'SELECT
MC.MaterialItemContainerCode,
MC.ReceptionDate,
C.clientName ,
MI.materialItemName
FROM
MaterialsItemsContainers MC
INNER JOIN MaterialsItems MI WITH(NOLOCK)
ON (MC.materialItemIncId = MI.materialItemIncId AND MC.materialItemSqlId = MI.materialItemSqlId AND MI.isDeleted=0x0)
INNER JOIN Clients AS C...
August 29, 2013 at 12:51 am
Hi Grasshopper,
you can make new database role, depending on your specifications. Set your XXX user to that role
August 28, 2013 at 1:25 am
Viewing 10 posts - 46 through 55 (of 55 total)