Search results for query: *

I have the same problem. Is anyone that find a solution. Thanks in advance

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=&quot;pippo&quot; surname=&quot;pluto&quot; age=&quot;25&quot;/> <customer name=&quot;pippo&quot; surname=&quot;pluto&quot; age=&quot;25&quot;/>...

i've 2 db's new & old that have the same table... look ahead i must to transfert the table via sql script

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 via script i've to transfert the data from a table in db1 to the same table in db2 db1:table pippo db2:table pippo

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

hi, i create a object with a=server.createobject(&quot;pippo&quot;). pippo is a com object. there's a method to kill this in vb f.e. a=nothing

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 there are any site where i can found applet java open source. I've to do a histogram

hi, there is a function to set system date

hi, there is a function to set system date

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...

Wonderful, thank's a lot

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', ????,????)

Hi, exists any tools for Stored Procedure Debugging

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