Hi, I asked about some tips about this problem. But now it's same. But I haven't admin rights. I want to import some text file but into sql table...
Hi, help me please with this .. I am using statement for importing xls file -> sql server tables in stored procedure. Sql server is 2000 . Sample :...
First , best wishes in this year. Help me please .. How can I find out if some folder on pc is exist ? Thanks , Lubo
HI , I am unhappy... I'm working with many dates structure. My problems are make some sql statements. One of them it's now combining Insert INto with...
Hi , help me please.. i have table with column datatype money. In procedure i read some xml file , some value is string. I need write this value to...
Hi , i have some stor procedure. During run of it i use package. But I need change some parameter in setting of package. Is it possible or may I run...
Hi, help me please.. How can i combine some statement..I want make in stor procedure Insert with use Select and some value from procedure. Example :...
HI,I want print result of select Declare @volN int set select @volN = volN from linTMP where va1X =cast(right(@va1X ,9) as int) PRINT 'Result of...
Hi , during running of procedure I got message The log file for database 'Tempor' is full. Back up the transaction log for the database to free up...
Hi ,is it possible use some statement . Declare @sqlCommand varchar(255) , @param int set select @param= param from Table where pilot= 1 .... It...
Hi, help me please.. I need convert string '10.04.2004' to date 10.04.2004 by update. Could you write me correct statement ? Thanks, Lubo
Hi , could you help me pls ? I need to write some code with use Insert into , but Values are some values from other table INSERT Into MyTmpTable...
Hallo, is it possible write statement with some parameter in after definition of cursur ? I usually work with cursor, but in cycle i need to change...
hallo, help me pls. Maybe this subscribe is clear . I need to Update k_Table , column price Update k_Table set price= sum(Det.price) FROM...
Hallo , help me please. [?] 1.I have an asp code and I call some stored procedure. set rssql4= connection.Execute(" sp_zapLog '"&naz&"', '"&user&"'...
Hi, it must by very simple... How can I store some result of select ( for example Set @tmp = Select sum(field1) from Table1 to some variable ?...
Hello , can you help me please ? I have 3 tables : Hello , can you help me please ? I have 3 tables : Table Column LinksNS (varchar) , doNum...
What is wrong ? I have table where is column dolneCislo ...bigint When is code running I make with variable @novCis_Kon (varchar (255)). In some...
Hallo , How can I update values in two columns in the same row ? Is it possible ? For example : . . set @ident =@Id . . . UPDATE...
Hi, i need to drop and rename the tables during run of code. If table is exist I need drop it. How can I make a sql statement for test of existing...
Separate names with a comma.
