Have you tried to google "sybase forum"? You may find more releavnt help there...

😉

BoL clearly explains what can be done:

Permissions

The minimum permission required is ALTER on table_name. TRUNCATE TABLE permissions default to the table owner, members of the sysadmin fixed server role, and...

Something reseeded your identity. Check this sample:

CREATE TABLE TestA (id INT NOT NULL IDENTITY(1,1) PRIMARY KEY , val VARCHAR(10));

insert TestA values ('a')

insert TestA values ('b')

insert TestA values ('c')

insert TestA...

Ralf (7/19/2013)

---

yes, it seems that the conversation to datetime is performed before the WHERE filter.

maybe because of parallel processing and the large size of the table A (~300 MB)....this is...

Yeah, for just executing one line...

If you want to run some statement in mulitple databases simultaneously then you will need to write some sort of application which can open connections to your multiple databases at...

If you got "The conversion of a varchar data type to a datetime data type resulted in an out-of-range value." error that mean that there are some values in table...

Yeah, I have slightly modified version in my play-ground. As per Luis point, just replace PosNo with...

Take a look into well-known J.Moden splitter function http://www.sqlservercentral.com/articles/Tally+Table/72993/

If you cross apply to this function on each column then you can join on ItemNo function return and you will get...

Use LEFT function to limit number of characters to be taken from columns which causing this problem.

P.S. Without having DDL of tables involved it's impossible to tell which exact...

You may want to try full text search here. Together with using WHERE EXISTS instead of JOIN, should be considerably faster than JOIN with non sargable LIKE. For some reason...

...

SSCrazy, thanks for the suggestion but unfortunately I can't remove the 2 fields from the existing table. As this is an existing SQL Table for another application. The...

riya_dave (7/10/2013)

---

i can see that column name in my table.

also when i type alias my intellisense for that table doesnt get anything, if i type anoter table name

it display all...

I would model it differently, to avoid customly controlled auto increments.

What I would do is:

1. remove Library_Barcode and Food_Barcode columns from your Employee table

2. create two separate tables Employee_Library and...

The above means that there is no...