|
|
|
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 Substring for grouping the new file. Posted by NT at 10/6/2007 1:14:18 PM Hi,
Please help...!
I have a Test_Name then I need to break all the texts from after the word
'cycle' to store into the new field as Comments. Please see example below
Test_Name: 73025-003_BnDcycleRestart-01-045
Here is my SQL statement:
SUBSTRING(Test_Name, CHARINDEX('cycle', Test...more >>
DateTime columns in SQLexpress and .NET 2.0 DataAdapter.Update() Posted by Bill at 10/6/2007 10:31:01 AM I am having a problem with DateTime columns in SQLexpress and .NET 2.0
DataAdapter.Update().
I create MyDataTable containing a copy of the data in a table on the server.
The table contains one DateTime column.
DataTable column data type is System.DateTime.
SQLexpress column data type is ...more >>
How to receive selected field in a stored proc in calling stored proc Posted by bz at 10/6/2007 5:35:15 AM Hi,
I have a stored proc that contains a sql that retirns a single value
Like
ALTER PROCEDURE [dbo].[usp_GetAdminGroup]
AS
SET NOCOUNT ON
SELECT group_id as AdminGroupID
FROM Groups
WHERE (group_admin = 1)
I can call it from C# with ExecuteScalar and it returns the selected
val...more >>
I've problem with Insert Posted by Bpk. Adi Wira Kusuma at 10/6/2007 2:01:52 AM Create table TA (
RecID int IDENTITY (1, 1) Primary Key,
C1 char(1)
);
Create table T1 (
RecID int Primary Key,
FName varchar(50),
FAdrr varchar(50)
);
If I want to add a new record, So I do proccess like it:
SELECT TOP 1 @H=RECID FROM
TA WHER...more >>
Problems with smalldatetime Posted by Bpk. Adi Wira Kusuma at 10/6/2007 1:42:27 AM Create Table T1 (
IDREC int Primary Key,
FCTIME SMalldateTime
)
Then I enter data like it;
IDREC FCTIME
-------------------------
1 1/1/07
2 1/8/07
3 1/11/07
4 1/21/07
And I have other table with structure
Cre...more >>
Is it possible to recreate my database from a myDatabase.BAK file? Posted by trint at 10/6/2007 12:45:17 AM I'm working from home this weekend and have somehow deleted
my (local) database from my dev computer to test my c# code with.
All I have on my dev computer is .BAK files I've previously made.
Is it possible to restore the actual database and all 136 tables from
my backups in the .BAK format. So ...more >>
Running Balances Posted by Geoff Schaller at 10/6/2007 12:30:57 AM There might not be an answer to this but I am curious. We have a
transaction system which is kind of generic header/detail. The header
record has these columns:
dDate - Transaction Date
Agent - Payee/Payer party for the transaction (many)
Tranno - Transaction Number (unique)
Details - Tran...more >>
|
Don't see what you're looking for? Search DevelopmentNow.com.
| home · blog · groups | Questions? Comments? Contact the dn |