Started 1 day, 6 hours ago (2009-11-15 13:10:00)
by Shuja Ali
If you are using SQL 2005 then you should look at "OUTPUT DELETED" keyword on
MSDN. This can be used with the delete statement to output the deleted rows into a table, etc.
Started 3 days, 13 hours ago (2009-11-13 05:58:00)
by olivthill2
In sql advantage, type sp_help a_new_table and see the differences with sp_help an_old_table .
If the table is still not found when you give the long name of your tables (<databasename>.<owner>.<objectname>) in every query, then it might be a problem of privileges. Try grant all on my_new_table to public
Started 5 days, 15 hours ago (2009-11-11 04:29:00)
by jcaccia
Code:
SELECT lname
FROM member
WHERE REGEXP_LIKE(email, lname||'@.+')
This selects all records where the email is the
surname followed by '@' followed by any number of any characters (must have at least one).
Started 1 week, 6 days ago (2009-11-03 06:32:00)
by Alsvha
I'd think it depends on the method used, but you should be able to defined just one table regardless.
Started 2 weeks, 3 days ago (2009-10-30 00:04:00)
by tarik077
by the way it is for
MS SQL.
Started 1 month, 1 week ago (2009-10-10 14:28:00)
by Shuja Ali
What
database server are you using? it becomes little difficult to help unless we know which database you are using. Assuming that it is SQL Server, you should be looking at DBCC CHECKIDENT
Started 2 weeks, 5 days ago (2009-10-28 16:01:00)
by VictorN
The "standard" (or locale independent) SQL format for date/time is:
'
YYYY-mm-dd HH:MM:SS'
Started 2 weeks, 5 days ago (2009-10-28 10:33:00)
by toddmcdermid
A couple things to change/check:
1. Don' t use mapped drives. Mapped drives aren't restored in a
user-profile-less session, regardless of who you're "running as" in ASP.Net. Use UNCs instead. Notes on running SSIS packages remotely: http://msdn.microsoft.com/en-us/library/ms403355.a spx
2. Make sure you have SSIS tools installed on the ASP.Net machine - because that's where you're ...
Size: 182 bytes
