MS Access to SQL Server Image
I have a Sql Server 2000 database. We don't have Web resources available, so I must write a User Interface in MS Access 2003. What I want to do is have the user supply a path and name for a document. Then I want to load the document into the Image field of the SQL Server DB. I have found some...
I have a Sql Server 2000 database. We don't have Web resources available, so I must write a User Interface in MS Access 2003. What I want to do is have the user supply a path and name for a document. Then I want to load the document into the Image field of the SQL Server DB. I have found some...
0 pts.
SQL Server 2000/2005 - Creating Unique Constraints allowing multiple NULLs
Hi there! I'm having a problem maintaining data integrity on a database table in MS SQL-Server 2000. To ensure maintaining the integrity I need to implement a Unique Constraint on one of my coloumns. The problem however is, that this coloumn also has to allow multiple NULL-values - but for every...
Hi there! I'm having a problem maintaining data integrity on a database table in MS SQL-Server 2000. To ensure maintaining the integrity I need to implement a Unique Constraint on one of my coloumns. The problem however is, that this coloumn also has to allow multiple NULL-values - but for every...
tutorials-2
hi all. i have sent before a message about this subject but i didnt really had real replies that helped me. i am searching of tutorials of programming (delphi, linux, perl, python, c#, java ......) i have search in google, altavista, westciv, whatis, w3school,... So if anyone now how to get pdf...
hi all. i have sent before a message about this subject but i didnt really had real replies that helped me. i am searching of tutorials of programming (delphi, linux, perl, python, c#, java ......) i have search in google, altavista, westciv, whatis, w3school,... So if anyone now how to get pdf...
tutorials
hi all. i wanted to ask if anyone knows any sites where i can download free ebooks or free tutorials. thx.
hi all. i wanted to ask if anyone knows any sites where i can download free ebooks or free tutorials. thx.
SQL Server Stored Procedure Editor
I'm looking for a good editor for T-SQL stored procedures. Preferably one that will color-code keywords like what the default editor does, but will allow search and replace functionality as well as printing capabilities. Considering the budget I have, no to low cost would help as well. Thanks in...
I'm looking for a good editor for T-SQL stored procedures. Preferably one that will color-code keywords like what the default editor does, but will allow search and replace functionality as well as printing capabilities. Considering the budget I have, no to low cost would help as well. Thanks in...
Library management system
i need a free library management system running on window or linux that can keep track of who has what cd/books any one help plse
i need a free library management system running on window or linux that can keep track of who has what cd/books any one help plse
DB2 function
Hi! I am using following expression in report filter. It gives parsing error. Presentation Layer].[Recent Claims].[Specific Service Date YMD] BETWEEN (?Parameter1?) AND ((?Parameter1?) - 200 DAYS). The database is DB2. Please let me know what is wrong? Thanks a lot,
Hi! I am using following expression in report filter. It gives parsing error. Presentation Layer].[Recent Claims].[Specific Service Date YMD] BETWEEN (?Parameter1?) AND ((?Parameter1?) - 200 DAYS). The database is DB2. Please let me know what is wrong? Thanks a lot,
ASP.NET performance degradation
I'm running ASP.NET 1.1 on a Win2k server, application is written in VB.NET, with SQL server 2000 db on another box. ASP.NET application has very large pages with very complex data filled controls, but is only used on an Intranet by a small number of people. When users initially login, it...
I'm running ASP.NET 1.1 on a Win2k server, application is written in VB.NET, with SQL server 2000 db on another box. ASP.NET application has very large pages with very complex data filled controls, but is only used on an Intranet by a small number of people. When users initially login, it...
calculation at database level
Hi! I will really appreciate help. Please take a look at few rows of one table . MBRNO Readmit READMIT DATE READMIT Readmit Seq. NO DISCHARGE date NO. of days 121 1 20030101 ...
Hi! I will really appreciate help. Please take a look at few rows of one table . MBRNO Readmit READMIT DATE READMIT Readmit Seq. NO DISCHARGE date NO. of days 121 1 20030101 ...
exception join
SELECT GRPID, MEMBER.PLNCD, MBIDT, MBSEX FROM MMEMBER EXCEPTION JOIN GPLANMAS ON MMEMBER.PLNCD = GPLANMAS.PLNCD This is a query used in showcase tool. It is looking for members who are noted in the member file with an invalid plan code. The current query produces 18 members with either...
SELECT GRPID, MEMBER.PLNCD, MBIDT, MBSEX FROM MMEMBER EXCEPTION JOIN GPLANMAS ON MMEMBER.PLNCD = GPLANMAS.PLNCD This is a query used in showcase tool. It is looking for members who are noted in the member file with an invalid plan code. The current query produces 18 members with either...
Oracle query to count rows in tables
Does anyone have a PL/SQL script to count the rows in all the tables in a given schema? No use reinventing the wheel... TIA, Mike
Does anyone have a PL/SQL script to count the rows in all the tables in a given schema? No use reinventing the wheel... TIA, Mike
Integrating Connect:Direct with Sql Server DTS
Don't know if any body has managed to - but i need to start a C:D process from within a DTS script. all the components are working independantly - however DTS waits indefinitely for the C:D process to finish - it does not seem to receive the return code. (or process it properly) Any Help/ideas...
Don't know if any body has managed to - but i need to start a C:D process from within a DTS script. all the components are working independantly - however DTS waits indefinitely for the C:D process to finish - it does not seem to receive the return code. (or process it properly) Any Help/ideas...
Difference between Sql Server 7 & Sql Server 2000
Hi, Can you tell me difference between Sql server 7 and Sql Server 2000?
Hi, Can you tell me difference between Sql server 7 and Sql Server 2000?
Convert date format from UTC to PST in SQL
HI Friends Is there any way to convert date format from UTC to PST? Thanks and Regards Ashu
HI Friends Is there any way to convert date format from UTC to PST? Thanks and Regards Ashu
Database comparison
I know this is 'cheating' but i was wondering if anybody had a quick way to compare two SQL2000 databases at an object level. I need to check the design of tables, code in Sp's etc. I think this can be done using systables, however i was wondering if anybody had done this and how easy it was. All...
I know this is 'cheating' but i was wondering if anybody had a quick way to compare two SQL2000 databases at an object level. I need to check the design of tables, code in Sp's etc. I think this can be done using systables, however i was wondering if anybody had done this and how easy it was. All...
Returning Multiple result sets to Excel
I need to return a full result set including a number of Sum(s) Max(s) etc to an excel spreadsheet (don't ask why) from a Stored procedure on MS SQL2000. Problem is that Xcel can only handle a single result set per sheet... Any Ideas?
I need to return a full result set including a number of Sum(s) Max(s) etc to an excel spreadsheet (don't ask why) from a Stored procedure on MS SQL2000. Problem is that Xcel can only handle a single result set per sheet... Any Ideas?
TopIndex property for .NET Web ListBox
I'm trying to automatically scroll down to the last inserted item in a multi-select ListBox when only a few of the total # of rows are visible. Windows.Forms ListBox control has a TopIndex property that allows you to do that, but there is no similar property for the Web control. Note: In a single...
I'm trying to automatically scroll down to the last inserted item in a multi-select ListBox when only a few of the total # of rows are visible. Windows.Forms ListBox control has a TopIndex property that allows you to do that, but there is no similar property for the Web control. Note: In a single...
How to purge records from the database?
I am a newbie to database programming and have been given this project where data older than 7 days need to be removed from multiple tables that the application uses. I am thinking about creating a stored procedure to do that and schedule a job that will run this stored procedure everyday. Not sure...
I am a newbie to database programming and have been given this project where data older than 7 days need to be removed from multiple tables that the application uses. I am thinking about creating a stored procedure to do that and schedule a job that will run this stored procedure everyday. Not sure...
Calling a Function which uses ado command object in ASP
Hi... I am calling a function or sub if u may call it from within the same page. it works fine until i execute a ado command object. as soon as i put the execute statement in the page, all activites stop and the page doesnt execute any further from the line calling that function. can u help me plz?...
Hi... I am calling a function or sub if u may call it from within the same page. it works fine until i execute a ado command object. as soon as i put the execute statement in the page, all activites stop and the page doesnt execute any further from the line calling that function. can u help me plz?...
