if you want to find the last record in a table (with PK = xx) you can to try with:
select * from tabv where xx = (select max(xx) from tab)...
agocurti
Last Activity: Sep 19 '06, 04:06 PM
Joined: Sep 15 '06
Location:
-
UPDATE CmpnyGLSegments
SET GLSegment = GLSegment + '-000'...Leave a comment:
-
This is the way:
update table1 set values = values + 'newtext' where id = 1...Leave a comment:
-
I partially solved with:
Exec ('select substring('+@ch vCol+',1,50) from ' + @chvTable + ......)
with
DECLARE @chvTable sysname, @chvCol sysnameLeave a comment:
-
I think you can to use this syntax:
select * into my_tmp_tab from my_table where........Leave a comment:
-
Dynamic Select in MSSQL
Hi folks,
I have a problem migrating from Oracle to MSSQL the statement:
stmt2 := 'Select substr('||tabc| |',1,50) from '||tabn||'
OPEN cur2 FOR stmt2;
How can I to perform this dynamic select into MSQL ????
Thanks 4 your help
No activity results to display
Leave a comment: