|
|
|
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 Unexpected repeated calling of a stored procedure Posted by Hamish Laws at 6/19/2005 11:55:03 PM I've been working on a project for a client
One of the requirements was loading data files that arrive in a particular
format.
We've used a dll we wrote in VB.NET to load these files into staging tables
and then the dll calls an SQL Server stored procedure to perform some
processing on ...more >>
What is sp_execresultset ??? Posted by Yosh at 6/19/2005 9:32:18 PM What does this stored procedure actually do?
sp_execresultset=20...more >>
What is the best deployment practice for VB.Net + MSDE/SQL 2000 Posted by Aaron Bertrand [SQL Server MVP] at 6/19/2005 9:30:55 PM
...more >>
Trigger issues Posted by Shimon Sim at 6/19/2005 8:53:58 PM I have following table and relations
gBankAccount PK - BankAccountId, gTransaction - PK TransactionId
BAnkTransaction PK TransactionId and has one to one relation with
gTransaction. Also I have AccountEntry table that has TransactionId as FK.
When I delete row from gTransaction BankTransac...more >>
Which Provides Better Performance Posted by Yosh at 6/19/2005 8:19:43 PM Which performs better?
SELECT title_id, ytd_sales
FROM titles
WHERE ytd_sales BETWEEN 4095 AND 12000
SELECT title_id, ytd_sales =20
FROM titles =20
WHERE ytd_sales >=3D 4095 AND ytd_sales <=3D 12000 =20...more >>
Sql Server Locks Posted by Calin Iaru at 6/19/2005 7:24:01 PM Hi all,
I believe that in case of simultaneous database connections some locking
mechanism is used. I know that this locks may be frequent and that the size
of the datagram sent to the server to activt the lock is about 1 Kilobyte.
Can you please confirm this? I would like to know somethi...more >>
Image data type Posted by Andrey at 6/19/2005 6:12:01 PM Hello! I’m interesting is it possible to find sample application worked with
image data type in Northwind or Pubs databases?
Andrey
...more >>
Get length of Text column Posted by Alan Z. Scharf at 6/19/2005 1:27:26 PM Is there a way to get the length of a text column.
The LEN function doesn't seem to work on text columns.
Am I missing something?
Thanks.
Alan
...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
The best key... Posted by Arjen at 6/19/2005 1:25:33 PM Hi,
I have a table like this:
Id (int32)
UniqueCode (uniqueidentiefier) (used for url's)
UserId (int32)
Title
CreateDate
I can make the Id the key.
This can also be the key... combination of UserId and CreateDate.
I don't use the values of Id. What key has your preference?
Thanks!
...more >>
Predefined values Posted by Arjen at 6/19/2005 12:39:36 PM Hi,
I have a record with a status field. The status can be "OK", "NOT OK" and
"DELETED".
Currently this field is an int32. Where '1' stands for the first status, '2'
for the second...
Is there not a way where I can insert the status values inside a fieldtype?
Thanks!
...more >>
TempDB Question Posted by Yosh at 6/19/2005 11:46:13 AM I created a table in the TempDB database. Does it stay there until I =
drop it or does it get dropped automatically?
Thanks,
Yosh...more >>
Question about set functions Posted by Michael C# at 6/19/2005 11:08:40 AM Quick question about SELECT with aggregate functions. Does SQL evaluate in
this order on a query containing an aggregate function, such as SUM():
1. apply search expression
2. apply value expression
3. eliminate nulls
4. SUM() the results
Or does it evaluate in this order:
1. app...more >>
Changing a TABLE COLUMN from VarChar(8000) to TEXT for more storage space Posted by \ at 6/19/2005 11:08:07 AM I need to change a datatype from VARCHAR to TEXT.
(I need to store 10000 chars, not 8000.)
What's the correct way to make this simple change?
Seems like I get an error if my ALTER statement *HAS* a default...
an even if it doesn't.
CREATE TABLE #MyTable
(
MyKey Int IDENTITY(1,1),
M...more >>
Calculating elapsed time - 1 calendar month Posted by hals_left at 6/19/2005 5:30:25 AM Is it possible using SQL date arithmetic to consistently determine if a
date is within 1 calendar month of another date? The calc should be
based on dates only, not times.
I have the following tables and need to set a flag to 1 on the
registrations table when inserting records, if the registra...more >>
Connect to another Server Posted by NR at 6/19/2005 4:03:02 AM I would be thankful if someone can tell me how can we retrieve data from 2
different SQL servers in a single query.
For Example:
I have two servers:
1) Test1
2) Test2
And both has database named "Emps"
By using system tables of "Emps" database i want to compare both databases
of different ...more >>
T-SQL_will_die… Posted by herbert at 6/19/2005 12:31:02 AM Based on the discussion „code in the database or middle tier“ of 6/1/2005 and
my experience with SQLCLR:
I’m teaching students hardcore .NET programming. Students come in with C/C++
knowledge and within 200 hours they learn multithreading, WMI, windows
services, setup projects, remoti...more >>
SQL Query for Records with Duplication of Two Fields? Posted by Joel Just Joel at 6/19/2005 12:00:00 AM Greetings,
I hope you can help me with what may be a simple SQL query question.
In the following query, the report generated in Reporting Services / Visual
Studio returns:
- person name
- person id
- phone number(s)
- phone id
but only if phone "Preferred" value in record =1, meaning this...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |