|
|
|
January 2003 March 2003 April 2003 May 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 November 2007 April 2008 |
Filter by Day: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 Field value determines whether there is extra info that should be held about that record Posted by Amir at 12/30/2005 7:14:22 PM Hi,
I would like to have your advice in a little DB design issue. I'll try to
demonstrate it by an example:
Guess I have DB to hold information about rooms that are in a house. Each
record represent a room, and has many fields like: width, height, wall color
etc. One of the fields in the...more >>
five connection limit Posted by Igor Solodovnikov at 12/30/2005 6:10:11 PM Hi!
Everybody know that MSDE (based on SQL Server 2000) has five-connection
limit after which its performance degrades. Do SQL server 2005 Express
edition also has five-connection limit? Or this limit was dropped?...more >>
Union duplicates Posted by tshad at 12/30/2005 6:08:51 PM If I have 2 tables (actually it would be the product of multiple joins) and
I am getting the same data out of both tables and unioning them, how would I
say if a person was in both tables I only wnat the data out of table x.
For example
Select Name,address,salary from candidate
union
Sel...more >>
Storing Richtextbox data In Sql Posted by den 2005 at 12/30/2005 3:31:01 PM Hi everybody,
What is the datatype in sql for storing data from RichTextbox? How do I
create a sql Insert statement for this data? The data has format like
indentation, Butted list, Font Style and others.
Thanks.
Dennis
--
MCP Year 2005, Philippines...more >>
need to know the detail about cursor. Posted by Skywalker at 12/30/2005 2:51:10 PM Hi,
I have a Table1( C1,C2,C3)
DECLARE T1_cursor CURSOR FOR
SELECT C1,C2 FROM Table1 WHERE C3=1
Tabel1 has multi-millines records. Say if the snap-shot of the T1_cursor has
10000 records when the cursor start running (Fetch), I add more records to
Table1 which has C3=1 while the T1_cur...more >>
Stored Procedure Output Parameter Woes Posted by Denis at 12/30/2005 2:19:02 PM I have written a stored procedure with several output parameters.
eg
@Vendor bit OUTPUT
When I execute this stored procedure via query analyzer it thinks I have
declared this as input/output. Is this a feature or is there something
fundamental I have missed?
I am attempting to call thi...more >>
CAN'T SOLVE SELECT GROUPING WITH MAX FUNCTION Posted by rlueneberg NO[at]SPAM gmail.com at 12/30/2005 2:10:14 PM Here is the scenario
ACCOUNT CONTACT DATE
account A CILXFA000HJ6 4/6/2005 16:05
account A C15467XXXXXX 7/27/2005 12:22
account B C20002XXXXXX 2/15/2005 18:25
account B C12225XXXXXX 12/14/2005 20:10
The RESULT should be this;
account A C15467XXXXXX 7/27/2005 12:22
accou...more >>
Design Question - SQL 2000 to 2005 App Upgrade (CLR?) Posted by Craig S at 12/30/2005 1:32:20 PM I'm upgrading an app I wrote from SQL 2000 to 2005 looking for some
high-level design advice, just to determine how much should be T-SQL vs.
CLR, and the best approach to take for performance. For background, I'm a
strong c# developer, but with only average SQL skills and I'm just getting
i...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
How to get the Column Name of primary key of a table? Posted by Frank Lee at 12/30/2005 1:17:58 PM How to get the Column Name of primary key of a table?
Thanks.
--Using SQL 2005 dev
...more >>
T-SQL does not support breakpoint Conditions Posted by LvBohemian at 12/30/2005 1:00:03 PM When attempting to select the breakpoint condition from within the VS05 RTM
IDE I get the following error message:
"T-SQL does not support breakpoint Conditions"
What's up with that?
Also, why the heck would you not be able to debug TSQL from "SQL Server
Management Studio" ?
This...more >>
SQL Server locking Posted by Abhay Sobti at 12/30/2005 12:48:07 PM Hi friends,
I have an issue here.
1. Two users are adding Slips [vouchers] from two different terminals.
2. The Slip numbering scheme goes as follows : TR/00001 , TR/00002.... and
so on.
3. When these two users click on the SAVE button simultaneously , the
application tries to
fetch t...more >>
Scripting of database objects in SQL 2005 Posted by Edward at 12/30/2005 12:28:03 PM I've written scripts to generate the tables, functions, indexes, keys, views
and stored procedures but I can't find any information for triggers. The
sys.triggers table contains no entries even though I've created a trigger.
When I script from the SQL Management Studio it works fine. I moni...more >>
Case in Join Posted by tshad at 12/30/2005 12:10:40 PM Can you put a Case statement in a Join?
My problem is that I have 2 possible fields I want to join to the same
table. If one is null, use the other.
For example:
Create Table Position
(
UserID1 int,
UserID2 int
)
Create Table Logon
(
UserID int,
UserName
)
I ...more >>
Using input parameters differently for different values Posted by Mark Rae at 12/30/2005 12:09:54 PM Hi,
I have the following table in SQL Server 2000 which contains accounting
ledger data:
ACCNT_CODE varchar(10)
ACCNT_NAME varchar(50)
ACCNT_TYPE char(1)
TRANS_DATE smalldatetime
PERIOD int
D_C char(1)
AMOUNT numeric
The PERIOD field indicates which accounting period the record belo...more >>
how to install multiple instances of Reporting Services? Posted by === Steve L === at 12/30/2005 11:39:19 AM background: sql 2000 with reporting services 2000.
from reading the MSDN, looks like one can install multiple instances of
reporting services 2000 on the same machine (for qa testing and
production and so on), but when I started the reporting services 2000
installation process, it didn't offer...more >>
Picture insert Posted by vul at 12/30/2005 11:34:46 AM Access allows to insert manually an image into OLE Object type field very
easy. I was wondering if there is a simple way to insert an image into image
type field in SQL Server using Enterprise Manager (not programmatically)
Thank you
Al
...more >>
Log File Error Posted by Ricky at 12/30/2005 9:50:03 AM Good Morning
We have a nightly DTS job, which uploads data, to a number of tables (35
tables). However the DTS job failed last night, due to the following error
returned :
****
Error Source: Microsoft OLE DB Provider for SQL Server
Error Description:The log file for database 'G_Data' is f...more >>
Profiler event class question Posted by SSM at 12/30/2005 6:52:02 AM When capturing tuning data in SQL Profiler, what are the key differences
between event classes 10 (RPC Completed), 12 (TSQL Batch Completed), and 45
(SQL Stmt Completed)?...more >>
getting per case info from 1:n related case and log table fast Posted by zu at 12/30/2005 6:48:02 AM I neeed to search through the CASE table and get all records with case
created between two dates. A lot of info is in related tables and the case
table only has the id. So there are quiet some Joins, but that's not the big
problem.
What made my SQL unusable is the fact, that I needed also to ...more >>
sql statement formatting Posted by bringmewater NO[at]SPAM gmail.com at 12/30/2005 5:17:28 AM What is a good way to format this nested sql statment? Are there any
good sites showing other examples? Thanks !
SELECTMerchandise.Description, Users.Name FROMUsers INNER JOIN (Sales
INNER JOIN (Merchandise INNER JOIN Types ON Merchandise.TypeID =
Types.TypeID) ON Sales.MercID = Merch andise...more >>
Mapping from flatfile to SQL server database... Posted by Christian Johansen at 12/30/2005 2:22:02 AM Hi!
Im trying to find existing software to map from flatfiles (mostly .txt) to a
database running on MS SQL Server. The files are recieved by mail, and made
available to my program, and are supposed to be read and processed in a way
that extracts the data from the files and inserts it into th...more >>
AntiVirus Software Posted by Lan at 12/30/2005 1:57:02 AM We have McAfee VirusScan installed on our database server. I would like to
configure the system not to scan *.bak, *.mdf, *.ldf. My question:
1. Is this the right configuration ?
2. By doing so, any potential security breach ?
3. By doing so, will the SQL box performance improve a bit?
Furt...more >>
handling parameters that could be missing Posted by jonefer at 12/30/2005 12:13:03 AM I have a search app that I'm developing in ASP.NET
It has 5 parameters
MRN, Name, Sex, DOB, SSN
All or any combination can be used.
what is the best way to handle the non-supplied parameters?
i.e. if the user selects only supplies 'Name' and 'MRN'
I want the SQL for the stored procedure ...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |