Hi i've to do a simple for statement.
That begin 1 to 4.
p.e. in VB for i=1 to 4
my xml file are formatted as following:
<root>
<customer name="pippo" surname="pluto" age="25"/>
<customer name="pippo" surname="pluto" age="25"/>...
I TRY TO EXECUTE THIS SCRIPT VIA QUERY ANALYZER:
GO
SET IDENTITY_INSERT [IdWare].[dbo].[CPU] ON
GO
INSERT INTO [IdWare].[dbo].[CPU]
SELECT id,ServerName,LogConsumer,WeekType,IsMaster,TransactionConsumer,null,null
FROM [IdWareOld].[dbo].[CPU]
GO
SET IDENTITY_INSERT [IdWare].[dbo].[CPU] OFF
GO...
Hi, i'm learning XSL(T), i try to convert my asp page with all functionality to xml+xsl+html(or Asp it's the same).
My asp page use ADO to inspect a table from a SQLSERVERDB
(Select * FROM BOOKS).
To improve the asp page performance i use paging method.
Now i try co convert the old asp page, the...
Hi,
i need to open a new window(child window) in a page.
I try to do with window.open method, but it doesn't work well i found a problem with IE5.
There is another method (client side) to do this.
it's possible executing a batch file via xp_cmdshell command
i try to do this but query analyser write me
EXEC master..xp_cmdshell 'c:'
EXEC master..xp_cmdshell 'cd\'
EXEC master..xp_cmdshell 'sendmail'
The name specified is not recognized as an
internal or external command, operable program or...
Hi i try to send mails with sql mail but my mail profile isn't correct. mapilogonex due failed is then error.
But if i use VB and i setting my mapi profile as sql mapi it work.
My o.s in nt workstation i have a mail preconfigured.
My answer is because in vb work but in sql mail not yet
in startup step if i define the same location for the SQL system files and data files for my DB may be a problem?
If my disk(the same of SQL system files) is full SQL SERVER startup.
Hi,
insert part 1
-----------------------------------------------------------
Hi, I've a table with a field datetime.
I'd like to write into only the time.
insert into CO_Period_Type (DE_Description, TS_Start_Time, TS_End_Time) values ('7777', ????,????)
gana78 (Programmer) Feb 7, 2002...
Hi, I've a table with a field datetime.
I'd like to write into only the time.
insert into CO_Period_Type (DE_Description, TS_Start_Time, TS_End_Time) values ('7777', ????,????)
thank's my solution is
AND convert(varchar,TR_Basket_Header1.TS_End_Time,108) >= convert(varchar,@CurPerTS_Start_Date,108)
AND convert(varchar,TR_Basket_Header1.TS_End_Time,108) <= convert(varchar,@CurPerTS_End_Date,108)
Hi i've a table with a field datetime type, i've to extract from this only the time for a comparison
F.E.
'01/02/2002 11:00:15 PM'
the result must be 11:00:15 PM
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.