the transaction log on a 10Mb database has shot up to 1G!,
how can I reduce this and prevent this happening in the
future.................

I have a table (TAB) and A View with alias (VIEW)
Table         cod     varchar 3
                 descr  carchar 60
my view    cod alias COd1

I have a sql table with a field name model. In the model column, i have
model number that start with FX%.
I want to add WM before FX%. After FX can be anything, characters or
numbers. The model data type is varchar.

I have an alias that can get very long because it maintains a information of
where it came from.  Is there a way to alias an alias?
My first thought was:
Declare @T1 varchar(128)

This is propably a very simple question, but I can´t seem to find the answer
to it in the documentation.
I want to format a numeric field so the result is right justified and
zero-filled.

Sample table as follows
Order ID     Stock Code    Status
---------    -------       -------
203          STK1          3

Hi
I am having an application with mssql7 standard as backend.
Some times the entry screen is hanging and nobody can save data.
I am using several mster tables like supplier,customer..etc

Does nobody in which algorithm the LIKE and CHARINDEX function based.
Is it meaningful to write itself search algoritms based on
Knuth-Morris-Pratt or Boyer-Moore algoritms to replace LIKE on CHARINDEX
functions for speed exhancement ? (I itself not belive)

Does anybody know what the difference is between the 'IN' and '=' operators.
I am aware that '=' compares two expressions whereas 'IN' looks to see if an
expression appears in a list and that a statement including an '=' operator
is quicker to type than one with an 'IN'.  Other ...

I'm trying to make this query:
select count (distinct UC_CODE, SYNT, SUPER)
FROM  PLAN_RB
WHERE HYPER IS NULL

I have some code that looks like below and after a few suggestions from a
previous post I have tried passing it all through as variables but with no
luck, has anyone else got any other ideas how I can speed this stored
procedure up, all necessary tables have indexs????

I need to make sure i do not open second transaction if one is already
opened,
i wanted to name a transaction, but how can i cjeck if a transaction with
that name is already open?

How can I cross-tab the query it was simple in MS-Access but i don't know how
to do it in SQL. the thing i want is as follows:
Simple Query
Item         Year        Qty

I have a query where I am writing the following statement:
select * from ......
where table1.field1 = table2.field2
....

I would like to know the syntax in MS SQL 2K for describing a table, without
having to expand everything in the object browser.
I know in Oracle it is: desc <table_name>;
Thanks,