|
database
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
SQL Server database programmingmicrosoft.public.sqlserver.programming
Previewing Crystal Report
Steve Happ -
29 Apr 2006 8:06 PM - 4 messages
Hello: This is probably a very elementary auestion, but I am new to SQL and Crystal Reports. We use a 3rd party SQL application. This app uses stored procedures and Crystal Reports. I've copied and modified one of the stored procedures to ...
Intermittent slow performing SP
smithabreddy -
29 Apr 2006 7:19 PM - 18 messages
Hello, I have a stored proc that has started behaving strangely a few weeks after upgrading to SQL Server 2005. This problem cannot be replicated in the test environment. The stored proc responds within 1 second in the Production environment ...
SET ANSI_WARNINGS OFF
simon -
29 Apr 2006 4:52 PM - 3 messages
I must have SET ANSI_WARNINGS OFF because the program reads return value and it happends to be ANSI varning instead of return value. But If I include SET ANSI_WARNINGS OFF into my procedure, I'm getting an errors because of indexed views. ...
List of hacking applications that run on USB flash drive
xTx -
29 Apr 2006 2:55 PM - 3 messages
Security applications such as namp and ethereal are appearing that run straight from a thumb drive and packet capture, detection and injection tools no longer require the installation of WinPCap or other third-party packet capture drivers. Link: [link] ...
SMO Restore Question
Amos Soma -
29 Apr 2006 12:53 PM - 1 message
I am using SMO to restore a database. My question has to do with how to specify where the .MDF and .LDF files should go. If I do a restore manually via Management Studio, the default location given by M.S. is 'C:\Program ...
SMO Restore Question
Amos Soma -
29 Apr 2006 12:50 PM - 2 messages
I am using SMO to restore a database. My question has to do with how to specify where the .MDF and .LDF files should go. If I do a restore manually via Management Studio, a default location is provided which is 'C:\Program ...
Array as variable ?
Niclas -
29 Apr 2006 11:23 AM - 4 messages
Hi, I am in a situation where I have an array of userIDs in VB .Net. For each of these UserIDs I need to query the database for the fastest time for each user and would like to fill a dataset ordered with fastest to slowest time. ...
temp table in sp_executesql
simon -
29 Apr 2006 11:07 AM - 3 messages
This works: set @sql=N'DECLARE C_LOOPR CURSOR FAST_FORWARD FOR '+ 'SELECT v.ING_ID,v.staID from v_predRez v WHERE v.ING_ID IN('+@sIngIDs+') ' EXEC sp_executesql @sql OPEN C_LOOPR .... ..... If I create temp table, doesn't work any more: set @sql=N'declare @skl table(TX_SKL varchar(50)) ; INSERT INTO @skl SELECT ...
Is there performance penalty for returning resultsets instead of rows
Dejan Grujic -
29 Apr 2006 11:04 AM - 6 messages
I'm using server cursor for generic paging. Interesting part is this: FETCH RELATIVE @StartRow FROM cur WHILE @PageSize > 1 AND @@FETCH_STATUS = 0 BEGIN FETCH NEXT FROM cur SET @PageSize = @PageSize - 1 END ...
Help with SQL QUESTION
pagabas -
29 Apr 2006 7:16 AM - 9 messages
Consider the rows for a given extract: DeviceNumber Type Sequence1 Sequence2 90001 1 A 5 ...
Select query with column name + value
Subbaiah -
29 Apr 2006 6:11 AM - 3 messages
Hi, In my application i am having the situation that, the select query will returns Column Name + Value. Ex. Subject Author ...
Hierarchical queries in SQL Server 2000
Subbaiah -
29 Apr 2006 6:00 AM - 4 messages
Hi, Do we have Hierarchical queries in SQL Server 2000 (like that by using start with....connect by prior... in Oracle)? If someone has worked on some work-around to do so in SQL Server 2000, pl. let me know. ...
Loading controls with objects versus recordsets
mrmagoo -
29 Apr 2006 4:26 AM - 5 messages
I'm building a vb.net Forms project that is getting data from a SQL Server database. One of the main goals of the project is to be really responsive to events, such as textbox change events. I have a textbox for searching, a listbox to ...
sql script.
h -
29 Apr 2006 4:17 AM - 3 messages
Hi, Can any one tell me the script for following task: I am working with a parent table contained with 90 rows and child table with 50 rows(suppose it has no duplicate master value) , I want to write the ...
How to find Server Collation from SQL 2005 tables/views?
Mark Findlay -
29 Apr 2006 2:09 AM - 3 messages
Does anyone know what table, view, etc., contains the SQL Server 2005 server collation (not database collation) value? When I use SQLDMO it returns an empty string, yet when I view the SQL Server 2005 instance properties in SQL Server Management Studio, it correctly shows as SQL_Latin... etc. ...
SQL query: is object in a static list showing up in daily results? if so, how many times?
Randall Arnold -
28 Apr 2006 10:33 PM - 19 messages
The title of this post is a little cryptic but hopefully I can explain well enough. I asked a similar question a while back, didn't get usable answers and then thought I'd solved it on my own. However, my current approach to ...
2005 Management Studio questions
rvgrahamsevatenein -
28 Apr 2006 10:29 PM - 2 messages
Two things are bugging me: 1) The bug where you get an partial crash in the "Summary" window if you do something the underlying ListView control doesn't like; apparently it's an issue MS knows about but when will it be fixed? This ...
Help Setting Sum of Column
tony -
28 Apr 2006 10:27 PM - 4 messages
This seems like this should be easy but I'm struggling. I have an Items_Sold table with columns for Loc_id, Item_no, Qty_sold, and Date_sold. I also have an Item_Inv table with columns of Loc_id, Item_no, Max_qty, and many other columns. I need to update the ...
Results from SP as CSV file (BCP or SQLDMO)
yitzak -
28 Apr 2006 9:49 PM - 4 messages
Hi I have an app that executes a stored procs and writes out the data to a file. Currently uses ADO recordset and goes through each record. This is slow. I would like to use bulkcopy - however have the problem that the app ...
Repost: Exporting Information
Randy -
28 Apr 2006 9:43 PM - 2 messages
Hello NG We have a production database that we have moved the tables to SQLServer and I have been creating stored procedures to replicate some of the processes done on the access side - the server does processing extremely faster than ...
Stored Procedures and several queries
Rey -
28 Apr 2006 9:38 PM - 3 messages
Howdy all. Somewhat new to stored procedures... Have a crystal report that uses a stored procedure but appears to be missing data... Background - the original data table was generated through a several Paradox queries which are now being converted to SQL. ...
Retrieving a distal query plan
ionFreeman@gmail.com -
28 Apr 2006 9:22 PM - 4 messages
Hi! I have a consultant onsite at a client, and she's sending back pictures of the query plan for a script with a performance issue. These are useful, as they're turning out somewhat different from the ...
Return Null on Unmatched Join?
Daniel Regalia -
28 Apr 2006 9:14 PM - 5 messages
Greetings and Salutations on this most beautifull Friday... I have 2 tables that are joined as such: INNER JOIN dbo.tblSettles ON dbo.aaaBODPNL.ExchangeLongCode = dbo.tblSettles.trDelta Is there a way to join it so that if there is not a match to join up to on ...
Report Syntax help !!!!!!!
ITDUDE27 -
28 Apr 2006 9:02 PM - 2 messages
Hello, I was wondering if some one can direct me to a link where code samples are posted or syntax checkers. I've taken on this report project using stored procedures, the request is base on inventory commission for sales reps. ...
Newbie?: Can This Be Done?- If so please direct
Randy -
28 Apr 2006 8:33 PM - 2 messages
Hello NG I have been working with Access for a Long Time - Am just now starting to get my feet wet with SQL Server 2000 - We have a production database that we have moved the tables to SQLServer and I have been creating stored ...
FW: Errors Occurred (80040e21) and DBSTATUS_E_UNAVAILABLE at SetData()
Egbert Nierop (MVP for IIS) -
28 Apr 2006 8:27 PM - 1 message
Hello, I have a class, based on ATL oledb providers. And it allows both to run as a server or a client cursor. In the past, it was working with server cursors, but not anymore :< The following sequence happens. ...
Analyze SPS
Seanms -
28 Apr 2006 8:07 PM - 3 messages
What is the program microsoft has developed to help optimize Stored procedures? (I am not talking about the quesry analyzer). Sean ...
whats the difference between these two queries??
TSQL -
28 Apr 2006 7:18 PM - 4 messages
will there be any difference in query performance between statement1 and 2??? How sql server 2000 treat them ??? do they run in the same manner? DECLARE @FDOFMONTH AS VARCHAR(30) DECLARE @FDOFYEAR AS VARCHAR(30) DECLARE @TO DATETIME DECLARE @FROM DATETIME ...
Could not allocate new page for database 'TEMPDB'.
Marty -
28 Apr 2006 7:11 PM - 3 messages
I recently had a routine using a table variable involved in a fairly complex query using a number of fairly large tables which ended with the following error. Server: Msg 1101, Level 17, State 10, Line 40 Could not allocate new page for database 'TEMPDB'. There are no more ...
Conversion of Access query using First() Aggregate
ScottW -
28 Apr 2006 7:09 PM - 4 messages
All, I am trying to figure out how to convert this particular query, and am stumped... SELECT tCollatList.CollatID, tCollatList.ListCatID, tlListCategory.Category, First(tlListCategory.[CatWholeVal%]) AS [FirstOfCatWholeVal%], First(tlListCategory.Unit) AS FirstOfUnit, First(tlListCategory.[$Unit]) AS [FirstOf$Unit], Sum([tCollatList]![ColListIncDec]) AS Balance, ...
problem using default value in SP
Rich -
28 Apr 2006 7:08 PM - 5 messages
I created an SP for searching rows in a table. Create Proc stp_search @recID varchar(100) = '%' As Select * from tbl1 Where recID In (coalesce((select * from dbo.udf(@recID)), recID)) The SP works if I pass in only 1 recordID, or if I don't pass in anything ...
How to write an T-SQL statement for this complex prob?
rockdale -
28 Apr 2006 6:57 PM - 4 messages
Hi, All I have banged my header to the keyboard for 2 days Suppose I have a log table as following pointA, pointB, eventTime, event ...
IIF Statement on Select
rmcompute -
28 Apr 2006 6:20 PM - 5 messages
Is there a way in an SQL Select statement to set up something similar to the IIf command in Access: Select LastName, IIf(CodeA = "Y","Yes'","No") From NameTable ...
Data transformations
CJEN -
28 Apr 2006 5:34 PM - 3 messages
I need to know if I can do this with a CASE statement: I have a column (Name) in table start that I want to compare to another column (ProperName) in table finish. If the Name matches any ProperName then I want to display TransName from finish. ...
Surrogate or Natural Keys?
Retf -
28 Apr 2006 5:27 PM - 12 messages
Hi All, I need know: what is best choice: Surrogate or Natural Keys? I need understand, what is best? Thanks ...
MSDTC Problems
Topper -
28 Apr 2006 5:09 PM - 1 message
"The transaction manager has disabled its support for remote/network transactions." I get this error when trying to execute a Distributed Transaction from a Windows 2003 Server running MSSQL 2005 to a Windows 2000 Server running MSSQL 2000. Any ideas? ...
how to override/trap Tsql errmsg and use custom errmsg in SP?
Rich -
28 Apr 2006 5:09 PM - 4 messages
create proc stp_errorTest as select 1/0 if @@error <> 0 RAISERROR ('my custom err message', 16, 10) go I purposely generate the 'Divide by zero' error. When I invoke the SP in QA in get the 'Divide By Zero' message along with my custom message. Is there a ...
returns null not cost value in SP
Grant -
28 Apr 2006 4:53 PM - 6 messages
I do not understand what I am doing wrong. I have no problem getting the value into @tot but I cannot get the value assigned to @item_cost. When I use the debug mode, it says @item_cost is null before the start of the debug ...
Permissions to debug SQLCLR as non-admin
Simon Sabin -
28 Apr 2006 4:47 PM - 2 messages
Does anyone now the minimum permissions to debug SQLCLR. I have a friend trying to develop as a non-admin and he finds that it doesn't work even if he launches Visual Studio to run as an admin account. ...
SQLBindParameter() bigint not working
Markus Zingg -
28 Apr 2006 4:39 PM - 1 message
Hi Group SQLBindParameter() returns HYC00 when I try to bind a bigint variable. "Optional feature not implemented" is the error message I get. Does MSSQL (or better said the ODBC driver) in fact not support this? Any way out? ...
how to get count of occurence of a specific char in a string
Rich -
28 Apr 2006 4:25 PM - 11 messages
Is there a Tsql function that returns the count of the occurence of a char in a string? I looked at string functions and various functions return the starting point of a char or set of chars. Example of what I am looking for ...
Problem with sum function and group by
wxbuff -
28 Apr 2006 3:36 PM - 5 messages
I have a temporary table that includes worker names, titles, departments and data about meeting our service level agreements over various incident severities.. I have included some the DDL below... The problem I have is that the report must also sum (for the counts) ...
SQL Concatenation
CJEN -
28 Apr 2006 3:26 PM - 2 messages
What am I doing wrong here? heat.CallLog.CallDesc + heat.Journal.EntryText AS Expr12 Both of these fields are text fields. I keep getting this error: Invalid operator for data type. Operator equals add, type equals text. ...
Execute stored procedure for each value returned in a query
JasonDWilson -
28 Apr 2006 3:22 PM - 12 messages
I have a stored procedure that I am trying to execute passing it each value returned in a query, but I cannot figure how to do it. I am trying to use sp_executesql. Here is an example Query: ...
Sql Injection
Arne Garvander -
28 Apr 2006 2:54 PM - 24 messages
Is the store procedure below secure? ALTER PROCEDURE myproc @arg varchar(200) AS declare @mysql varchar(300) set @mysql = 'some dynamic sql' + @arg exec @mysql ...
trigger for update and insert
JFB -
28 Apr 2006 1:22 PM - 6 messages
Hi All, I'm trying to create a trigger to fire an email after a bit field has the value 1. MyTable has 4 field the one I'm tracking is fcheck. With the sample above I'm able to do the email when the row is updated. ...
Exporting to Excel thru an SP
jaylou -
28 Apr 2006 12:55 PM - 3 messages
Hi all, I know how to use DTS create a package and use the cammand shell to call the DTS package. Is there a way to BCP a table into Excel using windows authentication without creating the DTS package and calling it? ...
Comparing data structure
MaK -
28 Apr 2006 12:51 PM - 2 messages
Hi, The task: we have to two databases. Both evolved from one root in ancient times. Right now they differ quite a lot. We want to take them both back to one. To prepare it we have to make some kind of report (no matter what kind – ...
How to SELECT FROM In-Memory dataset in C# .NET?
BillJohnson4 -
28 Apr 2006 12:44 PM - 4 messages
Experts: I have built an in-memory dataset by parsing a flat file so that I can display the contents onto a datagrid. The Microsoft C# .NET System.Data.DataTable.Select() method allows me to select all rows that meet certain criteria (just like "WHERE") and ...
The War on terrorism
prabhuraaman -
28 Apr 2006 11:58 AM - 1 message
What do you think about terrorism Vote in this international survey [link] If you like this poll you may also participate in [link] ...
Help please with updating large amounts of data on SQL Server 2000
GeorgieBR -
28 Apr 2006 11:30 AM - 8 messages
Hi all, I am writing an application to look through an Interbase back office database, detect any changes (by looking at a timestamp) since the last 'synch' and write them to the SQL Server 2000 DB. In general it works fine ...
insert into statement for image
Soheil Amjadi -
28 Apr 2006 11:21 AM - 4 messages
hello i would like to know how to insert data into a row of the table car, that has one attribute with the datatype image. I want to use the insert into statement from the INSERT INTO Transact-sql information. ...
Guid / uniqueidentifier ...
Jarod -
28 Apr 2006 10:52 AM - 3 messages
Hey I have database ( ASP.Net membership ) that use uniqueindentifiers. I don't need to use this tables manualy so I thought I will just create another table that uses userGUID and UserID( int ), so it will map pretty quickly, ...
Best Practices for SQL Server 2005
Omnibuzz -
28 Apr 2006 10:23 AM - 1 message
Hi all, Can anyone tell me the general best practices to be followed while programming in SQL Server 2005. Links or any best practice that you have come across till now. Especially with the new T-SQL features and CLR. ...
best way of making changes to a production database
Robert Bravery -
28 Apr 2006 10:16 AM - 5 messages
HI all, We have three verions of our database, one that is in continual development, do'nt as why, it would take me too long to explain, but they are valid. ANyway, we have a developer version, which we develop on test changes, crash ...
Select from a column that is a variable
Rui Oliveira -
28 Apr 2006 10:08 AM - 6 messages
I have a variable @column that is the name of a column. I what use this variable in a select. Some like DECLARE @column VARCHAR(20) SET @column = ‘COLUMN_X’ SELECT @column FROM TABLE_X How can I do this? ...
Insert multiple lines
chook.harel -
28 Apr 2006 9:01 AM - 19 messages
In MySql this query whould have worked: insert into TABLE (a,b) values("1","2"),("3","4"); it would have added 2 lines. It doesn't work in SQL SERVER, and I really need to know how I can send one big sql string that will add a number of rows. ...
Location of query results (sql 2000)
Lan -
28 Apr 2006 8:45 AM - 3 messages
I have a multi user application running with a query to fill GUI components (Delphi) I get a 'share violation' for 'del1.mb' (according to a user). All users run with the same userid/password against the SQL server. Now I wonder where MS ...
store procedure
beachboy -
28 Apr 2006 8:28 AM - 3 messages
Hello all, there are 2 update query in my store procedure (SP_update_employee) i want to do is make sure query1 is done and no error and then execute query2 how i do that? Thanks in advanced. ...
Strange behavior with MS SQL
kn -
28 Apr 2006 7:05 AM - 18 messages
I am running a query and am getting very strange results. When I run this, it returns 36. select max(len(source)) from datatable where date > getdate()-1 When I run this, it returns 20. select source into #temp from datatable where date > getdate()-1 ...
Grant execute on many procs in 2005
Andre -
28 Apr 2006 5:31 AM - 2 messages
I need to grant execute permissions to many stored procs to a user. How do you accomplish this in 2005? ...
Error connecting to SQL Server 2005 - ... does not allow remote connections?
Marco Napoli -
28 Apr 2006 5:13 AM - 3 messages
I have an ASP.NET 2.0 Website that in the connection string does not connect to the local SQL Server but tries to connect to another SQL Server 2005 Server in another State. When I run the application from Visual Studio 2005 ...
System procedure
Shimon Sim -
28 Apr 2006 4:19 AM - 4 messages
Someone once showed me a system stored procedure that executed some statement on each table in a database. Can't remember the name of the procedure. Does someone know what I am talking about? Thanks Shimon ...
Please help on this matching problem
auro88 -
28 Apr 2006 4:11 AM - 15 messages
I have these two tables: Leads =============== id date account id 1 1/1/2005 1-abc 2 7/1/2005 1-abc ...
Develop your own Accounting software using Microsoft technologies
pedaammulu -
28 Apr 2006 3:28 AM - 1 message
Hi All, New title for Mastering Web Application Development. All secrets of developing an Accounting Software for the web revealed. Title: "Develop your own Web Accounting Application using ASP.Net" Price: $19.90 Pages: 300 ISBN:81-901331-3-6 ...
EXECUTE permissions
Andre -
28 Apr 2006 12:04 AM - 7 messages
I need to grant a user execute permissions on 1000 stored procedures. This there any easy way to do this in SQL 2005? ...
SQL Server Express "Description" Property
Dan Manes -
27 Apr 2006 11:22 PM - 4 messages
If you use the GUI to modify a table in Management Studio Express, there's a column property called "Description." I'd like to be able to set and access that property using SQL. I played with sp_addextendedproperty and fn_listextendedproperty but ...
Trouble With A Trigger
Chris Lieb -
27 Apr 2006 9:19 PM - 3 messages
I am writing a web app that sends the ID of the user along with other arguments to a stored proc that then either inserts or updates a record. This allows us to see who last changed the contents of any ...
Accessing the FileSystem
Angel -
27 Apr 2006 8:58 PM - 3 messages
Is there a way to access the File System via T-SQL. There is a field in a table of mine. In this table there is a filename to a file on my server. I want to make sure that the filename actually points to a file on the server. ...
Joining Rows in a SubQuery
Fabuloussites -
27 Apr 2006 8:37 PM - 5 messages
I have the following code in a stored procedure SELECT CatID, ParentId, CategoryName, (select count(*) from members WHERE DirectoryCat = DirectoryCats.CatID and InFreeDirectory=1 and ApproveDirectory=1) pagecount FROM DirectoryCats where active=1 order by CategoryName it's output is similar to this: ...
Recommended Reading to Learn 2005
Jeremy S. -
27 Apr 2006 7:55 PM - 4 messages
My situation is this: while I have been working extensively with SQL Server 2000 for 5+ years and am quite comfortable with it, I just took on a project that will require SQL Server 2005. The project starts in 3 weeks and I ...
Cursor, CTE and syntax issue. Thanks for your help!
Farmer -
27 Apr 2006 7:30 PM - 3 messages
Thank you for your help. I am trying to use CTE with a cursor to drive an encapsulated logic in the procedure. In BOL it states "A query referencing a CTE can be used to define a cursor." but I can't seem to figure out syntax and no examples are given ...
Date and Time in SQLServer 2005
Helmut Woess -
27 Apr 2006 6:55 PM - 3 messages
Hello, i heard about Date and Time as new datatypes in SQL Server 2005. But they are still not implemented. Will they come with one of the next servicepacks or with SQL Server 20XX in some years (or never)? Can i do something with user defined datatype? ...
DISTINCT returns duplicates
alto -
27 Apr 2006 6:47 PM - 22 messages
I use the DISTINCT keyword to avoid returning duplicates from the query below (multivariable search for plants). However the result does contain duplicates and I just can't figure out why. Please help! TIA CREATE PROCEDURE dbo.usp_MultivarSearch_Plantes ( @Value varchar(256) , ...
page splits/ fragmentation
Panos Stavroulis. -
27 Apr 2006 6:28 PM - 8 messages
Hi, I am inserting data into a table in what I believe is the correct way. The table is clustered on the date and I am inserting data that 90% of the time comes in the correct order, ie today I am inserting 2006/04/27 but 10% may be ...
Analyzer 2000 using 2005 database gives error
Richard Douglass -
27 Apr 2006 6:01 PM - 4 messages
I am using Query Analyzer 2000 and pointing at a 2005 database. I keep getting an error that I think it related to some code that is selecting data into a temp table. The procedure runs perfect on a 2000 database. ...
Local MDF Files--can I make this work?
Greg P -
27 Apr 2006 5:46 PM - 10 messages
Ok, so I'm upgrading a single user vb 6-Access app to a multi-user VS2005-Sql Server app. The client would like to move to SQL Server yet we are not ready to do so yet. The problem is that I can not install anything (sql Server or ...
Blocking
Rect -
27 Apr 2006 5:41 PM - 4 messages
Hi I have lot of blocking issues in my DB and complaining to my vendor did not yield any results.They point that DB is the bottleneck.I have a application running 4 cpu box with 4 GB RAM.I get blocking every hour. ...
View Performance?
Phill -
27 Apr 2006 5:36 PM - 5 messages
Is there any performance loss or gain when using a view versus accessing the table directly? ...
Convert digits to letters
Radhames -
27 Apr 2006 5:29 PM - 6 messages
I want to know if somebody have a fucntion to convert numbers to letters. for Example: 56 to Fifty Six or 10,599 to Ten Thousand five hundred and ninety nine. Please help me.... Radhames ...
how to use TABLESAMPLE in select statement...
=== Steve L === -
27 Apr 2006 5:19 PM - 4 messages
was told it's available in sql2005, but didn't work when i tried it. such as USE AdventureWorks GO SELECT AVG(OrderQty) FROM Sales.SalesOrderDetail TABLESAMPLE SYSTEM (40 PERCENT) error message says incorrect syntax near key word 'percent'. ...
IP address Long to octec format
GA -
27 Apr 2006 5:16 PM - 4 messages
Hello, can anybody outline a SQL function to convert an IP address formatted as long into dotted format? The equivalent in Perl is, @sip being the conversion function: #!/usr/bin/perl #gets the user entry for ip long value ...
Execution time
simon -
27 Apr 2006 5:01 PM - 1 message
I have one last question for this days:) I have indexed views in my query and some indexes on table for that query. If I execute query in query analyzer it takes about 90 miliseconds to execute and return result. It is acceptable time - 2 days work on this ...
Logging Errors to a User-Table in Yukon
Alex Clark -
27 Apr 2006 4:44 PM - 5 messages
Hi All, Using SQL 2005, I want to trap errors in my stored procs using the BEGIN CATCH...etc construct. Easy enough, and I can get detailed information about the error using all the nice new functions like ERROR_PROCEDURE() etc. ...
How to connect two SQL Server using private network.
Mark -
27 Apr 2006 4:34 PM - 8 messages
Hi All: I have two SQL Servers physically sitting next to each other. These servers have Public IPs as 10.10.49.123 and 10.10.49.124. These two servers are also connected through Cross Over Cables for Private Network and private non ...
Indexes versus views
a_pridgen -
27 Apr 2006 4:13 PM - 9 messages
I am currently taking a class, SQL SErver 2000 Database Design and Implementation (70-229) and have just finished reading about indexes. In terms of their primary use, these seem closely related to 'views'. I am unable to find any research on how to know when to use a 'view' versus an ...
Can't index functinon-based column
KJ -
27 Apr 2006 4:04 PM - 2 messages
Hello, I am trying to add an index to a column based on a formula that is a function. When I try to do so, I get the error: 'Line' table - Unable to create index 'IX_Line_LineText'. ODBC error: [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot ...
Replacing a single quote
JasonDWilson -
27 Apr 2006 3:47 PM - 4 messages
How can use the REPLACE function to replace a single quote in a string in T-SQL? I have tried using double quotes, but cannot get it to work. I am trying to replace all the single quotes in at text field with a question ...
Updated SQL Server 2005 Books Online available
Gail Erickson [MS] -
27 Apr 2006 3:43 PM - 1 message
The April update to SQL Server 2005 Books Online is available from the following locations: On the Download Center: [link] On MSDN Library: ...
Trigger doesnt work on Importing through DTS
pmud -
27 Apr 2006 3:28 PM - 3 messages
HI, I have the following trigger on Insert for my table. This trigger basically ; when an order is inserted; takes the ID of this row and generates a MasterOrderNo for this order/row and also it inserts the status for this ...
Shrink database?
Greg Strong -
27 Apr 2006 3:16 PM - 12 messages
Hello All, I'm using Access as a front end to MSDE 2000. What is the best way to shrink the database using code? Presently I'm using a stored procedure called from VB, however error 3251 is generated and the database is still shrunk. It works, but I ...
Help with a Query
Matthew -
27 Apr 2006 3:10 PM - 5 messages
Is there a way to optimize this query, by doing it in fewer steps? Perhaps by only utilizing and updating one table? -TIA- [code] /******************************************** Import the data from DBCC SQLPERF(LOGSPACE) ********************************************/ CREATE TABLE #dbcc_sqlperf ( DB_Name varchar(100), ...
Conditional Selection
Jeff Mason -
27 Apr 2006 3:04 PM - 5 messages
Hi, Hi, I'm trying to construct a query (in a stored procedure) which will have a number of selection criteria based on input parameters. There are a number of these parameters whose selection conditions they represent which all have to be true for a row to be ...
Problem with Grouping
yan -
27 Apr 2006 2:50 PM - 10 messages
Hi, I have 2 tables from which I need to get 2 figures: 1. Divide the Total of Table2 by the Total of Table1 and multiple by 10 as in the top select and this yields the correct results. 2. Display the Amount using the same formula as above per each Id and here ...
update statistics
simon -
27 Apr 2006 2:13 PM - 5 messages
I have indexed view but query is still slow. When I run the query, I get the following message in the execution plan of my view: Warning: statistics missing for this table. If I execute: UPDATE STATISTICS myView WITH FULLSCANnothing happens - still the same ...
Query to get name of views which reference a give column from a ta
Rodger -
27 Apr 2006 2:07 PM - 6 messages
Hi Can somebody give me a query to find the name of all the views which reference a give column name of a table ex: i want to find names of all views which have the column account_type from the table accounts. ...
Gaining complete exclusive access to a given table
Markus Zingg -
27 Apr 2006 1:47 PM - 3 messages
Hi Group While I'm fully aware that there are transations and that stuff like this should be left to the server administration tools etc. I'm still facing the problem of writing a middle ware where the existing, unchangeabel upper layer application want's to get exclusive access ...
+ char(45)+
Jaco -
27 Apr 2006 1:47 PM - 2 messages
Hi, Can anyone tell me if I am using this (+ char(45)+) with the right syntax Select E.EventID, IPP.InventoryPMPeriodID Into #TMP From InventoryPMPeriod IPP inner join InventoryPM I on I.InventoryPMID = IPP.InventoryPMID inner join Event E on E.ReportedBY = I.PMDescription + char(45)+ ...
Query to find default value for a column
JasonDWilson -
27 Apr 2006 1:45 PM - 3 messages
Where are the default values for a column stored in SQL Server. I thought they would be in the syscolumns table, but I cannot find them there, nor anywhere else for that matter. Thanks, ...
Deletion - best practices
Sandy -
27 Apr 2006 1:40 PM - 3 messages
Hello - I am using VB 6 for a front end and Sql Server for the back end. I have several lookup tables and a main table in the database. The Admin users need to add and delete items from the lookup tables occasionally. (They don't ...
|
|||||||||||||||||||||||