I am using MS SQL 2000.
I have an existing Stored Procedure (which is quite large), call it spA. spA returns a table of values which include an ID in each row.
I am writing a new Stored Proc...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_23454745.html
I have two problems with SQL
problem 1
I'm using LiveWire Pro to connect to a DB in MS-SQL. I need to return all records entered in the last week or the last 10 days or 2 weeks etc. etc.
proble...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_10029343.html
How to lock logins in the MS SQL Server. Is there a equivalent of the sp_locklogin command?
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_10109521.html
In a two-tier client/server system, when a TTable component opens a huge table, does it actually fetch all records or just part of them? Is there a way to limit the records being passed over the n...
http://www.experts-exchange.com/Programming/Languages/Pascal/Delphi/Q_10340883.html
Dear Sir
thanx on advance
how can I make a connection to MS SQL server inside
1- PL/SQL triggers and procedures
2- DEveloper 2000 forms and reports
than you again
http://www.experts-exchange.com/Database/Oracle/Q_20281529.html
Zones:
OracleDate Answered: 06/20/2002 Grade: A Views: 0
I am using asp with MS SQL 2000. Here is the abbreviated versions of the three tbales necessary to complete this problem.
[tblMember]
Id Int identity seeded at 10000
Username ...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_20548337.html
I have a full back up of SQL 6.5 server from Backup Exec 7.2. The original server no longer exists so I want to create a fully functioning replica. Is it possible? What would the step by step pr...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_20570489.html
I have MS Office XP Developer. I'll admit it is way beyond my abilities.
Somehow with this package I am supposed to be able to distribute my Access databases to computers that don't have Access ...
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_20608506.html
Zones:
MS AccessDate Answered: 05/07/2003 Grade: A Views: 0
I have an MS SQL 7.0 database residing on server A. This database is constantly being updated (every 15 minutes) by a looping VB script that is doing a SQL bulk insert from a text "csv" file.
I...
http://www.experts-exchange.com/Database/Miscellaneous/Q_21304600.html
Zones:
DatabasesDate Answered: 02/07/2005 Grade: B Views: 0
Hey
Im having difficulties connecting to a remote server through ASP.NET. we have our MSSQL database stored there and i've written the code for the site to connect and take the information i nee...
http://www.experts-exchange.com/Programming/Languages/.NET/ASP.NET/Q_21492329.html
