| Groups | Blog | Home |
|
January 2003 June 2003 July 2003 August 2003 September 2003 October 2003 November 2003 December 2003 January 2004 February 2004 March 2004 April 2004 May 2004 June 2004 July 2004 August 2004 September 2004 October 2004 November 2004 December 2004 January 2005 February 2005 March 2005 April 2005 May 2005 June 2005 July 2005 August 2005 September 2005 October 2005 November 2005 December 2005 January 2006 February 2006 March 2006 April 2006 May 2006 June 2006 July 2006 August 2006 September 2006 October 2006 November 2006 December 2006 January 2007 February 2007 March 2007 April 2007 May 2007 June 2007 July 2007 August 2007 September 2007 October 2007 |
Filter by week: 1 2 3 4 5 dumb question Posted by news at 9/28/2007 8:43:16 PM Sorry about this. But I've worked primarily in access for years.
Does SQL Server have a boolean or a yes/no data type for its table columns?
Thanks in advance,
Bill
...more >>
Users Logged In Posted by RogueIT at 9/28/2007 4:25:41 PM Is there a way in 2005 to tell what user is logged into what database
on the SQL Server?
thanks,
Scott
...more >>
I want to parse @ArrayOfDays into @d1 through @d5 Posted by bobc at 9/28/2007 2:36:56 PM In my stored procedure, I want to parse @ArrayOfDays into @d1 through
@d5.
@ArrayOfDays is a varchar input parameter containing,
for example, "1.7.21.25.60." - five elements.
Most active vars:
@i - loop counter
@char - current char in string
@tempVal - contains the current element as it ...more >>
Comparing two tables Posted by JJ297 at 9/28/2007 6:28:10 AM What is the correct syntax to do so.
I have the same fields in the table.
Tables called Books and Titles
Fields are TitleID and Titles
Using SQL 2000
Please assist.
Thanks.
...more >>
strategies for paging Posted by Nick Chan at 9/28/2007 3:12:25 AM hello, what are the strategies when designing tables that needs
paging?
in the past i used to use
select top 200 * from table
where id not in (select top 100 id from table)
with SQL 2005, would u guys recommend using CTE and/or ROW_NUMBER?
or any other advice?
thanks
...more >>
The best way to use the Database Engine Tuning Advisor Posted by Tommy Hayes at 9/27/2007 3:58:11 PM Hello all,
I want to use the SQL Server 2005 Tuning Advisor on our database, and
I'm hoping someone here can just confirm the steps for me. We have a
10GB database that has a number of applications hitting it constantly,
all performing many SELECTs, INSERTs and UPDATEs. Are the following
the ...more >>
I want to return a string to a wrapper from a subordinate stored procedure Posted by bobc at 9/27/2007 12:36:03 PM Using SQL Server 2000...
I wrote a wrapper to call a sub proc (code provided below). The
intended varchar value returned in the output parameter of each proc
is a string implementation of an array.
(The string separates elements by adding a period after each value.
e.g. 1. 2. 3. 4. 5. etc., ...more >>
isqlw won't start Posted by Andre Ma NO[at]SPAM ss at 9/27/2007 12:32:28 PM Hi there,
I tried to install MS SQL Server 2000 on my desktop computer after
uninstalling a version 7 instance. Everything worked fine. Using
Enterprise Manager I can manage databases and the database enginge itself.
My problem is now, that ISQLW.exe, i.e Query Analayzer won't start. The
...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Set default schema in code - possible? Posted by aj at 9/27/2007 9:44:20 AM ==SQL Server 2005 SP2==
Is it possible to set the default schema in code?
I know that, for a particular DB user, I can set the default schema
statically in Mgmt Studio. However, I want to do this dynamically
in source code.
I am using JDBC if that matters.
Any help appreciated.
TIA...more >>
Network Packet Size Posted by kmounkhaty NO[at]SPAM gmail.com at 9/27/2007 8:57:26 AM Hi Guru,
After we moved from old server (windows 2000, SQL 2000 and SP3a) to a
new server (windows 2003, SQL 2000 and SP4) that cutting down maximum
network packet size to a half, we run into a new issue below:
Message : General network error. Check your network documentation.
Source : ....more >>
Select Into across Linked Servers Posted by Jennifer at 9/27/2007 8:38:02 AM Hi. I'm trying to copy from one table to another across 2 different
servers with the following:
select *
into #Tmp_Hdr
from parsaleshdr
where businessday = '9/20/07'
select *
into [pdsqla01\pdsqla01].impact_exec.dbo.parsaleshdr
from #Tmp_Hdr
This gives me an error:
The object name '...more >>
a small SQL Puzzle Posted by Fiori at 9/26/2007 8:37:12 PM Hi,
Probable there is a simple solution for this, hopefully someone can
direct me in the right direction.
I have a table with a persons firstname, lastname, birthdate and
address. However, I want to select only one person per address, namely
the eldest of all persons living on the same a...more >>
autoincrement question sql 2005 server Posted by info at 9/25/2007 3:06:32 PM How add column autoincrement in sql server 2005 use SQL Server Management
Studio?
Tom
...more >>
Clustered index on the identity column or a datetime column Posted by Tommy Hayes at 9/25/2007 1:57:37 PM Hello all,
We have a table with about 2 million rows that is used to store log
events. The table has an identity column and also a datetime column to
record the event time. It is expected to at least double in size over
its lifetime. Because the datetime records the current time, the value
of...more >>
Is it worth partitioning? Posted by Tommy Hayes at 9/25/2007 3:37:11 AM Hello all,
We're currently upgrading to SQL Server 2005 and we're trying to
figure out if we should partition some of the tables in the database.
Specifically the two largest tables - both have around 1.5 million
rows and are expected to at least double in size over the lifetime of
the syst...more >>
SQL Query from Access to SQL Server Posted by rune NO[at]SPAM totalweb.no at 9/25/2007 3:00:48 AM Hi
I'm trying to convert an SQL Query from Access to SQL Server. The
Access Query goes like this:
SELECT Format(EntryDate, 'ddd mm dd') AS [Day]
FROM JournalEntries
This query returns the name of the day followed by month and date (Su
aug 21)
What would this be like in SQL Server ? Wh...more >>
Moving DB from one drive to another Posted by Piero 'Giops' Giorgi at 9/24/2007 11:04:13 PM Hi!
I'm using SQL Server 2005.
The DB has one table partitioned on 50 Filegroups (One per state)
The DB is right now on my drive G: as are the filegroups (But in
separate directories), and for a number of reasons, I have to move the
DB to drive F: but I need to keep the filegroups (With t...more >>
subtraction of different precision values Posted by ibcarolek at 9/24/2007 10:17:15 AM We have a field which is decimal (9,2) and another which is decimal
(9,3). Is there anyway to subtract the two and get a precision 3
value without changing the first field to 9,3?
For instance, retail value is 9,2, but our costs are at 9,3 due to
being averaged. To calculate margin (retail-c...more >>
Conn. Prob. contd: 'logon restricted' [Mngm. Studio] Posted by Daniel Loose at 9/22/2007 12:09:25 PM Hello again,
and thanx again -
I now found something unexpected - that hopefully is the cause of my
problem? :
In Man. studio > security > anmeldungen (engl. login names or users or
accounts or so?) > right clicking on any user and properties, > status
> sql server authentication is grey...more >>
Strange Connect Problem Posted by Daniel Loose at 9/22/2007 2:49:43 AM Hello,
I try to get an asp site to work on my local machine. Using ASP Studio
2005 and mssql server 2005 eval on win xp, and ms management studio.
I'm new to mssql and asp and just want to get the site to run (not
edit). have a simple connect script like
set conn = server.CreateObject("adod...more >>
find unique identifier through multiple tables Posted by hugues.morel NO[at]SPAM gmail.com at 9/22/2007 2:34:05 AM Hi,
I need to do a report from data in a database that was provided by a
third party where there is no documentation at all. It contains more
than hundred tables and each table has different GUID fields.
In one table there is GUID as a primary key and another GUID as
foreign key. But there is...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |