|
|
|
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 Nested Select to Join three tables into one result set Posted by Jeff Swanberg at 7/23/2005 7:58:59 PM I'll simplify the table structure that I've inherited in order to try to
explain what I need.
Three tables - ISSUES, USERS and ASSIGN:
ISSUES
IDRecord - Primary Key
Description
DateEntered
USERS
IDRecord- Primary Key
LastName
FirstName
ASSIGN
IDRecord - Primary Key
IDDefRec - m...more >>
Insert scripts Posted by J-T at 7/23/2005 2:08:38 PM I'd like to generate a script which contains insert commands (with full name
of columns and their values) out of the data in one of my tables something
like this:
Insert TBTest(Col1,Col2) Values ('1',2)
I have seen couple of tools which create insert into select ..... sort of
command which ...more >>
I'VE 3 QUESTIONS Posted by Bpk. Adi Wira Kusuma at 7/23/2005 1:52:46 PM FIRST, If I make a view like this:
SELECT *
FROM OpenDataSource( 'Microsoft.Jet.OLEDB.4.0',
'Data Source="D:\";Extended properties=DBase III')...dav
So If it is called from Client, Does Data to be read from client's D:\ or
server's D:\?
If Data is still read from server, how can data be...more >>
How to comair DB objects in Development server with Production server Posted by J-T at 7/23/2005 1:08:34 PM I have couple of Stored procedures and UDFs and Tables which I generated an
script from our development server and our database admin has run that
script on the production server.Unfortunately because of some changes I had
to generate the script two more times and now I'd like to make sure tha...more >>
Debug Sql Server 2005 Stored Procedure in Sql Server Management St Posted by gudia at 7/23/2005 1:06:12 PM I am trying to figure out how to debug a Stored Procedure (SP) from Sql
Server Management Studio. Like in Query Analyzer in Sql Server 2000, where I
could right click an SP and then click debug on it will let me debug the SP.
Of course, I would execute sp_sdidebug 'legacy_on' before doing that...more >>
Internal SQL Server Error (8624) Posted by Craig at 7/23/2005 9:39:03 AM Hi
I am using SQL Server 2000 developer edition with SP4 running on Windows
2000 Pro SP4.
I have two tables as follows:-
CREATE TABLE CURRENTTB
( id int NOT NULL
,ColA nvarchar(10) NOT NULL
,ColB nvarchar(5) NOT NULL
)
CREATE TABLE ARCHIVETB
( id int NOT NULL
,ColA nvarchar(10...more >>
primary role Posted by Ed at 7/23/2005 7:11:04 AM Hi,
Can someone please explain to me when I Configue the Log Shiiping, there
is an option called "Allow database to assume primary role", what does that
really mean and imply?
Thanks
Ed...more >>
problem in instead of Trigger Posted by sathya at 7/23/2005 2:46:37 AM hi,
i am using trigger as below:
alter TRIGGER Docsdelete
ON Docs
INSTEAD OF DELETE
AS
Declare @DeletedDocLibRowId int
declare @Dirname nvarchar(256)
declare @LeafName nvarchar(128)
set @Dirname = (SELECT dirname FROM DELETED)
set @LeafName = (SELECT leafname FROM DELETED)
set @Delete...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
DateTime calculation Posted by quest at 7/23/2005 12:00:00 AM I have two tables "publicholidays" and "RegDate". "publicholidays" simply
stores all the date of a public holidays in a particular year. RegDate
stores the date a user is being registered. I need to perform a calculation
that will calculate the number of days the user has been registered (exclude...more >>
Select and Insert Posted by quest at 7/23/2005 12:00:00 AM How do I select records and insert those selected records into another table
with store procedure ? Any idea ? Thanks.
...more >>
Problem in using fn_dblog() Posted by Pushkar at 7/23/2005 12:00:00 AM Hi,
I am using ::fn_fblog() function to read my on line transaction log.
I am excuting the below query
select * from ::fn_dblog(null,null).
But in [Row Data] I am just getting 0x value and neither I am getting =
any value for [Old Value] and [New Value] column.=20
I am reading this onlin...more >>
Can I make DTS.......... Posted by Bpk. Adi Wira Kusuma at 7/23/2005 12:00:00 AM Can I make a DTS package that its destination place can be variable/input?
Because I want its DTS package can be called by each client to export
client's data. (client's data use Foxpro).
Or May I make Stored procedure to instead it? Give me solution? And give me
its listing code? or not, give m...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |