|
database
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
SQL Server database programmingmicrosoft.public.sqlserver.programming
Insert scripts
J-T -
23 Jul 2005 9:08 PM - 4 messages
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 ...
How to comair DB objects in Development server with Production server
J-T -
23 Jul 2005 8:08 PM - 3 messages
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 that the ...
How to copy DTS package?
Bpk. Adi Wira Kusuma -
23 Jul 2005 8:06 PM - 3 messages
I've created a DTS package. Then I want to copy it to another computer (not networking/stand alone). My imagine, it can be copied to disc. So I can rebuild it form its disc. Is My imagine right? or Can I do it? ...
Debug Sql Server 2005 Stored Procedure in Sql Server Management St
gudia -
23 Jul 2005 8:06 PM - 2 messages
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. ...
Detect installed MSDE version
Etienne -
23 Jul 2005 6:38 PM - 2 messages
I'm building a setup program that needs to install an instance of SQL Server if it's not already installed or if it's not up to date. What I need to know is... how do I know if an instance of SQL Server is installed, and get it's ...
Internal SQL Server Error (8624)
Craig -
23 Jul 2005 4:39 PM - 2 messages
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 ...
Problem in using fn_dblog()
Pushkar -
23 Jul 2005 2:55 PM - 2 messages
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. ...
Can't connect remotely to MSDE 2000 DB on WinXP Home Machine
Macsicarr -
23 Jul 2005 2:17 PM - 1 message
Hi All Having 'Google-ised' I've found that there does appear to be a problem connecting to an MSDE 2000 DB from a remote machine (either LAN or WAN), but I haven't found what the concrete solution is. ...
primary role
Ed -
23 Jul 2005 2:11 PM - 2 messages
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 ...
problem in instead of Trigger
sathya -
23 Jul 2005 9:46 AM - 3 messages
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 @DeletedDocLibRowId = (SELECT doclibrowid FROM DELETED) ...
I'VE 3 QUESTIONS
Bpk. Adi Wira Kusuma -
23 Jul 2005 6:52 AM - 3 messages
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 ...
Select and Insert
quest -
23 Jul 2005 4:56 AM - 3 messages
How do I select records and insert those selected records into another table with store procedure ? Any idea ? Thanks. ...
DateTime calculation
quest -
23 Jul 2005 3:56 AM - 5 messages
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 ...
Create Text Output File
Hoosbruin -
23 Jul 2005 2:19 AM - 7 messages
I have a SQL table defined like this. Item Varchar(30) Type Varchar(10) Lang Char(2) Page Char(1) Comments Varchar(75) Delimited data from the table Abc,,US,1,Commnt1 Abcd,,US,1,Commnt2 Abcde,,US,1,Commnt3 ...
Chat: The Visual Studio Debugger, July 28th @ 1pm Pacific Time
Scott Nonnenberg [MSFT] -
23 Jul 2005 12:50 AM - 1 message
We'd love to see you there! The Visual Studio Debugger "Do you have some burning questions or comments about SQL, C#, VB, C++, or script debugging support in Visual Studio? Want to know more about Visual Studio 2005's enhanced datatips, improved interop debugging, Managed ...
Is there a better way to do this very simple query(s)?
Tom -
23 Jul 2005 12:23 AM - 9 messages
I' m almost certain that my approach is wrong but it works! Could someone tell me the correct way to achieve the following? --- Start Code --- INSERT INTO Categories (Description) SELECT DISTINCT CategoryDescription FROM Import UPDATE Categories SET StatusID = 1 ...
Can I make DTS..........
Bpk. Adi Wira Kusuma -
22 Jul 2005 7:54 PM - 2 messages
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 ...
convert char to int
vickie k. hoffmann -
22 Jul 2005 7:13 PM - 4 messages
Hi all, Is there a function in SQL that will convert letters to numbers corresponding to their placement in the alphabet? For Example: a = 1 b = 2 c = 3 d = 4 ... .. y = 25 z = 26 Thanks! vickie ...
Merge replication
Pipo -
22 Jul 2005 6:44 PM - 8 messages
Hi, I've spend a couple of days now trying to get the Merge replication working on SQL server 2003. I also searched the internet but it still doesnt work :-( The SQL server help didnt help also. (It says to look at samples but I dont have those on my machine...can I ...
Table row counts different
Andre -
22 Jul 2005 6:16 PM - 4 messages
Can someone exlpain why you get different row counts in different places? For example, when I double-click on a table in EM to display the properties of the table and look at the Rows number, that is different than when I query ...
Reasons why DBCC INDEXDEFRAG would not work
Andre -
22 Jul 2005 6:14 PM - 11 messages
I am performing DBCC INDEXDEFRAG on my indexes in a table because I have really bad extent scan fragmentation. After I run it though nothing has seemingly changed. Can someone explain some reasons why this would be happening? ...
Comparing 2 PCs Inventory
FStuart -
22 Jul 2005 6:13 PM - 2 messages
I've decided to try another method to compare 2 PCs inventories via the ADD Remove Displayname. I have the following code I'm trying to use to compare the two and put in the Netbios_Name0 column PTLSTANDARD if it is lacking that software ...
schedule dbcc indexdefrag every Saturday?
Mike -
22 Jul 2005 5:34 PM - 8 messages
How can I set up SQL Server to defragment all indexes on a weekly basis, e.g. every saturday? ...
insert/select
tshad -
22 Jul 2005 4:56 PM - 2 messages
I am trying to find an easier way to handle my insert/select statement. If I have the following tables and query - Is there a way to do this in one statement? create table Master( MasterKey int, ) Create table SubTable1( ...
unique id's
John -
22 Jul 2005 4:55 PM - 5 messages
I need to find the 10 most recent unique ids. Any help would be appreciated. The table structure is : Create table temp (id int, dt datetime) insert into temp SELECT 424, '2005-04-04 16:29:00' UNION SELECT ...
very strange SQL
Steve Drake -
22 Jul 2005 4:26 PM - 6 messages
All, I have been tuning some SQL today, and i came across this problem. I have these statements (these are done to reproduce my problem, the real SQL is much bigger) /* test one */ declare @parent varchar(254) set @parent = '28CD626A-69B4-42C8-8576-3BF9294E6D70' ...
Converting varchar to int
Star -
22 Jul 2005 4:11 PM - 5 messages
Hi, I have a varchar(255) column where I may have data like this: 43294430949 adkk3400 1056 ff1d 10 302 15000043 I would like to write a SQL query that returns values between 10 and 500 (numeric) If I just do this: ...
Complex substring query and value conversion help...
trint -
22 Jul 2005 3:44 PM - 6 messages
Ok, I have to convert the dollar values of some of my fields in a query, if the field to the left (in the left column) has a word that part of the word has "debit" in it. Like this: ...
Aggregates
Mark Thomson -
22 Jul 2005 3:38 PM - 3 messages
I have a simple table that stores name score ------ ----- jim 343 bob 322 jane 122 ...
Trigger Help
Eric -
22 Jul 2005 3:22 PM - 6 messages
Hi - I'm trying to create an insert trigger on a table that will insert an additional record on the same table. When an insert occurs on this table (Trans), I want to check the value of a column ('type') and based on that ...
SQL HELP
MS User -
22 Jul 2005 3:18 PM - 27 messages
I have a table 'TripMovement' with columns CarID, TripType, TripDate, ....... (These three columns form the PRIMARY-KEY) Each trip will have an entry in table 'TripMovement' , there are four different 'TripType' (A, B, C and D) For a trip cycle, Trip will start with type 'A' - 'B' - 'C' and ...
Easy SQL Problem
Mark Thomson -
22 Jul 2005 3:03 PM - 7 messages
I have a simple table that stores name score ------ ----- jim 343 bob 322 jane 122 ...
copy a db, identity problem
Carlo -
22 Jul 2005 2:41 PM - 4 messages
hi i need to copy a db to another db every single table to another similar to the first one but with some difference. When i try to do that i need to remove some constraint and all the identity on the new db. i'd like do that ...
readinf blob data in sql trigger
sathya -
22 Jul 2005 2:30 PM - 9 messages
hi, i am using sql sever 2005 , i want to read binary data and data of computed coloumn using trigger. my table is below: table column ------------ 1) document data -- type (image) 2) userId --------- type(varchar computed column) ...
INSTEAD OF INSERT TRIGGER AND NULL
Dr. Paul Caesar - CoullByte (UK) Limited -
22 Jul 2005 1:47 PM - 10 messages
Hi all, I have created a INSTEAD OF INSERT TRIGGER but I seem to have a problem with NULL values. The trigger checks to see if a suppliers product code enetred is stockable and if so gets the Item Description, Price Each based on Quantity and the VAT ...
SQL Server and ASP EOF/BOF problem
Derek Fisher -
22 Jul 2005 12:22 PM - 3 messages
This is a half SQL Server and half ADO/ASP question. I have a web page that displays a summary of records from a different table depending on what the user selected. I have added a new table and my ASP page (which has worked ...
osql in AD
Enric -
22 Jul 2005 12:20 PM - 3 messages
dear all, "osql - l" works if there is an Active Directory? Regards, ...
Most efficient way to query a remote server
Enric -
22 Jul 2005 11:58 AM - 3 messages
Dear all, Using OPENQUERY or through of server.db.owner.table? Regards, ...
Should I move the ntext field to another table
Craig HB -
22 Jul 2005 11:30 AM - 4 messages
I have an Orders table that includes an ntext field called "Notes". I am considering moving that field into another table called OrderNotes that has a 1-to-1 relationship with the Order table. The reason for this is that I am hoping that this could speed up querying ...
User Defined Function
Douglas Adams -
22 Jul 2005 11:10 AM - 5 messages
I have a database table that contains simply a point: '51.6899, -0.5547' stored as a varchar I want to supply the user defined function with a point of the same varchar format: '51.6899, -0.5547' and I am trying to get it to return the distance to that point. Using ...
tsql help
Neil Evans-Mudie -
22 Jul 2005 9:53 AM - 5 messages
Guys, Using tsql (i.e. sql server) I have a record like: a b c = = = ...
SQLServer 2005 enhancements
Relaxin -
22 Jul 2005 9:02 AM - 3 messages
I can't find a Microsoft list of everything that has been added to SS 2005, but I wanted to know if a DATE and/or TIME datatype was added to SQLServer 2005? Thanks ...
Binary
Leila -
22 Jul 2005 8:34 AM - 9 messages
Hi, I have a column that contains binary representation of numbers. For example '10' for 2 and '11' for 3 and ... I wanted to write a function to convert this column to INT but I thought there might be a built-in function in SQL Server. ...
Subquery Returned More Than 1 Value!
Arpan -
22 Jul 2005 8:24 AM - 3 messages
The following query, which retrieves the tenth costliest product from a table, works fine: --------------------------------------------- SELECT TOP 1 PID,PName,Price FROM Products WHERE PID NOT IN (SELECT TOP 9 PID FROM Products ORDER BY Price ASC) --------------------------------------------- But if the above query is modified slightly by replacing the logical ...
best way to keep a changelog
Allan Ebdrup -
22 Jul 2005 8:20 AM - 3 messages
I have a couple of tables where I want to keep a changelog of all changes made to the table, There are of course different ways to acomplish this, currently our suggesting is a table with oldValue, newValue columns, but ...
Passing result sets
Chan -
22 Jul 2005 8:02 AM - 4 messages
Hi All I have to create a very generic procedure that can accept 2 data sets. These data sets will typically be: 1) Lines of HTML code saved into a table for frequent use but having variable fields which have to be replaced with data depending on the request ...
SQL server does some strange things sometimes.
Michael C -
22 Jul 2005 6:55 AM - 3 messages
I can execute this statement and the view gets created. What suprised me was the comment is also visible in enterprise manager. Once it gets the create view statement does it go backwards and look for comments before hand also? ...
Dynamic SQL Question
ninel -
22 Jul 2005 5:58 AM - 6 messages
I have to get a count of records using dynamic sql.
I have the following and I'm getting errors (Syntax error converting
the varchar value 'SELECT ' to a column of data type int.):
DECLARE @sCalldate varchar(10)
DECLARE @SQL varchar(8000)
DECLARE @RC int
SELECT @sCalldate ='20050712'
SELECT @sEmployeeNameId = '0'
SELECT @sAgentid ='0'
SELECT @SQL = 'SELECT ' + @RC + ' = Count(*)
FROM dbo.tmPunchTime
WHERE scalldate = ' + @sCallDate +
' AND ISNULL(sRawLogout, ''x'') = ''x'''
EXEC (@SQL)
How can I make this work?
Thanks,
Ninel ...
2 databases with same tables..compare rowcounts
Hassan -
22 Jul 2005 4:37 AM - 7 messages
I have 2 databases with the same table names and want to compare rowcounts between them. How can I do so ? I guess the output should look like DB1Name TableName Rowcount DB2Name TableName Rowcount ...
Tenth Costliest Product!
Arpan -
22 Jul 2005 4:01 AM - 8 messages
The following query retrieves the tenth costliest product from a table: ---------------------------------------------- SELECT MAX(Price) FROM Products P1 WHERE 9=(SELECT COUNT(*) FROM Products P2 WHERE P1.Price>P2.Price) ---------------------------------------------- Can anyone explain me the logic behind the above query i.e. how does it ...
to group attribute values of the same id together with sql?
roy -
22 Jul 2005 3:29 AM - 3 messages
Suppose I have a table like this -------------- ID Attribute 1 A 2 B 2 C 3 D 3 E 3 F -------------- How to write a sql query to convert the above table into -------------- ID NewAttribute ...
how to determine a column is or not a identity column
Yuan -
22 Jul 2005 3:25 AM - 2 messages
I do need help now , Thanks for any help. ...
Trouble in setting read_only database in DTS
chin_yen83 -
22 Jul 2005 2:52 AM - 3 messages
I've tried to run this 'alter database mydb set read_write' in my DTS (Execute SQL Task ) but it seem has a trouble the process can't stop ... but if i run it in query analyzer it can run and finish ...
How to find binding errors to views
Hassan -
22 Jul 2005 2:40 AM - 4 messages
I have a view with no table present such as Create table T1 (Col1 int) go Create view V1 as select * from T1 go drop table T1 go select * from V1 I want to be able to run a query against a database that would give me all ...
Speed up selecting from joining table
Shawn -
22 Jul 2005 12:34 AM - 3 messages
I have two tables, Orders & Order_Detail. I was running the following query: select o.num, o.amount, d.code, d.rate, d.order_date from Orders o inner join Order_Detail d on o.id = d.order_id where d.order_date < 'Jan 1, 2005' ...
Database Backup for Log Shipping
Ed -
22 Jul 2005 12:10 AM - 6 messages
Hi, Does the Log Shipping Setup wizard provide any options to do the database backup and restore after the initialization? what if the table structures are changed and stored procedures are added? If not, does that mean I have ...
SSL Endpoint Creation Error
msnews.microsoft.com -
21 Jul 2005 11:12 PM - 2 messages
Hi, In SQL Server 2005, I'm trying to change my endpoint from non-secure to secure. It works great un-secured but when I try to recreate the endpoint by changing the statement From: CREATE ENDPOINT Henry_Endpoint ...
Database Design Question
pete K -
21 Jul 2005 11:07 PM - 5 messages
I'm fairly inexperienced when it comes to database design and programming but since our company is too cheap to hire anyone more experienced, I was hoping someone here could help me out. Our company assembles computers and we want to develop an order processing ...
Should I use table locking?
John Bonds -
21 Jul 2005 10:10 PM - 5 messages
I have a table called BatchIteration (DDL below). There is a IsProcessing bit field in this table. There will be multiple computers running multiple threads processing batches. What I need is a query that sets the IsProcessing bit to true of the "TOP 1" row and at the same time selects the ...
cannot create multiple triggers
agandhi -
21 Jul 2005 10:01 PM - 6 messages
PLS HELP !!!! I cannot create multiple triggers (AFTER) of command type INSERT. When I create a new one the previous one gets deleted. Prodcut: SQL Server Enterprise Edition. Product Version:8.00.194 (TRM). The funny thing is that this happens on clients production environment ...
Error message as a result of a DELETE
renata -
21 Jul 2005 10:01 PM - 2 messages
I'm executing a delete in a table and the result is the error 431: Could not bind foreign key constraint. Too many tables involved in the query. There are no triggers associate with the table. What's this could be? ...
Anything better than TSQL?
Kyle -
21 Jul 2005 9:53 PM - 8 messages
Recently I've been doing a good amount TSQL programming, and I think it is a phenomenal data query language. However, in my view, it may be a little too much so, because with all of its control constructs and additions ...
Date of Database Last Back
Roger -
21 Jul 2005 9:46 PM - 3 messages
Hi, Anyone know how to determine the datetime of the last backup for a database, in code? Thanks, Roger ...
outer join quesiont, pls help!
Jean -
21 Jul 2005 9:19 PM - 5 messages
I have two tables. One (table1) is look up table that has 48 records for time interval. They are: interval 0:00 - 0:30 0:30 - 1:00 1:00 - 1:30 23:00 - 23:30 23:30 - 24:00 ...
GROUP BY
James T. -
21 Jul 2005 9:13 PM - 3 messages
Hello! I am using following dynamic stored procedure to return search results. Evrything works fine... Now I would like to group results by IsFeatured field, but I am receiving error message: "Column 'Table1.Id' is invalid in the select list because it is not contained in either an aggregate function ...
minimum role/permissions for backup
Ed -
21 Jul 2005 9:04 PM - 2 messages
I have a MS SQL database process that is run from ASP.NET. I would like to be able to backup the SQL database using either a full database or transaction log backup immediately before the process is done. Is this possible with ASP.NET and ...
Floating point exception
Britney -
21 Jul 2005 8:33 PM - 4 messages
Hi guys, what is the problem? how can I fix it? DBCC INDEXDEFRAG (0, table1, 2) Server: Msg 3628, Level 16, State 1, Line 1 A floating point exception occurred in the user process. Current transaction ...
obtaining the ip address of connection
Matthew Kempf -
21 Jul 2005 7:59 PM - 13 messages
any one know how the get the ip address of a source connection to my sql server using a query/stored procedure/ex stored procedure etc. essentially to ip address of the "host" process thanks ...
Use a stored procedure from a function
Waterman -
21 Jul 2005 7:32 PM - 6 messages
I'm trying, without success, to get a function to return values calculated in a stored procedure. The reason I'm trying for the sp instead of just using a function is that sp promises to decrease my processing time. ...
triggers
Big D -
21 Jul 2005 6:56 PM - 8 messages
I have an existing trigger and need to add another exception for the trigger. I started out creating another trigger but run into issues with two triggers on the same table. So I dropped my exisiting trigger and want to combine the two into one. ...
returning multiple values through an output parameter
jason -
21 Jul 2005 6:46 PM - 4 messages
given the following table: create table t1 ( id int, description varchar(50) ) and the following stored procedure: create procedure owner.proc1 ( @input1 int, @input2 string, @output1 int output, @output2 string output) as -- unrelated stuff ...
SQL PUZZLE (continuation)
MS User -
21 Jul 2005 6:43 PM - 1 message
Thanks Steve Now I got to solve another issue, as you remember TripType start with A-> B-> C-> D For a given day , if any of the TripType happen (A, B, C, D), I need to populate that carID and all the previous TripDates till A ...
Setting version on SQL Table
Hari -
21 Jul 2005 6:36 PM - 5 messages
Hi Guys, Iam trying to set a version number to a database table. The main reason is if i add a new column later on i will be able to make sure that table schema need to be updated. I have tried updating the version column in the sysobjects for that table. ...
How to delete so good?
Bpk. Adi Wira Kusuma -
21 Jul 2005 6:10 PM - 4 messages
I ask to you. How to delete data at table A that exist at table B. Usually I write like this: DELETE FROM TA where NOID in (SELECT NOID FROM TB). But it can works, if at table A (TA) has 1 field to be primary key. If table ...
database is marked in LOAD
Britney -
21 Jul 2005 5:37 PM - 3 messages
If I put it inside Transaction, then it shouldn't happen again right? BEGIN TRANS ....... ...
Defragment all indexes in a database?
Mike -
21 Jul 2005 5:14 PM - 5 messages
How can I defragment all the indexes in my databases using dbcc indexdefrag? ...
Inserting records back into temp table that don't exist
Frank N via SQLMonster.com -
21 Jul 2005 5:13 PM - 2 messages
I have a procedure that I'm trying to produce for a client. They want to see total order counts each day from the 1st to the end of the month. The procedure I have now will produce order counts for days that do exist. It ...
Using DATEADD() to find the week ending date
Vinod Thomas -
21 Jul 2005 5:11 PM - 5 messages
Hi, Our company has changed the workweek as Saturday to friday . Previously it was Sunday to saturday. I am trying to determine if a given date falls within the week ending date and is using the following formula, but for saturdays, ...
Perplexing Problem with tsql join.
firebalrog -
21 Jul 2005 4:44 PM - 5 messages
I have been trying to figure this out for some time and I am sure there must be an easier way than using a cursor. Given the following table (simplified example): ID CUSTID DTE ...
I've problems.
Bpk. Adi Wira Kusuma -
21 Jul 2005 4:34 PM - 5 messages
I've 3 problems. First, I've data like this: Date1 Date2 -------------------------- 1/1/2005 1/7/2005 {m/d/yyyy} ...
An mdm.exe that supports SQL attach wasn't found
Jeff Grundy -
21 Jul 2005 4:29 PM - 2 messages
When I attempt to step into a stored procedure from Visual Studio.Net the procedure runs without stopping on any of the breakpoints. I also receive the message "An mdm.exe that supports SQL attach wasn't found on ''. SQL attach ...
Dy
ninel gorbunov via SQLMonster.com -
21 Jul 2005 4:28 PM - 3 messages
I have to get a count of records using dynamic sql. I have the following and I'm getting errors (Syntax error converting the varchar value 'SELECT ' to a column of data type int.): [Code] DECLARE @sCalldate varchar(10) , @sAgentId varchar(10), @sProject varchar(10) ...
SQL Server Stored Procedure Problems
MikeG -
21 Jul 2005 4:25 PM - 2 messages
I'm hoping someone can help with a problem I've bene having ever since I started using SQL Server. Every time I get into a stored procedure, the 'GO's are stripped off and extra commands are placed at the end. I also ...
Log Shipping
Ed -
21 Jul 2005 4:16 PM - 3 messages
Hi, I have a couple of questions about Log Shipping. If i am not mistaking, the log shipping is basically backup the database and log file and copy the files to another server e.g. Standby Server. My first question is, what is the different between Log Shipping and ...
Simple Query
John -
21 Jul 2005 4:04 PM - 3 messages
I'm struggling with what i think should be a very simple query I have a table called vp which has several fields, the ones i am interested in ar vp_id, Version, Lastupdate_date and ln_no vp_id version lastupdate_date ln_no ...
Urgent! - time out errors while inserting into the dB
Mike -
21 Jul 2005 3:27 PM - 9 messages
I am getting time-out errors in my web application on pages which involve inserts into the dB. The application has not changed a bit so it is not a problem with the ASP code, Please help me trouble shoot and fix this problem. ...
DISTINCT Values
JLFleming -
21 Jul 2005 3:25 PM - 4 messages
I am trying to run a query to one of two delete duplicates records. The process I normally use is use 1) SELECT DISTINCT from the table into a second table 2) Delete all duplicate values in original table ...
Help with tricky update statement
Griff -
21 Jul 2005 3:21 PM - 6 messages
I have a table that is ~ 25 fields wide and ~ 35,000 rows deep. I need to update it in a particular way and have no real idea the best way to go about this. Ignoring the majority of the fields, let us imagine that there are 10 ...
storedproc slow compared to Analyzer Help
paolol -
21 Jul 2005 2:45 PM - 4 messages
Hi, we have a big stored proc wich take 15 second to run on the analizer but the same query as a strored proc take 90 sec. Can any one let me understand the difference ?? Thanks to all Paolol ...
Reading a log file
Ivan Debono -
21 Jul 2005 1:22 PM - 3 messages
Hi all, Is it possible to read a log file to see what changes have been done on a particular table at a particular time? And if yes, how? Thanks, Ivan ...
Cannot use the OUTPUT option when passing a constant to a stored p
chieko -
21 Jul 2005 1:11 PM - 6 messages
Hi, I'm trying to export a text column into a text file using the bcp command but I keep getting the error message in the subject line. So I checked the database properties and didn't find anything. My Code: ...
Is it possible to turn off logging for a statement, proc, or table?
John -
21 Jul 2005 1:09 PM - 9 messages
Hi, I have a proc which calculates a large dataset and stores all output into a single table with a calculation id field to identify it. The output is anywhere from 300k rows to 3m rows per calculation. My problem is, the backup log keeps filling up and gives me an error : ...
Comparing date only?
Robin Tucker -
21 Jul 2005 12:57 PM - 6 messages
This is probably a really simple one: Given a table with a DATETIME column, how can I do an = or <> comparison with just the date part? ie. SELECT * FROM MyTable WHERE SOMEFUNC(MyTable.theDateTime) <> SOMEFUNC(@_In_theDataTime) ...
Move a question or comment
x-rays -
21 Jul 2005 12:56 PM - 7 messages
Hello Microsoft Developers of newsgroups. I have a suggestion that must propably have thought already. Place a listbox (newsgroups will listed) to move a question (or a comment) from a newsgroup to another, many times questions are asked to irrelevant ...
Using WEDAV & SQL Queries on MS EXCHANGE 2000 to parse emails...
Warren -
21 Jul 2005 12:49 PM - 2 messages
Wondering if anyone has tried to parse email from an MS Exchange 2000 server user account using WEBDAV SQL Queries? I found a good article at [link] , but I am having problems ...
import a text file without commas to an sql table
Sam -
21 Jul 2005 12:47 PM - 4 messages
how i can import a text file without commas to an sql table, knowing the subject of every clomn in the text file (col 1 to col 8- name, col 9 to col 15 - address e.c.)? ...
cannot open query analyzer and profiler through EM
x-rays -
21 Jul 2005 12:30 PM - 6 messages
Hello Experts, My problem is that I can't call QA and Profiler through Enterprise Manager from the tools menu. I made some MSDE installations and UnInstallations for debug reasons and then this problem occurred. Step 1) Installing an named instance "MYINSTANCE" ...
proxy account for xp_cmdshell fails every few hours
I.P. -
21 Jul 2005 11:56 AM - 3 messages
Hi, I defined a proxy account that executes the xp_cmdshell. It is a local user. Everything works fine for few hours, my web users are logging into the application while this proxy account checks for identification by an xp_cmdshell. After few hours the application generates an error message for users who are ...
Date and time
Hugo Madureira -
21 Jul 2005 11:53 AM - 4 messages
Hello all! I want to create a time stamp based on the system date and system time. The format of my timestamp should be YYYYMMDDhhmmss. YYYY year MM month DD day ...
2 tables from 2 different databases in a view
Sam -
21 Jul 2005 11:40 AM - 4 messages
how can i use 2 tables from 2 different databases in a view? thanks ...
|
|||||||||||||||||||||||