|
|
|
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 Using locks Posted by Aussie Rules at 5/30/2005 11:55:16 PM Hi,
I have a table with several thousand rows, and I want to be able to lock
only a specific record, and also use a transaction.
If a user selects a record I want to be able to execute a begin tran
statement, and whilst they are editing that record (or records in associated
tables), yet ...more >>
Parameter passing to a DTS package Posted by Banu_tr at 5/30/2005 10:51:02 PM Hi,
I have a DTS package that exports a query result from SQLServer to a text
file . I sheculed it daily.
What I want to do is give the text file name as paramaetric, I mean,
e.g. salesresultddmmhhss.txt ddmmhhss : run time day month hour and second
Is it possible?...more >>
Crosstab queries in MS SQL Posted by Mr. Smith at 5/30/2005 10:40:01 PM Am I right in coming to the conclusion that there is no built in method for
creating crosstab queries in MS SQL 2000? I have form the reference under
"Pivot" in SQL books that demonstrates how to build your own but it doesn't
account for scenarios where I don't know how many column headings ...more >>
How to install vs.net 2005 and sql server 2005 beta 2 on the same Posted by sunwolves at 5/30/2005 9:11:01 PM How to install both vs.net 2005 and sql server 2005 beta 2 on the same os?
I'm having troubles installing both SQL 2005 and VS.Net on the same box. I
put VS.net on the box so i can easily modify source files from wherever i am
if i need to.
It seems that SQL2005 needs .Net 2.0 Beta and VS.Ne...more >>
Check Constraint Violation Posted by Clint Colefax at 5/30/2005 7:19:41 PM I am getting a check constraint error on the following query.
INSERT TABLEA
( COL1, COL2, COL3)
SELECT dbo.Function1(),-20000, (dbo.Function1() + (-20000) )
There is a check constraint on COL3 ( COL3 >= 0 ) and dbo.Function() is
returning 20000. All columns are of datatype INT as is the re...more >>
Newbie: Extract largest and smallest DateTime Posted by steve at 5/30/2005 3:51:45 PM Hi,
I have the following tables (among others);
TABLE [dbo].[tblMeasQAHor] (
[STATIONid] [char] (6) NOT NULL , << --- PK
[date_time] [smalldatetime] NOT NULL , << --- PK
[PollutantCode] [char] (3) NOT NULL , << --- PK
[Valide] [char] (1) NO...more >>
Passing explicit date formats to stored procs Posted by James Crosswell at 5/30/2005 2:11:23 PM I have a stored proc with a date parameter - when I call it as follows I
get a syntax error near convert:
EXEC mf_UpdateNetworkEquipment 1, NULL, NULL,
CONVERT(DATETIME, '2006-05-01 00:00:00', 120)
However, the following works:
DECLARE @warr datetime
SET @warr = CONVERT(DATETIME, '...more >>
SELECT Distinct Posted by guoqi zheng at 5/30/2005 12:22:42 PM I know SELECT DISTINCT will only return unique records.
For example if I have
SELECT AA, BB, CC, DD FROM vwWhatever.
It will remove duplication based of all 4 columns. Only When AA, BB, CC, DD
all 4 columns are the same, it will be removed.
How can I DISTINCT only on Column AA??? So ...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
High volume batch insert Posted by cc900630 NO[at]SPAM ntu.ac.uk at 5/30/2005 10:08:42 AM Hi,
I need a SQL program to insert a record into a parent table and then up
to 200 child records, using the primary key of the parent record. Whats
the best way to structure this procedure for performance and
reliability ? e.g
INSERT INTO tblExam ( dteExam,intModule,) Values () ....
SET ...more >>
List all files and autogrowth option Posted by Hassan at 5/30/2005 10:07:18 AM Can I get a list of all files a database comprise of and whether the
autogrowth option for the file is turned on or off
Output should be
DbName FileName Autogrowth_on_off
ABC c:\abc.mdf on
ABC d:\abc1.ndf off
ABC d:\abc2....more >>
How to Send Arabic Text using xp_smtp_sendmail Posted by Ahmed Jewahar at 5/30/2005 6:35:25 AM
Hi All,
How can I send Arabic Test messages using xp_smtp_sendmail.
In the table values are stored in Aabic.
Regards
*** Sent via Developersdex http://www.developersdex.com ***...more >>
Cannot create variable of type table Posted by robertino at 5/30/2005 2:05:39 AM Hi all,
Just heard of table-type variables and wanted to try one out in a SP
(MS-SQL Server 7.0).
However, every time I try to declare such a variable as, (for instance)
:
declare @mytbl table(pos_num smallint, seq_num smallint)
I get an error :
Error 156: Incorrect syntax n...more >>
Disabling table constraints and Transactions Posted by Itay Sandbank at 5/30/2005 1:34:08 AM Hello,
I have a system that generates INSERT, DELETE and UPDATE statements for
multiple tables at once. I don't want to worry about foreign key constraints
during the transaction, I just want to be sure that the database is
consistent after all the INSERTs, UPDATEs and DELETEs are executed....more >>
Finding the smallest available ID for a row Posted by Allan Nielsen at 5/30/2005 12:00:00 AM Hello
If I have a database, say a user database, with up to 200 rows.
It could look like this:
userID - UserName - Salaray
------------------------------
0 - Jack - 200
1 - Joe - 180
2 - Edna - 190
4 - Graham - 220
5 - Kieron - 210
If I want to insert Jane, and I need to insert her...more >>
Passing Table data type as Param to a function Posted by DMP at 5/30/2005 12:00:00 AM Hi,
How can i pass Table data type parameter to UDF ?
...more >>
can Password be hacked? Posted by Bpk. Adi Wira Kusuma at 5/30/2005 12:00:00 AM Can password be hacked? Because my friend ever say, there is a software can
hack SQL Server. Is it true? If yes, how to avoid from hacker? and What name
program that can do it?
which is more secure, use login with "Windows authentication" or "SQL
authentication"?
...more >>
How ? Posted by DMP at 5/30/2005 12:00:00 AM Hi,
How can i pass recordset as parameter in a SP Return value as a RecordSet ?
...more >>
DISTRIBUTED TRANSACTION with OLE DB Jet Posted by Patrick Wolf at 5/30/2005 12:00:00 AM Hi,
I set up an Access 2003 MDB file as a linked Server on SQL Server 2000.
I like to use it to sync entries between SQL Server and the MDB Database.
For this purpose I like to use a DISTRIBUTED TRANSACTION.
But this is the result I get when I use COMMIT TRANSACTION at the end.
<eb1>The...more >>
Timeout expired. Posted by Agnes at 5/30/2005 12:00:00 AM Timeout expired, The timeout period elapsed prior to obtaining a connection
from the pool. This may have occured becasue all pooled connections where in
use and max pool size was reached.
Does anyone know what does it mean???
Thanks a lot
...more >>
encrypte strings and numbers Posted by ofir at 5/30/2005 12:00:00 AM i need a function for encrypte data in t-sql.any idea?
Regards,
Ofir
...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |