4 Solved Topics

Remove Filter
Member Avatar for
Member Avatar for while(!success)

Hi guys, I'm still new to .NET and your answers to my questions have been so helpful. I have another question yet again, however. This time my question has to do with sql server and handling it with code behind. I am creating a stored procedure which is supposed to …

Member Avatar for while(!success)
0
2K
Member Avatar for vs.vaidyanathan

if not exists (select * from sysobjects where name='amrreconAccountsTB') begin execute "create amrreconAccountsTB(acct_id char(2048) NULL)" end; Message from server 'NOCTREPI04' (Msg 156, Severity 15, State 2): error near the keyword 'end'. Can someone please help me and tell me what is the syntax error here?

0
106
Member Avatar for ayesha789

HI Dears all I have 2 tables in DB. [LIST=1] [*]Lease_north [*]Lims_payment [/LIST] My first query is [ICODE]Select * from lease_north WHERE LaStartDate like '%-04-%'[/ICODE] its shows 100 result means 100 payments are due and must be paid in April. My second query is[ICODE]Select * from lims_payment WHERE pdate like …

Member Avatar for ayesha789
0
450
Member Avatar for ms_sws

I've tried all manner of methods for accomplishing this and nothing has worked so far. The latest attempt follows. The objective is to call a function that tests for the existence of an image file. If the file exists then that image file is to be displayed. Otherwise, an alternative …

Member Avatar for Airshow
0
5K

The End.