Hi every one,
                    I am new to sql server2005,I have datetime column
in my database ..I need to display only time part of the datetime .I
need to display in AM/PM format ..datetime is stored in this format mm/

I have another SQL question, and this one is going to be difficult to
explain.
I have a table like this
rowid        name         changed

I'm having problems using "<>" as criteria for a varchar column in a
view.  The data in this column is '2008-2009' which is supposed to
mean year 2008 thru 2009.  If I set the criteria to "= '2008-2009'"
then the view returns just those rows with that field equal to

I'm running SQL Server 2008 Developer on Vista Ultimate.  I've been a
big fan of BitDefender for the last couple of years now, but with the
release of SQL 2008 I'm running in to all kinds of problems.  I would
really appreciate an educated recommendation on what AV would best be

SQL Server 2005 64-bit 9.00.3042 SP2
When I map a database user to a login, I can specify a default schema
for that user.  After that, any SQL from that user w/o an explicit
schema will be resolved to that default schema.

Having ms sql 2005 SP2
I need for the PaymentHeader table to create a transaction number when ever
a record is added. That will be the invoice number. Obviously there is only
one counter field allowed in a table.

I have a SQL query like this (I have tried to break the problem down
to simplify it),
select rowid from table where name in ('a', 'b', 'd') group by rowid
Here is an example of data in the table

I have 14 of the following queries I run manually each day.  Each day
manyually changing the date to yesterdays date.   I am wondering if there is
a variable I can set for the
local_start_time between 'Oct 28, 2008 00:00:00.000' and 'Oct 28, 2008

SQL Server 2005 64-bit 9.00.3042 SP2
While working in SQL Server Mgmt Studio, I wish to maximize/minimize
the window (or I guess the tab on the window) in which I type
SQL for execution (in the default setup, the window at the

If I get an Open License for the SQL 2008 Developer Edition can I use
it to install the 2005 version?
Thanks
--

I'm completely new to SQL and this puzzle is over my head. Any advice
would be greatly appreciated.
Table: Visits
Columns:

Is there a way to prove, or not, that under the same hardware configuration
with the same databases SQL Server Enterprise is faster than the Standard?
What is the best and faster SQL 2008 version for serving a web site with
more than 1 milion pageviews a day?

Can someone explain to me what a database instance is? Does every
database has its own instance? How can I determine what instances has
been installed/configured in a MS SQL 2005 server?
Thanks

Having problems adding this where clause (where
week_start_date='20081003')  I have two dates in the database but I
want the count from only 20081003.
SELECT PAN,

I'm designing a new database from scratch. It has some columns that I
currently have as datatype=int with check constraint of x>=1 and x
<=32, or others with a range of 1-3, etc. It occurred to me I could
create a UDDT to represent each. Benefit would be that I don't have to