These are Frequently Asked Questions so by definition there should not be very many of them.

A table or two in your existing database would be easiest.

Run INSERT scripts to populate...

Hi Daniel,

I think the problem is not about caching.

I still support a SQL 6.5 database and so far as I know there is no ALTER PROCEDURE command in SQL 6.5.

You...

Hi Gaganks,

Implementing SAP in any organisation is a massive job that requires a great deal of planning.

SAP has many different modules for different business areas.

SQL Server is not the issue.

You...

Hi Karthik,

The WHERE cluase is what filters the rows that get returned by your query.

It doesn't care about the physical order of the rows in the table.

The ORDER BY clause...

Karthik,

The WHERE clause has got nothing to do with ORDER BY.

ORDER BY just sorts the results after the WHERE clause has selected what you want.

The physical order of the...

Hi Karthik,

I am far from being an expert in programming language theory but here's my two bob's worth.

SQL uses Imperative programming. You tell the DB engine what you want done...

This link may help:

http://www.easysoft.com/developer/languages/perl/dbd_odbc_tutorial_part_1.html

You are trying to use a Sybase driver to connect to MS SQL Server from Perl in Linux.

Sybase and MS SQL Server used to be the same thing but not...

Hi Brett,

Have you considered the MONEY data type for financial data rather than FLOAT which is imprecise?

Would you really have financial data to 14 decimal places?

Vyas,

You have already posted this question in the Administering section and had some answers so please don't double post. The topic has nothing to do with SS2K5 Replication.

As pointed out...

I used Sybase PowerDesigner a few years ago for this type of work.

I believe it can import Erwin files and it can reverse engineer many databases.

See comparison at

Jeffrey,

Thanks for your point about ;

Yes you are right of course.

I am using SQL 2005 and could not get WITH to work until I realised it needed a ;...

Harsha,

The syntax of the various SQLs varies quite a bit. The differences that hit you first as a developer are things like column datatypes and the need/don't need semi-colons after...

Harsha,

What flavour of SQL are you using?

SERIAL8, NVARCHAR(100,30), INT8, LVARCHAR are not valid in T-SQL.

DEFINE should probably be DECLARE.

You don't want ; in the stored procedure

Have a look at BOL...

Hi Neel,

Could you provide some more details please?

1. What version SQL Server?

2. Table definition (table name, column names, data types, keys, indexes)?

3. Some sample data rows

4. What exactly do you...