|
database
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
SQL Server database programmingmicrosoft.public.sqlserver.programming
SQL CLR Bug
Ashkan Daie -
11 Feb 2006 11:41 PM - 9 messages
Okay here is the scenario: I have a managed stored procedure. The procedure takes some parameters and generates a SQL statement and calls ExecuteAndSend on the SqlPipe class. When calling the stored procedure and the underlying table has ~100K records ...
Using GetOleDbSchemaTable and Visual Basic .NET for MS-Access and SQL Server Express
Marcus -
11 Feb 2006 11:19 PM - 8 messages
I need to write a VB.Net application that will take an mdb file (Access 2000) and create corresponding copy of it in SQL Express, creating all the tables and relationships, and transferring over the data (using an existing application like DTS in SQL Server or something else is NOT an ...
Using the Between statement
msnews.microsoft.com -
11 Feb 2006 11:16 PM - 6 messages
Ladies / Gentlemen I would like to find out if this is a valid use of the 'Between' Statement Select * From Bids Where GetDate() is Between StartDate and EndDate Mark Moss ...
WHERE EXISTS clause in BOL
Bullfrog1870 -
11 Feb 2006 10:07 PM - 2 messages
Why do I get different results when I include 'publishers' to the inner query? --SCENARIO #1 (from BOL) USE pubs GO SELECT DISTINCT pub_name FROM publishers WHERE EXISTS (SELECT * FROM titles WHERE titles.pub_id = publishers.pub_id ...
difficulty with SELECT SCOPE_IDENTITY();
Joe Befumo -
11 Feb 2006 9:40 PM - 6 messages
This has me stymied, but I'm betting it's something real simple. I'm working in vb/asp/sql-server, and trying to insert a record into a table, and retrieve the new index. Dim objDataConn Dim strSql Dim intNewKeyVal ...
sql server how retrieve info from transaction log?
mtczx232 -
11 Feb 2006 9:17 PM - 2 messages
where i can find simple (in .NET if have) how retrieve info from transaction log? ...
Comparing 2 files
Edward Low -
11 Feb 2006 6:08 PM - 3 messages
Dear All, Periodically, i need to copy a file from the source folder to destination folder. the source file will be updated from time to time. Before copying the file to destination folder, i need to compare the modified date of the ...
Parsing Numeric from Varchar
Mike Harbinger -
11 Feb 2006 5:39 PM - 4 messages
We have a field typed as varchar(50) that usually contains only a numeric but that can contain text. Examples: "1890", "18 90", "L1890", "1890L"," 189O" Problem is because this is looked upon as a numeric by users, they expect ...
Re: Find specific text in a string
Louis Davidson -
11 Feb 2006 5:28 PM - 1 message
Actually I meant that your syntax wasn't SQL syntax: Not mine. It is T-SQL :) ...
Sql Server 2005 FTP Task
timdennis30 -
11 Feb 2006 2:56 PM - 2 messages
How do you loop through files on a remote server using the FTP Task? The ForEarch Loop won't work because the files are stored on an FTP server which needs a ftp connection string. The ftp task looks like it ...
insert into mytable (id) values () does not work
Andreas Klemt -
11 Feb 2006 1:40 PM - 3 messages
Hello, I have this create table myTable (id int identitiy(1,1)) insert into mytable (id) values () <<-------- Error What is wrong? Thanks for any help in advance! Andreas Klemt ...
DATATYPE PROBLEM(cross)
Savas Ates -
11 Feb 2006 12:54 PM - 2 messages
I have a column in my table BizdekiFiyat . The datatype = float length =8 (to save money values).. It is impossible to change these attributes for some reasons. It has records like This BizdekiFiyat 110 24 29.5 31.35 I use Vb.Net . I use ExecuteReader To select values from my db.. ...
General SQL Error
Islamegy® -
11 Feb 2006 11:50 AM - 4 messages
When i try to open programs which my database it give this error.. so i tried to run DBCC CHECKDB and here is the result but i'm unable to repair it with REPAIR_ALLOW_DATA_LOSS or REPAIR_REBUILD so how could i repair my database?? ...
Saving HTML into SQL2000
Nestor -
11 Feb 2006 11:38 AM - 6 messages
Hello all, How do I save the HTML source of a webpage into SQLServer 2000? Thanks. ...
how to obtain further error information?
Balt -
11 Feb 2006 11:28 AM - 9 messages
I'm using DBlib to access a SQL Server DB. Some very trivial calls however fail, and the call to dbresults() returns 2. Is there any API I can call to obtain more detailed error information? - Balt ...
Old dates
Mark Rae -
11 Feb 2006 7:37 AM - 5 messages
Hi, Sorry if this is a frequently-asked question, but I'm about to start designing a database for cataloguing historical artefacts and documents, many of which are from much earlier than the SQL Server minimum value for a datetime field of 1753. ...
Find specific text in a string
ksrajalakshmi -
11 Feb 2006 7:28 AM - 5 messages
Hai , in a textbox am having text as "(20/100)+pay1*pay2" .it's a formula. and stored in a particular variable. string strformula="(20/100)+pay1*pay2" ; i've to substitute the value of the variable 'pay1' & 'pay2' and ...
Need help constructing Full Names
Sam -
11 Feb 2006 6:50 AM - 4 messages
Hi, I have three fields that make up employees' names in the database i.e. FirstName, MiddleInitial and LastName fields. FirstName and LastName fields are varchar(30) and varchar(50) respectively. MiddleInitial field is char(1). When I use the FirstName + ' ' + MiddleInitial + ' ' + LastName AS ...
Another T-SQL puzzle
Alex -
11 Feb 2006 4:58 AM - 2 messages
Hi all, Sorry if this has been asked before, I've had a very long day and I think my brain has switched off... I have a table that records transactions (changes) in another table, and I'm interested in getting an audit trail (i.e. who did what) for specific state ...
Having trouble w/ Decimal field
Sam -
11 Feb 2006 4:56 AM - 3 messages
Hi, I have a decimal field with precision 3 and scale 1. This field will have values ranging from 0.5 to 10. When enter new values into the table using the following stored procedure, my decimal values get rounded up. If I enter values directly into the table, ...
select for output columns from table and local file as image.
hazz -
11 Feb 2006 4:36 AM - 3 messages
I would like to use a select statement that selects various columns from a database table but also contains as the output of the select statement an image datatype which has been set to the value of a bitmap btained from a ...
insert a .bmp or .ico file into a database table image column
hazz -
11 Feb 2006 3:20 AM - 2 messages
how do I do that? thanks. -hazz ...
Deleting primary key when no foreign records exist?
CJ -
11 Feb 2006 2:35 AM - 5 messages
Is there a trigger that would handle this situation? I have a 1 to many between two tables and would like the primary key deleted if the last foreign record is deleted. Thanks in advance! ...
Apostrophe in char and varchar columns
Robert Bravery -
11 Feb 2006 2:34 AM - 2 messages
HI all, When trying to insert text into a char or varchar column that contains an apostrophe ' I get an error message "the value you entered is not consistant with the datatype or length of the colum" I know the length is not a problem, and I'm sure that ' is a char value. ...
creating image column on the fly based on another column's varchar values.
hazz -
11 Feb 2006 2:31 AM - 2 messages
In a datagridview databinding scenario, I would like to replace a datagridview column's text values with an icon for a better user experience. The problem is that if I select the column value from my table of datatype varchar, that datagridview column value cannot be changed from a textbox ...
big task?
JY -
11 Feb 2006 2:31 AM - 3 messages
i have a table with 3 columns: duration (int) startdatetime (bigint) userid (int) i want to get that row's startdatetime where sum of duration becomes equal to or greater than 1000. how can i do that? i can only think of a cursor solution. ...
problem with DBLib access to SQL Server 2005
Balt -
11 Feb 2006 1:21 AM - 3 messages
Hi all, I'm having a (probably) fundamental problem executing an insert statement on SQL Server 2005 from an app written in plain C, using the DBLib API. Please DO NOT comment on the fact the DBlib is obsolete, I know it is. It's just the ...
Can not connect to SQL 2005
Michael Tissington -
11 Feb 2006 12:40 AM - 7 messages
I have SQL 2005 installed on a server. The client is trying to connect to the server, I can create an ODBC connection but when when software tries to connect using ADO I get the following error "To connect to this server you must use SQL Server Management Studio" ...
Storing Time Only
Mark Moss -
10 Feb 2006 11:43 PM - 6 messages
Ladies / Gentlemen I need to be able to store only the 'Time' that an event happens not the 'DateTime' how can this be done? I need to make sure that 'Dates' do ...
How to improve query
nashak -
10 Feb 2006 10:59 PM - 2 messages
Following is a query based on Northwind. I need to output the highest order value for each date. The following works. However I want to see if there is any way to remove the nested query and do some joins. ...
T-SQL Puzzle, well to me at least...
Josh Crosby -
10 Feb 2006 10:50 PM - 5 messages
Hello, I was asked by the finance dept. to come up with a solution to produce a report for them for tax area... anyway here's the probelm have a table 3 columns (invoicenumber, total sale, tax) so i have data that looks a bit like this ...
multiple parameters for user defined function
AkAlan -
10 Feb 2006 10:26 PM - 7 messages
I have a udf with a single parameter @Status which I use to return records based on a status of Red, Amber, Green, or ALL(DEFAULT). It works great but I want to be able to return records that are either Red or Amber. I have tried ...
BUG - ISNUMERIC('.') = 1
Howard Swope -
10 Feb 2006 9:36 PM - 4 messages
ISNUMERIC('.') returns a value of 1. This is bad, right? Howard ...
Access Denied -- txt file on other server
Art -
10 Feb 2006 9:36 PM - 4 messages
Hi and Help!! I'm using Bulk Insert to read a text file that is on a different server. I get an access denied message. - If I change the name to a non-existant file, I get an error that it can't find that file, so it can see it. ...
Table column tied to a user defined function (UDF)
Geoff Pennington -
10 Feb 2006 8:50 PM - 2 messages
A column (call it Pcolumn) in the parent table should equal the sum of [crProcAmount] from several rows in the child table. So, in Design Table, we set the formula property for Pcolumn to the user-defined function ([dbo].[udfBudgetAdjustment]([pkID])) where pkID is the primary key in the ...
SQL2005: Linked Servers & Updating Text datatypes
Rob Morhaime -
10 Feb 2006 8:42 PM - 2 messages
This bugged me in SQL2000 and seems to still be here in SQL2005. Here's repro code to run on two SQL2005 servers: Run this on the "remote server": Create Table RemoteTable (id int, txtdatacolumn text) Insert RemoteTable ...
Problem with Intead of Insert Trigger
Brian Levine -
10 Feb 2006 7:48 PM - 3 messages
I'm having a rather weird problem with an Instead Of Insert trigger. Its supposed to check to see if the record exists in the destination table, and if so update it, otherwise insert the row in the table. All pretty ...
Why is this statement blocking...
bigcoops -
10 Feb 2006 7:17 PM - 12 messages
when running the following statement with CDatabase.ExecuteSQL: "update TABLE set COLUMN1=STRING1,COLUMN2=STRING2 where COLUMN3=STRING3" A little background... This statement is ran by clients when connected to the database. The database is running on a machine where there is manager/monitor app ...
Uses of The 4th Dimension (New Discovery by The Human Race!)
use4d -
10 Feb 2006 6:54 PM - 1 message
Uses of The 4th Dimension (New Discovery by The Human Race!) -------------------------------------------------------------------------------- The 4th Dimension is "The next step in Human Evolution". The Currency of The 4th Dimension is: ENERGY --------------------------------------------------------------------------------- Note Before: Everything you read on this page is The Truth. ...
Drop & Create sProc
Marc Miller -
10 Feb 2006 6:38 PM - 3 messages
I generated SQL Script to drop and recreate some tables in my database that I will want to perform monthly. I would like to put the script into a sproc, however when I try to compile it I receive an error that the tables ...
BCP output - putting double quotes around text
mgale1 -
10 Feb 2006 5:38 PM - 6 messages
Folks, How can I program BCP to output text items in double quotes (")? Here is an example (please try it) that trys to output some columns from a table to csv file. However, due to the existence of commas within the ...
Bug described in article 872843
myrights99 -
10 Feb 2006 5:37 PM - 1 message
I am experiencing same problem described in article 872843. even though my sql server is on SP4. I try to tweak Log reader Agent Properties & other things but that is not helping. It is my impression whether this bug is not fixed or got break in SP4. ...
Copying records
dew -
10 Feb 2006 5:17 PM - 5 messages
How would I copy x amount of records, at the same time changing one of the fields? I can't copy the records as is, because of unique constraints, and I can't leave the field that needs to be changed blank, also because nulls are not ...
Script runs 'forever' and creates huge .LDF
Sydney Lotterby -
10 Feb 2006 5:12 PM - 4 messages
SQL 2K w/latest SPS, Win2K Adv Server 2gb RAM, dual-core AMD CPU 3400, 80gb free on drive There are ~ 9 Million rows in table __ACS and there should be < 100,000 rows inserted into __ACSmaster. There are indexes on each of the columns in the Group By - though I suspect ...
UPDATE ...
Petteri -
10 Feb 2006 5:04 PM - 4 messages
Any idea? column "TEST" data of column TEST [data123], [data234], [test111], [test321], [data456] How can I replace part "test" to "data" by simple sql-command? ...
Read autonumbering field from db
Jensgjerloev -
10 Feb 2006 5:02 PM - 4 messages
Situation: We are blank new to SQL server (previosuly access) and we need to convert to sql server quickly. Consequently this is maybe not a very wice question - but it is SO important to us :-) ** this works in access - but not on sql server: ...
Colour My World
Joel -
10 Feb 2006 4:51 PM - 12 messages
In SQL Server 2000 Query Analyzer, is there a way to print T-SQL code with the QA color coding? When I print, even to a color laser printer, everything including the keywords and comments come out in black and white. ...
NESTED SQL QUESTION and aggregate function
kaczmar2 -
10 Feb 2006 4:47 PM - 11 messages
I have have three tables that I need to pull information from, and return selected rows. Sorry for the psudeo-code for the tables, but it should give you an idea of their (simplified) structure: Inspections ( InspectionID int (PK), ...
Delete files
Ray -
10 Feb 2006 4:46 PM - 2 messages
What is the SQL equivalent of the following VBA? Am very new to SQL programming Kill "C:\Documents and Settings\Ray\Desktop\TestExtract.txt" ...
Schema differencing tool?
Robert Davis -
10 Feb 2006 4:14 PM - 4 messages
Can I get your recommendations on the best schema differencing tool to be had? TIA! Robert ...
Query Help - Counting Dates and Times
tarheels4025 -
10 Feb 2006 4:03 PM - 9 messages
I was wondering how to write a query to count the following date and times. Any help would be appreciated. This is from a table sv_call_log I am using a column called start_date The column start_date is formatted start_date ...
Need help setting up linked server
jmelkerson -
10 Feb 2006 4:03 PM - 4 messages
I cannot for the life of me set up a linked server. I am trying to do what I think must be the simplest, easiest linked server set up there is: Link an instance of SQL Server 2000 to another instance of SQL Server 2000. I've ...
Guaranteed consecutive identity values
Michael Abraham -
10 Feb 2006 2:48 PM - 7 messages
If I do a INSERT INTO <table> SELECT ... and <table> has an identity column with an increment equal to 1, does SQL/Server 2000 and/or SQL/Server 2005 guarantee that the identity values generated for a single successful INSERT ...
Removing duplicate data
Andy -
10 Feb 2006 2:34 PM - 5 messages
I have a table that I need to remove duplicates from and the table includes an identity column. The table contains 12 fields but our business rules are that only 3 of the fields can make the record a duplicate. We would like to ...
BCP or BULK INSERT, which one is better to use.
Manoj -
10 Feb 2006 2:24 PM - 3 messages
Hi, I have some data in ANSI txt file, i want to know which one would be better and recommended way to import this into table. bcp or BULK INSERT Appreciate your inputs on this. Thanks, Manoj ...
Renaming the server name? How could I do such thing?
Enric -
10 Feb 2006 1:43 PM - 4 messages
Dear all, I would need to rename the name of the server. any comments will be welcomed. ...
CLR Triggers and inserted table
Dr. Paul Caesar - CoullByte (UK) Limited -
10 Feb 2006 12:55 PM - 5 messages
I have created a CLR trigger that validates an address that has been enetered into our address database does not already exist and that it meets country critera for addressing. I have a RowVersion column (timestamp), I use this to determin if any ...
SQL script, split digits and letters
P. Garcia -
10 Feb 2006 12:47 PM - 10 messages
Hi folks! I have a small problem i'd like to solve: Say i have 2 columns, both are nvarchar(20). the first one contains license plates. I'd like to update the second column to contain the same as the ...
Create table using data from another table
sabi -
10 Feb 2006 12:46 PM - 2 messages
Hi, How could I create a new table dynamically where columns names are data from another table? Example: I have a table "Table1" with one column "T1Col" The column contains following data: "Row1" "Row2" "Row3" Now I would like to "read" data from Table1 and create a new table ...
Select query
Senna -
10 Feb 2006 12:06 PM - 4 messages
Hi CREATE TABLE [Table1] ( [Id] [int] IDENTITY (1, 1) NOT FOR REPLICATION NOT NULL , [Title] [varchar] (50) NULL , CONSTRAINT [PK_Temp_Table1] PRIMARY KEY CLUSTERED ( [Id] ...
wtf - sorting table doesnt work????
Eric -
10 Feb 2006 11:41 AM - 8 messages
Hi! I have a table I'm trying to sort a table from a stored procedure but no. If I do it from Query Analyzer it works fine, but when I try the same thing from the stored procedure it just refuse to sort. Any ideas? Collation? ...
Help with smalldateTime
Pumkin -
10 Feb 2006 11:18 AM - 3 messages
Hello everyone, I have in a table a field smalldatetime. The problem is that when I select from table I need only the date without the time. Is it possible not to show the time? For example 06/02/2006 00:00:00 to be 06/02/2006. ...
Help with UDF
jp -
10 Feb 2006 11:06 AM - 3 messages
Hi, I've not created one of these before so if anyone can help me get this up and running that would be great. I want to write a function to obtain the exchange rate from a table based on three parameters - exhange rate, country ...
Disconnect Client Connection via T-SQL/Store Proce
Curtis Kam -
10 Feb 2006 10:49 AM - 5 messages
Hi Gents, If there are some client connections on the database and I would like to detach the file, it's failed when execute the store proc "sp_detach_db". Any SQL statement or Store Procedure on clearing/kicking out the current client ...
Switch between TRANSACTIONS
Roby Eisenbraun Martins -
10 Feb 2006 10:45 AM - 4 messages
Hi, I'm Roby Eisenbraun Martins. I'm a C++, VB, C# as ASP .NET developer. I'm creating a number of transactions one after another. Right now I always worked with the last transaction created. But somethings I need to add ...
Query Analyser
Robert Bravery -
10 Feb 2006 10:31 AM - 4 messages
HI all, Where can I read up on how to use query analyser to optimise queries and SP etc. Thanks Robert ...
Best practice datatypes
Robert Bravery -
10 Feb 2006 10:30 AM - 3 messages
HI all, Which ould be the best datatype to use. I have possibilities of monetory values from 0 to 1000000000 I've heard that the money datatype is not readily used. Should I use numeric. What do you guys use ...
Performance Update versus Update using table variable
LeBaron -
10 Feb 2006 9:44 AM - 2 messages
I am looking for a explanation on the following: I have the following code (on a dataset of 1 million rows). It runs very efficiently: ---- declare @tussentabel table (contractnummer nvarchar(25), positienummer nvarchar(25), messagetime datetime, ean nvarchar(30)) insert into @tussentabel ...
Concatenating:www.aspfaq.com/show.asp?id=2529 Is the glass half full or half empty or..?
05ponyGT -
10 Feb 2006 7:59 AM - 16 messages
Lately there seems to be quite a few posts regarding the concatenating of column data in sql.Faq2559,written by a very knowledgable MVP,is often cited as a reference for this problem's solution.This problem is interesting as it has ...
openxml
Gerald Hopkins -
10 Feb 2006 7:58 AM - 3 messages
Does anyone know which is the better way to consume xml in a high traffic SQL Server, using openxml or letting the VB bus object parse it? I'm using openxml and the server keeps rejecting about 40% of my ...
VB Script
Travis -
10 Feb 2006 6:56 AM - 2 messages
Hi , I am try to write a rename file using vb script and use it on the DTS package but I am not sure what is the proper command .. can someone help ? ...
Please help with SQL query
coocoonut -
10 Feb 2006 6:38 AM - 3 messages
I have question about SQL query to generate the following result. Please advise how this can be done with SQL query. Thanks in advance! We need to generate a report to show % of revenue for each category under a perticular product line. Here are the simplified structure ...
Used Disk Space reporting and sending Email
Matthew -
10 Feb 2006 3:05 AM - 5 messages
I have a VB script that goes out and collects all the server disk usage on my network once an hour. It sends this information into a table. Name, Drive, TotalDiskSize, UsedDiskSpace, PercentageFree, DateANDTime Server1, C:, 69311.68750, 21694.53906, 31.29997, 2006-02-09 ...
Query help - resultset too large... impossible!
andrew.tatum@gmail.com -
10 Feb 2006 12:54 AM - 11 messages
Does anyone see any problems with this query? I need some serious help... thanks to everyone that can help me out - I really appreciate it! DECLARE @startdate smalldatetime, @enddate smalldatetime SET @startdate = '2/7/2006 12:00AM' SET @enddate = '2/7/2006 11:59PM' ...
Any way to avoid using a cursor and a script on this one?
Steve -
10 Feb 2006 12:23 AM - 5 messages
A while back a db expert I was talking to expressed the opinion that cursors were overused, mostly by programmers who were thinking like programmers instead of db people. I have a task to do and I'm not sure I can do it without a cursor. ...
Scripting Databases in SQL 2005
msnews.microsoft.com -
9 Feb 2006 11:08 PM - 2 messages
I'm trying to script out a databse from SQL Server 2005 Management Console, using the Generate SQL Server Scripts Wizard. I'd like to script out each object as a seperate file so that I can create a build folder (ie: each ...
BigInt performance on SQL 64
Will -
9 Feb 2006 10:52 PM - 3 messages
Has anyone done some benchmarks of BigInt vs. Int on SQL Server 2000/2005 64 bit? If so I would like to know what your conclusion was. ...
Query assistance or advice
Chris -
9 Feb 2006 10:46 PM - 6 messages
Hi, I have a table which I copy nightly via DTS. I would like to copy only the data which was changed instead based on the MODIFIED date. It will have to insert any new rows created or update any row ...
Misunderstood INSERT when using CASE on ORDER BY
Ray Costanzo [MVP] -
9 Feb 2006 10:28 PM - 4 messages
Hi Group, In the script below, the commented lines, when uncommented, produce: "An explicit value for the identity column in table '#dest' can only be specified when a column list is used and IDENTITY_INSERT is ON." Can anyone explain to me why it is only when I use a CASE statement for my ...
Problem updating two tables in a transaction.
Rick -
9 Feb 2006 10:07 PM - 7 messages
Background... In Sql Server 2000 I have two tables T1 & T2, where T2 contains a key to T1. I have one process P1 that deletes all the records in T2 and then T1, and then inserts new records into T1 and then T2, all done in a transaction ...
Temporary Tables
Allan -
9 Feb 2006 10:02 PM - 3 messages
I have written a stored procedure that is using one temporary table. When i run the statements sequentially in the query analyzer it takes about 2 minutes to process everything. Once i put the statements into a stored procedure and execute the procedure, ...
sql server 2005 error handling
farshad -
9 Feb 2006 9:55 PM - 2 messages
I would like to make use of the new error handling in sql server 2005 Could you please see if this sql is ok (It does compile) CREATE PROCEDURE uspGetData AS declare @Error int declare @Msg varchar(128) ...
Where to put indexes
Bac2Day1 -
9 Feb 2006 9:37 PM - 2 messages
Here's my view1: tbl_1 join_id record_id sku_id tbl_2 sku_id sku sku_desc tbl_3 join_id sku_id part_id tbl_4 part_id part part_desc I've joined tbl_1.sku_id to tbl_2.sku_id tbl_2.sku_id to tbl_3.sku_id tbl_3.part_id to tbl_4.part_id ....Now I've got a sproc: ...
How to see database views relations?
GB -
9 Feb 2006 9:23 PM - 2 messages
Hello: I need a view, based on system tables, to create a parent-child relations table of a database objects - tables and views. I need this to created a hierarchical graph of related views. They could be resided in different ...
Optimizing query with UDF and table vars and IN
David D Webb -
9 Feb 2006 9:23 PM - 3 messages
Hi, I am trying to optimize this scenario. I have a query that is returning a list of services. Each service is done by an employee and for a client. Employees have rights to see only certain sevices. They can see any service that is done by an employee they have ...
Insert Trigger
Topper -
9 Feb 2006 9:16 PM - 4 messages
I guess the first question is "Can you have two columns in two seperate table share an Identity Column?" If there is a way, then I'll do that. The other solution that I have came up with is to have another table ...
Problem with Cursor and Union in select
Stephane -
9 Feb 2006 8:47 PM - 5 messages
Hi, I keep receiving this error when I try to create a cursor: « ORDER BY items must apprear in the select list if the statement contains a UNION operator. » Here's my code DECLARE cArticles CURSOR FAST_FORWARD ...
MSforeachdb Help
Eric D. -
9 Feb 2006 8:43 PM - 1 message
Hi, Is there an equivalent sproc to MSforeachdb that provides a parameter for specifying a specific user to run the sproc on? TIA, Eric ...
Does dynamic SQL allow table variables?
Test Test -
9 Feb 2006 8:28 PM - 7 messages
Hello! Please see below the test code that is using dynamic sql and table variable. It is not working. I am not sure if the dynamic SQL allows using table variables? Thanks! declare @Tblvar TABLE(a int, b varchar(10)) ...
SELECT problem in stored procedure
AkAlan -
9 Feb 2006 8:23 PM - 4 messages
I'm trying to use this as the datasource of a column in a stored procedure: SELECT CONVERT(char(8), ESR_CLOSE_TIME , 108) as soon as I click out of the column single quotes are added around the line and when I run the stored procedure it returns the line as a string in every ...
DBCC SHOWCONTIG question
Patrick -
9 Feb 2006 8:22 PM - 4 messages
Hi Freinds, SQL 2000 I have performance issues on my database and got to this point that DBCC SHOWCONTIG result for my tables are: DBCC SHOWCONTIG scanning 'dup_source_title' table... Table: 'dup_source_title' (779149821); index ID: 1, database ID: 7 TABLE level scan performed. ...
Transfering data from Web database to LAN Database
hals_left -
9 Feb 2006 7:46 PM - 2 messages
Hi, I apologies if this is the wrong group but I figure there must be users here with real word SQL solutions similar to this. I am designing this system where companies can register candidates for exams online and I need to get the data into the client companies SQL ...
Client side ODBC - TCP/IP Port & replacing of DB server
sachinvyas -
9 Feb 2006 7:41 PM - 1 message
Hi, Last night we replaced the DB server by new one and when this was done we kep the name and IP address of the new server same as that of old one. The Port was configurred to be a custom port 6669 but this morning ...
Moving indexes from a filegroup to another
florent.jeannot -
9 Feb 2006 7:02 PM - 4 messages
Hi, I have a 65 Gb database stored on a single filegroup and I would like to move non-clustered indexes to another filegroup. I'm thinking of the following process: _ Backup initial database _ Create new empty database with two filegroups (one for data, one ...
Certification
Barry -
9 Feb 2006 7:00 PM - 2 messages
Hi All, This post isn't particularly directly related to the Group but I thought I would get some opinions. I use SQL Server 2000 on a daily basis - both administering & programming, coupled with VB6 client applications. I am currently ...
Reducing 5 values to 1 value
Greg -
9 Feb 2006 6:54 PM - 3 messages
I am trying to take values that exist in a single column and create a column elsewhere that contains comma separated values of that dataset. The '5' is arbitrary.... For example, Greg John Bill Carol Judy Julie Would look like ...
Can date ranges affect query plans?
ChrisR -
9 Feb 2006 6:54 PM - 2 messages
Howdy. This seems strange to me, but maybe it is to be expected? I have two queries that produce the same results. When I use older date ranges(01/01/04 = 01/31/04), query 1 returns consistently in 0-1 seconds, and query 2 returns in about 4 seconds. ...
insert or update locking?
Rich -
9 Feb 2006 6:52 PM - 1 message
I have two different approaches to designing a database application - the db will store the dates and times for appointment booking. The issue is locking: 1st approach: create composite primary key on table - insert new row and use PK to check for duplicate values to verify that the appointment ...
size of a table
Enric -
9 Feb 2006 6:21 PM - 3 messages
dear all, I'm looking for a system stored procedure which return me the total size of a specific table. I don't remember at all. regards, ...
Rights to schema
dew -
9 Feb 2006 6:02 PM - 1 message
What rights does a user have to have in order to get the table schema? I have a program that retrieves table schema to verify data types, which works fine under me as the data types are retrieved successfully, but it doesn't ...
|
|||||||||||||||||||||||