Tagged Questions
2
votes
0answers
100 views
How compatible are Sybase and SQL Server clients connecting to the alternate back end?
Given the shared history of the Sybase and SQL Server products, and their use of a similar (identical?) wire protocol in TDS, what definite statements can be made, if any, about cross compatibility.
...
2
votes
1answer
124 views
How are foreign keys resolved when creating tables in batch?
I am creating a database version management tool with the goal of being able to recreate a database from scratch using text/sql files contained in source control. As part of establishing a baseline ...
0
votes
3answers
1k views
How to import Sybase .db file into SQL Server database?
I've been given a Sybase .db file by a client and I need to import that into a new SQL Server database so that I may see the data as well as the tables and their relationships, any ideas on how that ...
1
vote
1answer
188 views
How to sync a table between oracle and sybase
I have a table in Sybase (destination) that I would like to keep it synced with a table in Oracle (source)
I cannot truncate and populate the table in Sybase because it is used by an application, I ...
0
votes
1answer
298 views
Strange Sybase / SQL Server linked server issue
I have a sybase table which has a column note varchar(1000) null.
The following T-SQL will get the following error if there is a not-null value in note. (sybase is the linked server to the Sybase ...
1
vote
1answer
72 views
Should I use table hints with a process-keyed table?
I read on stackoverflow that locking can be a problem when using process-keyed tables, and I was wondering if you had any suggestions on how to minimize or avoid unnecessary contention (e.g. table ...
45
votes
4answers
4k views
Why use both TRUNCATE and DROP?
In the system I work on there are a lot of stored procedures and SQL scripts that make use of temporary tables. After using these tables it's good practice to drop them.
Many of my colleagues (almost ...
