Viewing 15 posts - 16 through 30 (of 122 total)
that is very much helpful.
thanks
May 21, 2017 at 11:14 am
worked fine....thanks
May 20, 2017 at 8:59 pm
May 20, 2017 at 12:50 pm
is this the full script ?
DECLARE @strSQL Varchar(MAX) = '';
SELECT @strSQL = @strSQL + 'DROP TABLE ' + QUOTENAME(name) + '; '
...
May 20, 2017 at 11:21 am
Could anyone please check this out ?
May 20, 2017 at 9:50 am
SELECT 'DROP TABLE ' + QUOTENAME(name) + '; '
FROM sys.objects
...
May 20, 2017 at 8:06 am
May 15, 2017 at 3:50 am
for example, what is the data type of CAPBANK.LOAN_NUM? If it's INT then it needs to be converted as you can't concatenate strings and numerics
yes..how do I...
April 5, 2017 at 4:26 am
Error:
Msg 245, Level 16, State 1, Line 1
Conversion failed when converting the varchar value 'Offer Letter' to data type int.
executed this :
[code...
April 5, 2017 at 4:15 am
DesNorton (1/5/2017)
INSERT INTO PRIOR_DIST (_ID, COSTS_DST, IS_ACTIVE)
SELECT
@_id,
ROUND(CASE WHEN ta.const1 IS NULL OR ta.const1 != 0 THEN pd.COSTS_DST * ta.const1 / @const2
...
January 5, 2017 at 6:48 am
Viewing 15 posts - 16 through 30 (of 122 total)