Is there any way to direct the output from a DBCC command or stored procedure output into a temp table? I've tried various methods used in MS SQL Server that work fine without success in Syba...
Hi,
I have a Store Proc like the following.
CREATE PROCEDURE my_sp_test
@start_date varchar(20),
@end_date varchar(20)
------
Exec("INSERT INTO #tmp_tbl1 SELECT * FROM tble_" + @...
Hi all,
i want to know that in following case can I dump transaction log
I am working in production environement so recovery is also very important for my company
(1) SELECT * into u...
I know a numeric datatype ranges from 2-17 bytes. But how is the actual number of bytes determined.
How many bytes for instance would numeric(18,0) or numeric(10,2) take?
Thanks
I need to write a VB program which should connect to a sybase database under the OS of Unix(exactly, AIX), I got from others that I can use ODBC. Is that right? If it is Ok, I need to ...
Greeting experts!! ^_^
I am working on a store procedure within the sybase DB.
The code that I wrote below is a store procedure.
I am trying to retrieve a database name from sysdatabase (sy...
HI all:
I'm about to do some studying for both tests....Ass/Prof...I was wondering if ppl knew of sites that listed frequently asked questions...or had free study materials....
Tereza
im creating a script that checks if primary key exist, if not, then add the primary key.
if exist(select somewhere in systables where primarykey = thiskey) then <--<< im stuck here.
creat...
Is there a way to create an insert trigger to assign a value as the primary key, and have it work for a multi row insert. I have a version working that will work for a single row.
Is there...
Is there a way to specifically monitor the number of read/writes to a particulatr database? sp_monitor provide an overall, but i need to get specifics if possible.
Configuration -
Intan...
