Could we do a SQL 6.5 backup in a way that we do not lose any single transaction. (something like ArchiveLog mode in Oracle).
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_10212154.html
Zones:
MS SQL ServerDate Answered: 03/13/2002 Rating: 6.8 Views: 0
Hello experts,
I want all the fields in a table and so I write :
Declare cursor_A cursor
for select * from table_A
open cursor_A
Fetch cursor_A
Now instead of showing the result on ...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_10328317.html
Zones:
MS SQL ServerDate Answered: 04/19/2000 Rating: 7.2 Views: 0
Is there a transact - sql statement for a database to validate the user?
I'm writing some web pages that will list stored procs from different databases, but before I run the select statement to...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_20307732.html
Zones:
MS SQL ServerDate Answered: 10/26/2003 Rating: 8.4 Views: 0
I need to convert the following VB code to Transact-SQL to use in a stored procedure in SQL Server 2000:
rs is a recordset that contains all records from tblTemp.
tblTemp(RcvdDate datetime, T...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_20338504.html
Zones:
MS SQL ServerDate Answered: 08/22/2002 Rating: 8.0 Views: 0
What is Transact SQL? If you know SQL do you know T-SQL
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_20794892.html
Zones:
MS SQL ServerDate Answered: 11/17/2003 Rating: 9.4 Views: 0
I have looked through the examples and found what I thought was the answer. The problem is how to get the @@identity from the stored procedure into my VB.Net application. Any help would be greatly ...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_21146672.html
Zones:
MS SQL ServerDate Answered: 09/28/2004 Rating: 8.0 Views: 0
Hello,
I have a pretty long sql query, the structure of the query is as follows:
BEGIN
UPDATE ......
DELETE ......data from Table1
DELETE.......data from Table2
INSERT......data into Table1...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_21482590.html
Zones:
MS SQL ServerDate Answered: 07/07/2005 Rating: 9.4 Views: 0
I have a somewhat complex query...
Select
tbl_a.a, tbl_a.b, tbl_a.c,
(
select count(*) from tbl_D d
where d.a = tbl_a.a
) as Z,
-- here...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_21622696.html
Zones:
MS SQL ServerDate Answered: 11/14/2005 Rating: 9.0 Views: 0
Hey!
I want to wrap this three steps in one transaction:
1. Insert values
2. Get the id of inserted row (last id)
3. Insert values
In code-behind getting the last id: SELECT IDENT_CURREN...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_21728729.html
Zones:
MS SQL ServerDate Answered: 02/08/2006 Rating: 9.2 Views: 0
Hello you all,
I have this code that is written in MS Transact-SQL and I need to convert it to work with Oracle. Can anyone please help??? I need the code for a VBscript project.
Thanks!
H...
http://www.experts-exchange.com/Database/Oracle/Q_22113895.html
Zones:
OracleDate Answered: 06/12/2007 Rating: 6.8 Views: 0
