Sponsored Links

comp.databases.ms-sqlserver comp.databases.ms-sqlserver

Page 50 of 282

Threads in Forum : comp.databases.ms-sqlserver

Forum Tools

Rating Thread / Thread Starter	Last Post	Replies	Views
Connecting to SQL 2005 using VB6 Is there some reference material that shows how to connect to a SQL 2005 DB using Visual Basic 6? Any help is appreciated. Charlie	06-29-2007 05:36 PM Erland Sommarskog	1	40
Mass Update on Table with Trigger Hi, I need to update a field in about 20 records on a table. The table has an update trigger (which updates the field whenever a record is... paulmac106@gmail.com	06-29-2007 05:29 PM Erland Sommarskog	2	49
XML INTO SQL I need to open a newly created xml doc (in the same format) each time a new one is sent to our web service. I would like to use a stored procedure... KEN	06-29-2007 05:27 PM Erland Sommarskog	3	42
question about a query I've written this query: select distinct topics, questions, answer from topics AS A, QuesNans AS B where A.topicid = B.topicid order by... nina297	06-29-2007 09:00 AM nina297	3	45
Scope in derived tables This is kind of what I'm trying to do in my MS SQL 2000 query. Should I be able to reference s1.col1 inside the 2nd derived table? I'm getting... Stephen2	06-29-2007 07:13 AM Erland Sommarskog	1	43
problem in date comparison I have a problem in this query: select order from ordertable where orderdate >= '06/20/2007' and orderdate < '06/21/2007' this query do not return... navneetkasulkar@gmail.com	06-29-2007 05:04 AM navneetkasulkar@gmail.com	5	268
problem about comparing date I have a problem in this query: select order from ordertable where orderdate >= '06/20/2007' and orderdate < '06/20/2007' this query do not return... navneetkasulkar@gmail.com	06-29-2007 05:00 AM navneetkasulkar@gmail.com	2	48
SELECT QUESTION Here is my problem: I have two tables. Table1 contains two fields. Field1 contains names of job types (Accountant,Doctor,etc.) Field2 contains the... k4	06-28-2007 05:31 PM Erland Sommarskog	1	57
Strange performance issue with UPDATE FROM ( 1 2 ) Hello! I have this piece of SQL code: UPDATE a SET Field1 = c.Field1 FROM a INNER JOIN b ON a.GUID1 = b.GUID1 INNER JOIN c ON b.GUID2 =... Richard	06-28-2007 05:12 PM Alex Kuznetsov	10	171
Is Not Null and Query Optimization How does the phrase "Is Not Null" in the where clause effect the effectiveness of a query? If it is a determent to the effectiveness of the query,... db55	06-28-2007 04:35 PM Erland Sommarskog	3	45
Forcing an IDENTITY column to have a certain value All, Is there any way to _set_ an IDENTITY column to have a certain value so as to create a gap in the set of identity values on purpose? All I've... Weyus	06-28-2007 03:31 PM Gert-Jan Strik	3	42
How to make a SQL run longer? Hell All, To reproduce one of our cusotmer's probem, I need to make the SQL to run for more than a minutes before it returns the result set. I do... Raj	06-27-2007 06:30 PM Raj	8	53
How to reliably ensure that only one set of rows is bulk imported into a table at a time All, I need to do some bulk loading of data, and in order to do it, I need to be able to do the following: 1) Retrieve the current identity value... Weyus	06-27-2007 05:28 PM Erland Sommarskog	5	46
How to find the maximum possible value of a given datatype Does anyone know of a built-in function to return the maximum possible value of a given datatype? I have to return the biggest value for... jshunter@waikato.ac.nz	06-27-2007 02:26 PM Gert-Jan Strik	6	290
Parse field into multiple rows Hello, I am loading data from our MS Active Directory into our data warehouse. (check out Mircosofts's Logparser, it can pull data from ADS, server... rcamarda	06-27-2007 01:30 PM Plamen Ratchev	3	273
sum columns into column in same table I have inherited a database that tracks if a customer ordered a product, with 1 being a yes and 0 being no. What I want to do is sum those columns... azriley@gmail.com	06-27-2007 01:09 PM azriley@gmail.com	4	43
mass alter table fields - script help Hello, I need to alter fields in all my tables of a given database, and I would to do this via a t-sql script. Example, I want to change all fields... rcamarda	06-27-2007 11:25 AM rcamarda	2	310
Free client All, I'm new to MS SQL Server and I'm wondering if there is a free client that will allow me to connect to a remote SQL Server instance. Currently I... Sashi	06-27-2007 08:07 AM Erland Sommarskog	1	278
sql Cannot resolve collation conflict equals - comparing rows and fileds between Table1 and View1 Hello, I currently have Table1 and View1. View1 is a query from 2 or 3 tables that works fine on its own. However in my current query if I try to... Yas	06-27-2007 06:55 AM Erland Sommarskog	1	296
Concat tables into one row in view If I have table1 and table2 with table2 having multiple rows tied to a single row in table 1. What I am trying to do is set up a view that has one... M@	06-27-2007 03:29 AM Erland Sommarskog	3	41
Stored Procedure definition not updating, causing DTS copy error I've got a weird one here. I'm running a DTS package on SQL Server 2005. It copies a bunch of stored procedures. I renamed them on the originating... jshunter@waikato.ac.nz	06-26-2007 10:07 PM Roy Harvey	1	291
select alias -- invalid column name Hi, I got 'Invalid Column Name NewCol1' when I query the following: Select col1, col2, (some calculation from the fields) as NewCol1, (some... sweetpotatop@yahoo.com	06-26-2007 04:29 PM Hugo Kornelis	5	40
Database design question - Isolated, unrelated tables ( 1 2 ) Hi, I have a question regarding best practices in database design. In a relational database, is it wise/necessary to sometimes create tables that... nyathancha@hotmail.com	06-26-2007 04:14 PM Hugo Kornelis	14	68
Deadlock transaction I have a customer using our program with SQL server and is occasionally getting a "Transaction (process ID xxxxx) was deadlocked on lock resources... Altman	06-26-2007 01:36 PM Alex Kuznetsov	5	44
MSSQL - DTS Package - Find distinct rows - Output to TXT file - ActiveX? Hello All, I am trying to create a DTS package. I have two tables tbl_A and tbl_B with similar data/rows but no primary keys. tbl_A is master. I... jb1	06-26-2007 12:12 PM Ed Murphy	7	60
Using the same column in bother SUM and ORDER BY? How? Hello, Using SQL 2005. Columns: ID, int (PK, auto-increment by 1) WorkHours, int Name, varchar(100) I can't seem to get the following query to... webdevaccount@gmail.com	06-26-2007 11:54 AM Ed Murphy	3	276
compare 2 values in same solumn I am trying to compare the last two values in the same column of a table. First of all, I have a column titled Row_Index that uses an index which... mcolson	06-26-2007 09:19 AM Roy Harvey	5	37
sql profiler trace file im trying to understand how the profiler works. so i started 2 profilers,one listen to another and I saw the profiler is running: exec... ofirmgr@gmail.com	06-26-2007 07:55 AM Dan Guzman	1	31
SQL 2000 date format problem after migration W2k to W2k3 Hello, We are using SQL server 2000 on W2k Server and MS Access 2000 ADP (like front-end). Now we try to change operating system for SQL Server 2000... Maciej07@gmail.com	06-25-2007 06:02 PM Erland Sommarskog	1	35
Trigger Deadlock I am doing an update to set a field value = anothe field value (in the same table) where it is not supplied. I'm handling this in the trigger, but am... DennBen	06-25-2007 05:56 PM Erland Sommarskog	1	284
problem with highscore Hi folks I have a little problem converting from an access database to the SQL server I need to have a highscore that shows the top 10 scores,... zuuperman	06-25-2007 08:32 AM Roy Harvey	2	46
Parallel build and subsequent re-name of a cube Hi Folks, I'm not certain if this is the correct group to post this question in, if there is a more appropriate one please advise. We have a cube... Tim	06-25-2007 05:50 AM Tim	0	132
DB hostname, username, password etc I'm trying to get into an installation of v.6.5 to use with another server and I need the following information: Database hostname Database... MackTheKnife	06-25-2007 03:26 AM Erland Sommarskog	1	43
MS SQL Linked Servers(Linking MySQL to MS SQL) Collation problem. Hello, I have a problem. I've linked MySql server to MsSql, in MySql I have a table with Latvian data(character set is ucs2, ucs2_general_ci) and the... =?utf-8?B?UMSBdmVscyBNaWhhaWxvdnM=?=	06-25-2007 02:48 AM P vels Mihailovs	2	294
Foreign Key Hi Friends, Is there any way to get the table name which is referenced by the foreign key for example: consider two table "Staff" and... ArunDhaJ	06-23-2007 09:00 AM Marcin A. Guzowski	1	280
BULK INSERT ignores UNIQUE index with IGNORE_DUP_KEY set? All, Just want to make sure that I understand what's going on here. I have a table with IGNORE_DUP_KEY set on a unique, multi-column index. What... Weyus	06-23-2007 05:09 AM Erland Sommarskog	2	266
Re: correct syntax for this select in SQL Server? Jim Lawton (usenet1 (AT) jimlawton (DOT) TAKEOUTinfo) writes: In SQL Server, you need to provide an alias for the derived table: SELECT * FROM... Erland Sommarskog	06-22-2007 05:33 PM Roy Harvey	1	40
Unable to connect to SQL Server Express Locally or Remotely I have read all of the posts regarding this subject as well as 3 "Dummies" guides and I keep having the same problems. I have a very simple... Billy	06-22-2007 05:29 PM Erland Sommarskog	1	38
finding mismatched rows between identical tables based on 2 or more cols CREATE TABLE ( (10) NULL ) CREATE TABLE ( (10) NULL ) rshivaraman@gmail.com	06-22-2007 10:00 AM rshivaraman@gmail.com	6	54
Data base encodings Hi, I am looking to check and set the encoding of the database using sql commands that work both for SQL-Server and JET. something equivalent to... maarten	06-21-2007 06:18 PM Erland Sommarskog	1	284
Migrating SQL 2000 to SQL 2005 Hi Friends, Is there any tool or assistant to upgrade SQL 2000 to SQL 2005. Thanks, Arunkumar Oonz	06-21-2007 06:10 PM Erland Sommarskog	2	39
Viewing backup in a different location i have a copy of a SQL Server 2000 database on an external hardrive. I have SQL Enterprise Manager 2005 on my laptop and was wondering if it is... Steve F	06-21-2007 06:02 PM Erland Sommarskog	1	39
mdac 2.8 and sql 2005 cursor performace issue Hello I have a VB6 application using classic ado (MDAC 2.8) for connecting ms sql 2000 server. Application uses a lot of server side cursors. Now I... szymon.strus@gmail.com	06-21-2007 05:48 PM Erland Sommarskog	5	37
User ip tracking Hello everyone, I have a fairly unique need :) I am trying to determine the use/clients for databases in my corporation that I am maintaining, but... jlaustill@gmail.com	06-21-2007 09:08 AM jlaustill@gmail.com	2	39
Read Backup File Directly? Is there a way to read a backup file to see if it contains a file without restoring the backup file? We are missing a record from a table, and I... Neil	06-20-2007 05:58 PM Neil	2	34
Win2003 / Sql2000 Memory usage I have googled by heart out trying to find answers to this and am only more confused. DB Server: Windows Server 2003 Enterprise 4 GB memory SQL... michael	06-20-2007 05:17 PM Erland Sommarskog	1	36
I need to find the rows that exist in one table but not in the other with condition I need to find the rows that exist in one table but not in the other with this condition: (prod_name exist in table1 and not in table2.prod_name )... yuval	06-20-2007 04:55 PM Hugo Kornelis	2	31
SQL Duplicate Error Hi! I am trying to do a simple udpate on a table and I am getting the error: "Cannot insert duplicate key row in object 'UserInfo' with... SJ	06-20-2007 03:27 PM Roy Harvey	4	45
SQL - how to - minimum number of steps Hi. I have an 'Attendance' table like this: PIN Year Category Days 1 2006 Authorized 1 1 2006 Available ... Radu	06-20-2007 11:12 AM Jason Lepack	4	55
How to export/import database Hi I`ve Ms SqlExpress 2005 and question how to export/import all databases to/from file. Bcp.exe can do it but only for a table I think. Pls... mw	06-20-2007 06:32 AM Dan Guzman	1	35

Page 50 of 282

Forum Tools	Search this Forum
Mark This Forum Read View Parent Forum	Search this Forum : Advanced Search

	New posts		Hot thread with new posts
	No new posts		Hot thread with no new posts
	Thread is closed

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts vB code is On Smilies are On [IMG] code is On HTML code is Off