Home All Groups Group Topic Archive Search About

SQL Server database programming

microsoft.public.sqlserver.programming
Score permission for entrance of null data
Frank Dulk - 14 May 2005 10:24 PM - 3 messages
I have a table field with type of data varchar, without permission for entrance of null data Doubt: If I don't type anything in the field, the validation of null values at table level usually happens, however if I type some text and later to ...
Score How would that code be in SQL Server?
Frank Dulk - 14 May 2005 9:50 PM - 2 messages
How would that code be in SQL Server? UPDATE BASE SET BASE.cpf = "0"+[cpf] WHERE ((Len([cpf])="10")); ...
Score Check all SPs from a script
Just D. - 14 May 2005 8:50 PM - 4 messages
It's known that the SQL Server doesn't check the SPs and views when we modify the tables and if we try to use these old SPs after we applied any modifications like column names to the tables we'll get very serious ...
Score master + movement records
Kriste L - 14 May 2005 6:39 PM - 2 messages
Hi Everyone, In the table 'Account', it store when customer inject amount into his account. In the table 'Investment', it store the transaction when the agent buy/sell bonds for the customer. The amount is always of 100 flat value. Now, the customer request a monthly statement of account to be sent to him. He wants to know how much per amount injected in the account will last before he make the next deposit into the account. ...
Score problem with "subquery returned more than 1 value"
The Gekkster via SQLMonster.com - 14 May 2005 5:37 PM - 5 messages
Hi guys, I'm getting an error of 'subquery returned more than 1 value' when I try to run this, which I guess is because the @remoteID is being set to a SELECT that returns multiple rows. How do I go about this so that I can accomplish ...
Score Retrieving data from multiple tables
Gus Gustafson - 14 May 2005 5:29 PM - 17 messages
In the database are two tables. One contains data that is pending some sort of resolution; the other contains data that has been approved for further use. Both tables contain the same attributes. When pending data is approved, that tuple is moved to the approved table and removed from the pending table. ...
Score quick SELECT statement question
Rudy - 14 May 2005 4:59 PM - 5 messages
Hello all! I have a date/time column on my table.  How can I write a select statement to pick only items from todays date?  I looked, but can't find an answer. SELECT * User FROM TABLE WHERE datecolumn = "todays date" ...
Score Re: inner join with parameters on 2 DataTables
Adrian Moore - 14 May 2005 4:41 PM - 1 message
The join syntax is not support by the DataTable Select method.  You'll need to write code to implement the join. You might also want to check out this web-site that promises to provide a ..NET component to allow full SQL syntax queries against a DataSet. ...
Score backup
js - 14 May 2005 3:02 PM - 3 messages
Hi, I backup db log in every 2 hours during day, and a full backup at midnight, when is the best time to shrink database log file? before full backup or after? ...
Score Counting result
Kutlan - 14 May 2005 2:10 PM - 8 messages
Hi Champs! I have a tricky sql problem, and I would apreciate some help from you. In my SELECT statement my result looks like this: ID----name----city----number 1 ---- lfkjdfl---djdjjd---1212 2----- mdsf-- safta----1212 3-----jsert----agjyt----1212 ...
Score update database I don't know its name till runtime
Ahmed - 14 May 2005 9:31 AM - 3 messages
Hi all, I want to insert a row in a table that resides in DB on another server. I don't know the database, server, username and password till runtime. The stored procedure will take 4 arguments represent the connectivity ...
Score How do I find the oldest record in a table
Kjell Arne Johansen - 14 May 2005 8:57 AM - 4 messages
Hi In one of my tables in the MS SQL database all records are time stamped. I want to know what is the oldest record. I have used SELECT TOP 1 * FROM <table> WHERE Time > May 12 1990... ...
Score Copy data from one MS SQL database to another
Kjell Arne Johansen - 14 May 2005 8:48 AM - 8 messages
Hi The old database layout is very slow on queries so I have created a new layout and want to copy the data from the old database into the new layout. How can this best be done? Do I need an application do this or can it be done by the SQL Server running ...
Score Regarging the Blank Field in SQL Server
Himanshu - 14 May 2005 5:20 AM - 3 messages
hi all, can anybody tell me that how will i prevent to store the blank fields in any table. if i uncheck the allow null property of a field in a table then it only bloks null values. bit through application ehwn i store values from a ...
Score Generate SQL fails - Check existing data...
Sparky - 14 May 2005 3:12 AM - 1 message
Context:  SQL Server 2000 Personal Edition on Windows 2000 Pro.               I designed a table using the design view and forms.               No data added. ...
Score Check if image column is empty
krygim - 14 May 2005 1:11 AM - 6 messages
Currently I use the follow Select statement to test if a non-nullable image column is empty and not null: Select Case When Substring(ImageColumn,1,1)='' Then 1 Else 0 End As IsEmpty Can any body show me a better way to check if a column (non-nullable column) ...
Score SQL Server 2000 - Copying database to @today
Kevin - 14 May 2005 1:05 AM - 6 messages
Hi, I am trying to figure out how I can copy a database and all the db user objects within it to a new database that has today's date as a part of the name. The only way I know is to run below and create/populate and tables ...
Score add column
Laura K - 13 May 2005 11:00 PM - 19 messages
I have a table with only about 40 rows.  For some reason we accidentally forgot the primary key.  Is it possible to add a column to this table that adds a number to each row and also adds an increment of 1 when a new item is ...
Score Converting varchar to decimal
Terri - 13 May 2005 9:50 PM - 5 messages
I'm have a varchar(50) field that I want to convert to decimal. These are two samples: +000000063451473.38 -000000038818201.42 Logically I want to: -remove the + sign and leave the - sign -remove any leading 0s My desired outcome is: ...
Score Simple Transaction
MAF - 13 May 2005 9:15 PM - 5 messages
I am wrting a script that inserts data into a table based data I retrieve using a cursor.  I want to setup the entire query in a transaction.  How do I setup a transaction?  How do I trap errors to rollback? ...
Score delete duplicate rows
Mike - 13 May 2005 8:20 PM - 4 messages
I have a table with 1 column (email). I use this table to import values. I want to delete duplicate emails in this. How can I do it? ...
Score Databases not available through QA for some users
Bill Orova - 13 May 2005 7:19 PM - 2 messages
Hey All Gurus, Why on a large environment with many users, when you attach to QA the systyem says on a pop up message that several databases are not avail for viewing. These users are members and logins have the correct ...
Score stored procedures and qa
Claude Hebert - 13 May 2005 7:14 PM - 6 messages
example: table1 has column1, column2, column3 i create a script to make a stored procedure in query analyzer: create proc test1 as     alter table to add column4     update table1 to set column4 = to something ...
Score =ALL and <>ALL
§Chrissi§ - 13 May 2005 6:43 PM - 3 messages
Hi, In a subquery, are =ALL and <>ALL always return false?  I understand =ALL but not <>ALL.  So please explain a little. Thanks. ...
Score Stored Procedure Naming (Beginning with SP)
Pat - 13 May 2005 6:10 PM - 6 messages
Hi folks. I know the official recommendation is to not begin stored procedure names with "sp". But, is that case sensitive? Is it ok to start them with "SP" in caps? Pat ----== Posted via Newsfeeds.Com - Unlimited-Uncensored-Secure Usenet News==---- ...
Score Which table launched the trigger
Eduardo Martinez - 13 May 2005 5:46 PM - 3 messages
Hi everyone, Is there some way to know the name of the table that launched a trigger, within the same trigger? I'm trying to create code I can use with several tables without having to modify it Thanks in advance ...
Score Help with Query
haiiyaa - 13 May 2005 5:33 PM - 3 messages
I am struggling to build the appropriate query for the following scenario. A simplified version of my problem is... consider the following table EEID                 EPID               StartDate ...
Score Newbie: HELP takes too long for ALTER TABLE!
steve - 13 May 2005 5:19 PM - 4 messages
Hi, I have a table with 16 million lines. After reading about data types and importing it from Access i decided to change some things to save space and make the querries more efficient. I entered the following in SQL Query Analyzer: ...
Score Checking for database existence on a SQL server using ADO
Edward Diener - 13 May 2005 4:46 PM - 8 messages
What is the best way to check for whether a database exists on a server using ADO. I am thinking that if one connects to the server, and the connection fails, the Errors object should have some sort of information ...
Score Dynamic query
Ray - 13 May 2005 4:25 PM - 7 messages
Hi, In my stored procedure I have differnet paramters and based on the paramters different queries needs to be executed against the database.as these queries share some parts ,I decided to use a dynamic query,so I declared a variable ...
Score Dynamic Query
J-R - 13 May 2005 4:10 PM - 2 messages
Hi, In my stored procedure I have differnet paramters and based on the paramters different queries needs to be executed against the database.as these queries share some parts ,I decided to use a dynamic query,so I declared a variable ...
Score MCP Exam - 70-229
Barry - 13 May 2005 4:08 PM - 4 messages
Dear All, I am considering taking the above exam in the next few weeks. I have attended the course that accompanies the Exam and have read the course material. I have also recently started reading Inside SQL Server 2000 by Kalen ...
Score Combine two queries
scott - 13 May 2005 3:30 PM - 3 messages
Hello, i am an SMS guy trying to write some SQL queries and having little luck.  I have two queries.  The first returns the dept code which in my case is the first 2 letters a computer and a count of computers with that dept ...
Score Need help with SELECT statement please.
Lam Nguyen - 13 May 2005 3:20 PM - 6 messages
Hi all, How can I get the following results.  Please look at the rules below.  The trick part is ChoicePointSuffix_cd = 'AAA' is valid data but = aaa is invalid data because the third party product we using at our ...
Score How do I Automate PAssword change for SQL server account
Alex - 13 May 2005 2:26 PM - 6 messages
Does anyone know a way to Automate Password change for SQL server account? ...
Score ntext and update/insert triggers
Derek Erb - 13 May 2005 2:24 PM - 9 messages
SQL Server 2000 : I have a series of tables which all have the same structure.  When any of these tables are modified I need to syncrhonise all of those modifications with one other table wich is a sort of merge ...
Score different datatypes with UPDATE or INSERT
The Gekkster via SQLMonster.com - 13 May 2005 2:09 PM - 5 messages
I'm writing an SP that retrieves data on a linked SQL server, and selectively updates or inserts like-named rows on the local server. Two columns on the remote server are Mileage varchar(25) and Price varchar(25), whereas on the local server the datatypes are INT and MONEY. ...
Score Running Software from SQL Server/ DTS Package / Job Schedule
Matt Sonic - 13 May 2005 2:01 PM - 2 messages
Why won't SQL Server Agent GetObject or CreateObject. I have a scheduled Job that runs a DTS Package which runs an executable which uses GetObject and CreateObject to connect to an instance of Solid Edge software.  It works fine if I run the DTS manually.  It doesn't work if I run ...
Score Re: Simple Bulk Insert Problem
Andre Olin - 13 May 2005 1:52 PM - 4 messages
Hello! I am a newbie in XML things. My task is to import XML file into MS SQL server. I tried to execute the following code: BULK INSERT dbo.XML_datnes_paraugs   FROM 'C:\reports.xml and here is the result: ...
Score Quick DISTINCT question
Rudy - 13 May 2005 12:36 PM - 5 messages
Hello all! I know the following will work, "SELECT DISTINCT Name, MIN(Sign) AS Sign FROM         Profile GROUP BY Name" Will return 2 columns, Name and Sign. But what if I want more than just the two columns, and I need four to be ...
Score Rollback
Wangkhar - 13 May 2005 12:20 PM - 12 messages
Hi Having a little issue... is it possible to have multiple connections all get rolled back to the same point?  I have a small database that seems to have been busy - but magically lost 5 hours of data (several ...
Score Extremely critical. problems with OLAP SERVER (sorry)
Enric - 13 May 2005 11:35 AM - 3 messages
I am so sorry fot insist this way, such be a pain, i know but it is very critical. A lot! When I launch my routine from our back-end vb appears this: Cannot open connection to Analysis server 'BUESSQL01'. ...
Score using LIKE and ESCAPE in stored procedures
meedax - 13 May 2005 11:08 AM - 3 messages
Using the following stored procedure it doesn't appear that the & operator is being escaped. When supplying @Category as 'Monitors \& Projectors' the stored procedure returns 0 rows. However if I use the select statement directly in query analyzer it ...
Score bcp Limitation
Madhivanan - 13 May 2005 11:02 AM - 3 messages
Is there any limitation on the length of the query used? When the query exceeds 128 characters, I get the error Server: Msg 103, Level 15, State 7, Line 1 The identifier that starts with 'Select Id,Name,Descrip, Address, ...
Score Export to Excel
Madhivanan - 13 May 2005 11:01 AM - 4 messages
I used bcp to export data to Excel file master..xp_cmdshell 'bcp "select * from MyDB..Test" queryout "D:\ex.xls" -c' It is working. But It is actually stored as Text(Tab Delimitated) type. I have to open it and do saveas and select "Microsoft Excel Workbook" ...
Score Importing Infopath Data
Mal .mullerjannie@hotmail.com> - 13 May 2005 10:51 AM - 2 messages
Hi I'm relatively new to importing xml files into SQL. I have some infopath files and I've tried the normal xml importing via sp_xml_preparedocument and the other procs used for xml. The xml can't be parsed becuase of an "invalid character". ...
Score Error accessing to server (olap)
Enric - 13 May 2005 10:48 AM - 3 messages
When I launch my routine from our back-end vb appears this: Cannot open connection to Analysis server 'BUESSQL01'. Error in data [Possible data corruption] '' ... Set m_dsoServer = New DSO.Server m_dsoServer.Connect m_strMDSERVER What is happening? -That servers is reached via PING. ...
Score Pass datetime as parameter to SP
Agnes - 13 May 2005 10:36 AM - 3 messages
my SP like this CREATE PROCEDURE dbo.sel_apinv_nonsettle @cocode varchar(10), @billcode varchar(10), @issuedate datetime, @branchid varchar(10), @accttype varchar(10) IN SQL Analyzer, exec sel_apinv_nonsettle 'CNC','CNC',getdate,'HLSHK','APINV' and i got this error "Server: Msg 8114, Level 16, State 4, Procedure ...
Score Setting query time out to more than 30 minutes?
Bae,Hyun-jik - 13 May 2005 10:24 AM - 2 messages
Hi all, My program access SQL Server 2000 with ADO 2.8. Some of stored procedures my program invoke takes more than 30 minutes because it works a lot of record update. (Of course, it is already optimized but the amount is still large.) ...
Score how to avoid cursors?
Martin - 13 May 2005 9:19 AM - 6 messages
Hi, I would like to solve the following problem without using cursors... I have 4 tables batchtype batch item itemcriteria batchtype contains the type of possible batches batch rows are instances of specific batchtypes items are assigned to batches according to criteria detailed in ...
Score INFORMATION_SCHEMA Information
Madhivanan - 13 May 2005 6:34 AM - 2 messages
I can use queries to retreive many informations from INFORMATION_SCHEMA SELECT * FROM INFORMATION_SCHEMA.Columns WHERE TABLE_NAME = 'tablename' But I want to know how to find where that table exists as it is not part of sysobjects Madhivanan ...
Score Calling a web page from stored procedure
A_X_L_X - 13 May 2005 4:19 AM - 5 messages
Hello, Don't know if this is possible. I have a website on a shared hosting. I can't put any components on the server, but I want to schedule a task to run regularly. My idea was to schedule a stored procedure to run on a regular basis, that ...
Score Error converting data type nvarchar to int.
Patrick.O.Ige - 13 May 2005 3:33 AM - 8 messages
With the stored procedure below if i do DECLARE @ProductName nvarchar(40),@ProductID int EXEC updateProduct @ProductName = ProductName, @ProductID = ProductID why do i get error:- Error converting data type nvarchar to int. -------------------------------------- ALTER   PROCEDURE updateProduct @ProductID int, @ProductName nvarchar(40), ...
Score move records from table1 to table2 if does not exist in table3
Souris - 13 May 2005 2:41 AM - 11 messages
I want to move records from table1 to table2 if the records in table1 does not exist in table3 I have following code: START TRANSACTION INSERT INTO TABLE2 SELECT * FROM TABLE1 WHERE NOT EXISTS(SELECT * FROM TABLE1, TABLE3 WHERE TABLE1.ID = TABLE3.ID) ...
Score query analyzer
rodchar - 13 May 2005 2:27 AM - 5 messages
hey all, is there a way to hide all those system store procedures in Query Analyzer in the Object Browser? thanks, rodchar ...
Score using LIKE to query the leftmost character
.Net Sports - 12 May 2005 11:58 PM - 2 messages
in an sql statement that is concatenating asp, i want to query first names to a customer database with LIKE: "SELECT fname + ' ' + fname AS Name, cust_id " _                 & "FROM tblcusttag " _ ...
Score Relationship between two tables
§Chrissi§ - 12 May 2005 11:45 PM - 4 messages
Hi, We can create more than one relationship between two tables.  Could you tell me a situation where we need two relationships between two tables? Thanks ...
Score Query Help
chad - 12 May 2005 11:10 PM - 9 messages
I have the following  query that returns extra header info in the results when there is more than 1 day with no records in the query. I'm trying to figure out how to run this and not get the additional header information.  ...
Score modify constratints
AM - 12 May 2005 10:58 PM - 4 messages
Hi all In Table1 I have prmary key constraint  and it is refernced by some column as a foreign key in Table2 Now I want to modify my constraint by TSQL  in primary key table , How to do it? ...
Score INDEX ON VARIABLE table
Ray5531 - 12 May 2005 10:36 PM - 9 messages
I create a variable table using this statement in my UDF ,I'm like to put an index on of its field (Internal_ID),How can I do it? DECLARE @TBEnrollmentsForActiveClients TABLE(ENROLLMENT_ID NUMERIC(9),COURSE_CODE VARCHAR(3),             COURSE_YEAR NUMERIC(5),COURSE_SESSION NUMERIC(5), ...
Score Failed to create the share OMWWIZC
chuckdfoster - 12 May 2005 8:53 PM - 2 messages
I am getting "Failed to create the share OMWWIZC" when trying to copy a database.  How do I solve this?  I checked the MS KB article, but can't interpret it, something about local admin rights. ...
Score Linked Server Yields inconsistent results
LisaConsult - 12 May 2005 8:14 PM - 8 messages
On SQL Server 2000 we are connecting to many AS/400 tables using Linked Servers.  We are developing a process which runs solely on SQL using Stored Procedures.  We are finding inconsistent results in the return of a query ...
Score The value of @@Error after Select statement
Rosie - 12 May 2005 8:10 PM - 7 messages
Hi, I have been asked to check the value of @@Error after some of my Select statements but I think that I don't need to. Could you please tell me in what conditions we have none zero value in @@Error after a SELECT statement? ...
Score Using CASE to return positive or negative numbers
Terri - 12 May 2005 7:26 PM - 4 messages
I am trying to use the case expression to change a number from positive to negative or vice versa. If QTY = 50 I want to return 50 when TRANS_TYPE = 'A' and -50 when TRANS_TYPE = 'B' If QTY = -10 I want to return -10 when TRANS_TYPE = 'A' and 10 when ...
Score List Windows Userids Object Permission
Joe K. - 12 May 2005 7:08 PM - 2 messages
I am looking for a script that will list windows userids and sql userids with database object permissions. Please help me with this task. Thanks, ...
Score Resequence column
Ian Galloway via SQLMonster.com - 12 May 2005 6:54 PM - 10 messages
Any ideas how to resequence the numbers in a column after inserting or updating a record. The column is not the Unique ID and is an integer column it is used to allow users to select the order in which things are displayed ...
Score changing SQL syntax
Rizwan - 12 May 2005 6:53 PM - 2 messages
I am using MS SQL Server 2000. I am using a java component which generates SELECT statements based on different critieria. The SELECT statements generated are using the old SQL syntax. For example it will generate : SELECT e.employee_id, er.location_code ...
Score Need a query...
GB - 12 May 2005 6:34 PM - 2 messages
Hello, I have a table T1: Date   |   Value --------------------- Jan        A Feb       A Feb       B Mar       A ...
Score SLOW UDF
Ray5531 - 12 May 2005 5:15 PM - 12 messages
I'm having a UDF which is quite fast till the last step which makes executed for 50 seconds on a single execution.In the last step I have used a right join which makes a very slow ,IS there somebody can give some hints to ...
Score Would descending index help our View's performance?
Wayne Erfling - 12 May 2005 4:57 PM - 4 messages
We store multiple revisions of some data in a single table.  When we want the current revision we use a subquery with MAX(revision) in our VIEW. Our user key and the revision are indexed: "user key"   ascending ...
Score mobing data-posting again
Big D - 12 May 2005 4:45 PM - 6 messages
I hate to post twice but I never received a response from 2 days ago. I am capturing system information about computers. Currently I have one table named SystemInfo that gets data inserted by DTS everyday. Before running DTS job, I would truncate table and insert all new data. Since there ...
Score Newbie (to Triggers) Trigger Help....
Owen Mortensen - 12 May 2005 4:11 PM - 6 messages
Where can I find good information about how to write triggers? I'm using SQL Server 2000. Now, the task at hand: How can I write a trigger that reacts on both insert and update to keep some fields in two similar (but not the same) tables in ...
Score How to lock entire database?
Piotr Strycharz - 12 May 2005 3:22 PM - 4 messages
Hi, Is there a way to lock entire database? What I am supposed to do is kind of replication: - a number tables exist in database, these tables should be updated - so, temporary tables are created and filled with data - these temporary tables are renamed to final name (using sp_rename) ...
Score rounding in sql
Ben Wallace (3) - 12 May 2005 3:10 PM - 4 messages
Can anyone provide any links or information about the differences in rounding between access 97 and sql 2000. ...
Score URGENT: Replication via T-SQL
Lisa Pearlson - 12 May 2005 2:45 PM - 5 messages
Hi, I need to transfer a database from MSDE to SQL Server. I can use T-SQL to detach a database, copy the .mdf and .ldf files to another server and re-attach them there, but I do not want to use the Import ...
Score Newbie: Transfering data from Access, Binary data type
steve - 12 May 2005 2:03 PM - 5 messages
Hi I have the following table: tblMeasurement StationID (char(7)) DateTime (smalldatetime) ValidMeasurement (bit) measurement (integer) now the original Access table had the first three as PKs. When transfering it from Access I lost the PK info and I also want to modify the data type ...
Score Does a user have EXEC permission for a stored procedure?
Hal Heinrich - 12 May 2005 1:59 PM - 7 messages
Given a user name and a stored procedure name, can someone provide me with the TSQL code to set a boolean indicating whether that user has EXEC permission to that proc? The specific proc I'm interested in is xp_loginconfig. ...
Score Returning a table into a SP from an SP
Dave - 12 May 2005 1:00 PM - 6 messages
I have a SP called SP_GetTable.  In a seperate SP how do perform the following? CREATE procedure SP_GetValuefromSP as DECLARE @MyTable (@Field1 Integer, @Field2 Integer) Insert into @MyTable [Results from SP_GetTable] return 0 go Thanks, Dave. ...
Score Why do I have to declare these stored proc variables multiple time
Joe Palm - 12 May 2005 1:00 PM - 5 messages
The following stored procedure works perfectly, but it's my first attempt at writing one that generates and executes a dynamic SQL call to the DB and I'm a little annoyed that I had to declare variables multiple times.  ...
Score Link to Different SQL Database
Agnes - 12 May 2005 12:50 PM - 5 messages
I had connect another SQL server VIA VPN , the server name is IP  e,g 123.123.123.123 I can read the data sucessfully, However, I want to insert some data from my local server. sp_addlinked server '123.123.123.13' ...
Score Multiple instances of MSSQL and IP addresses
Arjan de Haan - 12 May 2005 11:40 AM - 8 messages
Hi. Not sure if this is the correct newsgroup (could not find another suitable group), and if not please redirect me to the proper one.... We're running multiple instances of  MSSQL 2000 on a server. This is done to easily ...
Score byte manipulation for int
sandiyan - 12 May 2005 9:52 AM - 6 messages
I've got a column that is as type int(length=4). This column is getting changed to smallint. Obviously, some values in the column will not fit into smallint type. I've been told that as part of moving data over, I should ignore top two bytes and carry forward ...
Score Help....dbf to sql Migration
charlez - 12 May 2005 7:40 AM - 1 message
Hi, I want migrate the existing database which is in Foxpro DBF files(dos) to SQL 2000.Also the table stuctures are different in sql & also we have the Primary key & foriegn key constraints.. Could someone recommend me the best option to implement this either ...
Score FIFO report
Kriste L - 12 May 2005 4:42 AM - 9 messages
Hi Everyone, I've existing data for a ordering system. Currently there are "Order" & "Distribute" tables. "Order" is keeping transaction of what product are brought and how much quantity. "Distribute" is a table that records how the product are issue to or return by each personnel. ...
Score jdbc-sql 2000 error
inder - 12 May 2005 4:41 AM - 4 messages
Hi,         I'm having trouble connecting to Sql Server 2000 via Java 2 (5.0).  I'm on Windows Server 2003 and trying to connect locally from the server.  I've downloaded the jar files (mssqlserver.jar,msutil.jar, ...
Score UPDATE SET.... ORDER BY? Help!
"A_Michigan_User\ - 12 May 2005 3:37 AM - 6 messages
I need to add a new SMALLINT column into an existing table. I then need to UPDATE this new column with values like: 7000,7001,7002, etc... I *ALMOST* have it here... but I need a way to sort this table on a certain ...
Score Where is the SQL Server Management Studio?
clintonG - 12 May 2005 1:35 AM - 3 messages
Try as I might I can't find the download tonight. ** MSDN Subscriber dowloads would be where? ** CTP choices to use with I'm confused about it SQL Server Management Studio and the SQL Server 2005 Express Manager the latter of which seems to be SQL Server Management Studio ...
Score How to check existing data with a relationship in code. How to drop a relationship in code.
§Chrissi§ - 11 May 2005 6:43 PM - 4 messages
Hi, I have two tables called Student1 and Class.  Both have Class column to set a relationship.  Here is the code and it works. ALTER TABLE Student1 ADD CONSTRAINT FK_Student1_class FOREIGN KEY (Class) REFERENCES Class(Class) Now I want to make it to check existing data with this relationship.  How do I modify it? ...
Score Concurrency problem
Jared Burford - 11 May 2005 3:14 PM - 3 messages
Users A and B execute a simple "SELECT FROM ..." statement at the same time.Both concurrent requests on SQL server 2000 fail with an error message: Microsoft OLE DB Provider for ODBC Drivers error '80004005' [Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]SQL Server does not exist or access ...
Score Select either one field or another as alias
Tim P - 11 May 2005 2:50 PM - 2 messages
Hi I have a SQL Server 2k DB which stores long & short names for items, but one or other could be null. I want to run a view which displays the short name (ShortNm) AS ItemNm if it exists but substitutes the long name (LongNm) if ...
Score Can't run SP with GETDATE()
savvy95 - 11 May 2005 2:32 PM - 7 messages
I'm having a problem running this stored procedure that is supposed to count the "Failed Domains" based on the beginning date and end date. I'd like to simply run this sp with getdate()-2 and getdate-1, but when I ...
Score Transaction to set a flag
dtbascent - 11 May 2005 12:34 AM - 5 messages
Long-running transactions are generally a bad idea.  But what about this: A group in my company is creating a report queueing and generation engine.  They want to create a server collect and queue reports requests in a table, ...
Score Dropped column being "dropped" before drop ????
Mike Jansen - 10 May 2005 8:16 PM - 6 messages
(SQL Server 2000 SP3, Developer Edition, Windows XP Professional) I am getting an error "Invalid column name 'sys_login_name'." when running the following query.  The query is a minor conversion of a table between versions.  One column (userid_fk) had been added in a previous batch.  In ...
Score Converting a longer query into SQL92 syntax?
VMI - 10 May 2005 7:54 PM - 8 messages
First of all, I DON'T want to convert the following query into the SQL92 equivalent, I just want to learn how to do it. Most of the left and right join examples I've found on the Net usually deal ...
Score Wrting extended stored procedures with vb.net/c#
DLS - 10 May 2005 6:06 PM - 3 messages
Are there any references and samples of writing extended stored procedures using vb.net/c#? Since we can't use vb or java, does the same restriction apply? ...
Score Writing two selects into one
Kenny M. - 10 May 2005 3:16 PM - 4 messages
hi I have to tables (T1 and T2) T1 NroTicket     Date              Vendor 0000          01/12/2000          1 ...
Score SQL Backup to UNC Path or Mapped Drive
Lontae Jones - 9 May 2005 8:09 PM - 5 messages
Can you backup a database to a UNC path or mapped drive? ...
Next »