Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. msalvador

    SetLocale will not work

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

    for statement in xsl

    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;/>...
  3. msalvador

    identity insert

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

    identity insert

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

    Import data from 2 sql server db's

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

    Paging with XSL

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

    open a new window

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

    executing a batch file

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

    mapi error

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

    kill a object

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

    may be a problem

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

    applet java

    Hi there are any site where i can found applet java open source. I've to do a histogram
  13. msalvador

    setting system date

    hi, there is a function to set system date
  14. msalvador

    setting system date

    hi, there is a function to set system date
  15. msalvador

    insert only time part 2

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

    Insert only time

    Wonderful, thank's a lot
  17. msalvador

    Insert only time

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

    Debug stored-procedure

    Hi, exists any tools for Stored Procedure Debugging
  19. msalvador

    Date Problem

    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)
  20. msalvador

    Date Problem

    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

Part and Inventory Search

Back
Top