|
database
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
SQL Server database programmingmicrosoft.public.sqlserver.programming
problem in parameterized queries to avoid Sql Injection
andy -
4 Jun 2005 11:30 PM - 2 messages
I tried to use parameterized queries to avoid Sql Injection attack but in case I have to generate script based on conditional statement .. things got out of control ... The following link wasn't that much helpful... [link] ...
Sub query question
Ganesh -
4 Jun 2005 10:34 PM - 6 messages
I want to run a correlated sub query something like this Select * from master m where m.key exists select top 1 det1, det2 from detail d where m.key = d.key Now i want to return the det1 and det2 field values with all master table ...
huh?
rodchar -
4 Jun 2005 6:46 PM - 4 messages
hey all, i have 2 fields in a single table field 1 is a parent id number field 2 is a parent id number reference number For example: 0,0 1,0 2,1 3,1 4,2 how do i get a report like the following ...
newbee question on function
Danny Ni -
4 Jun 2005 5:43 PM - 4 messages
Hi, I created some functions in SQL server 2000 server. Every time I use the functions I created I have to prefix them with dbo., say dbo.myFunction. Is there a way to get around it? TIA ...
Making a Non Primary key a unique column
RD -
4 Jun 2005 5:41 PM - 5 messages
I have a table in which a column that is not part of the primary key must contain data that can not be duplicated in the same column in another row but it should not - for other design reasons - be the primary key. ...
sysdepends not showing a stored procedure
Keith G Hicks -
4 Jun 2005 4:13 PM - 4 messages
I have a stored procedures that make use a couple of tables (it runs just fine I might add). Why would that procedure not show up in the sysdepends table? It doesnt' show any of the dependencies for this procedure. I even ...
Regular expression in SQL 2000
Guhanath -
4 Jun 2005 11:27 AM - 4 messages
Hi All, We are migrating a web application from oracle to SQL Server 2000.We have used regular expression extensively in Oracle. Is it possible to use Regular expressions in SQL 2000 queries?? ...
Instead of trigger to increment PK
Ant -
4 Jun 2005 10:52 AM - 12 messages
Hi, I'm trying to increment the PK col of a table by using an instead of insert trigger. (I don't weant to use the identity col property as if a row is deleted, the rows must remain contiguous 1,2,3 etc) I'm expecting that the ...
A Bug With Running Total Query?
Nathan -
4 Jun 2005 9:28 AM - 4 messages
Using SQL Server 2005 Query Result From 1 Table with 3 Cols: Date Amount RunningTotal 6/1/2005 730.0000 730.0000 ...
Sql Server Secure Connection?
matthias s. -
4 Jun 2005 8:53 AM - 2 messages
Hi there, I'm planning to write a web-app which will be utilizing an SQL server. The provider hosting my app runs SQL Server 2000 and I've got access to one database, which I can use for my application. ...
Clean up a table & save to another table
MGFoster -
4 Jun 2005 4:56 AM - 3 messages
I'm trying to filter and update the table AllAgreements (below) by moving parts of each row into appropriate tables and deleting redundant rows. This table is just a scratch table used while importing old data into a new DB. ...
Given a date I need to get the month end date. How do I get this ?
Peri -
4 Jun 2005 3:27 AM - 6 messages
Dear All, Is there any way in SQL server to get the month end date given a date. That is : If I give 15/05/2005 it should give me as 31/05/2005, and If I give 01/06/2005 it should give me as 30/06/2005. ...
Constructing a field name
Harry -
4 Jun 2005 12:52 AM - 2 messages
Can a field name be constructed, and if so, how? For example; Declare @Date SmallDateTime Set @Date = GetDate() I would like to create a field called 2005_Sales in a temp table called 2005_Sales by constructing it from: Convert( char(4), year( @Date) ) + '_Sales' ...
SUM from three tables?
William -
3 Jun 2005 10:29 PM - 5 messages
SELECT sum(a.curr_yr_indem_members) AS INDEM FROM tblHpUSA_health AS a UNION ALL SELECT sum(b.[indem insured]) FROM tblHpUSA_life AS b UNION ALL SELECT sum(c.indem_insured) FROM tblHpUSA_Property AS c ...
what is the deal?
rodchar -
3 Jun 2005 9:22 PM - 6 messages
hey all, i have 4 fields: fld1 fld2 fld3 fld4 Some values contains NULLs. and I'm trying to create a concatenated field. fld1 + '.' + fld2 + '.' + fld3 + '.' + fld4 AS CustomField Only 1 out of a 1000 records worked. I guess because all 4 fields weren't ...
Join Help
RTP -
3 Jun 2005 8:12 PM - 2 messages
I have this JOIN(attached below)....Obviously I want to get data based on a parent-child relationship. CONTACT1 being the parent and CONTHIST being the child. Obviously, I have MANY history records for a contact. I want to get ...
Select - How can I look in all the columns in a table
Mike -
3 Jun 2005 6:37 PM - 9 messages
I want to return the ID of a table if the data exists in any column of the table Main === ID col1 icol2 col3.....col10 1 a;1 b;44 a;5 ...
timeout workaround
JT -
3 Jun 2005 6:32 PM - 3 messages
does anyone know of a way to force a stored procedure to issue a print statement every 25 seconds? im having a timeout issue on a stored procedure called from asp. the procedure has been optimized for speed, but it still takes around a minute ...
kill command
JT -
3 Jun 2005 6:05 PM - 3 messages
if the kill command is executed on a process that has an open transaction, what happens to the transaction? does it rollback? ...
Books on Hierarchies
gopi -
3 Jun 2005 5:54 PM - 6 messages
Hello All, I would like learn Hierarchies in "SQL". I do have the Transact-SQL Cookbook by Jonathan Gennick. Are there any other book that talks about this topic that I should read. Also, if anyone can point to some ...
Looking for a command similar to DB2's COPY MAP/DROP
BBM -
3 Jun 2005 5:51 PM - 3 messages
When copying files in DB2 (at least in the OS/400 version) you can use an option "MAP/DROP" on the copy command. What this does is copy the data from one table to another, but only for columns that have identical column names ...
Using SELECT INTO to copy a table between two SQL SERVER databases
BBM -
3 Jun 2005 5:46 PM - 3 messages
1) Can this be done? 2) What does the syntax look like when using tables from multiple databases in a query? I get errors on any tablenames that aren't in the Database in the combo-box at the top of the QA command window. ...
os_oa* run exe written in vb6
UGH -
3 Jun 2005 5:41 PM - 4 messages
I need to launch an exe application written in VB6 from stored procedure or trigger. I know I have to use os_oa* but I cannot find any document to help me build one. Many examples that I found have something to do with com but I ...
Execute SP if returns data
gv -
3 Jun 2005 5:27 PM - 4 messages
Hi all, I keep getting this error message: Server: Msg 156, Level 15, State 1, Line 10 Incorrect syntax near the keyword 'Else'. I just want to execute a stored procedure if something is returned by this: "Select hl7file from notes where FileWasCreated is null" ...
RESULTSET PROBLEM
Savas Ates -
3 Jun 2005 4:48 PM - 3 messages
I have a stored procedure below.. When I run it with a well parameter in query analyser 3 of select statements return me. (i named select statements 1,2,3) But in asp page when i call this procedure same as query analyser it returns ...
Debug with datetime datatype
Ed -
3 Jun 2005 4:15 PM - 3 messages
Hi, When I debug a stored procedure, if one of the input parameters is datetime datatype, it doesn't matter what I type in, i got an error said "Invalid character value for cast specification" Any idea what value I need ...
Foreign key help
news.microsoft.com -
3 Jun 2005 4:14 PM - 5 messages
Ladies and Gentelmen, here is my problem -- I am using SQLDMO.transfer facilities to move objects between databases. Since I only need to move certain objects, and not all, I have to add each object by name, and each one is handled individually -- a script is created, ...
Just venting
Mike Labosh -
3 Jun 2005 2:48 PM - 9 messages
So we have this stored procedure that does an incredibly complex algorithm to sniff incoming records for possible matches. It's 7 pages of code. (probably 9 or 10 pages with word-wrapped printing) So recently, it was discovered that the thing needs to run in two different ...
Problem With Query Cost Govenor
BDB -
3 Jun 2005 2:45 PM - 2 messages
Hi, I'm running this: DBCC CHECKDB ( '<database>', REPAIR_FAST ) WITH ALL_ERRORMSGS, TABLOCK And I'm getting this: Server: Msg 8649, Level 17, State 1, Line 2 The query has been canceled because the estimated cost of this query (13451) ...
Trigger help followup.
Jack -
3 Jun 2005 2:32 PM - 6 messages
Thanks to Alejondro for posting a solution to my original post. My original post was this... << CREATE TABLE [dbo].[Employee] ( [EmployeeName] [varchar] (50), [ActiveFlag] [smallint], [ActiveTS] [datetime] ) The front end is a vb app. When a column gets updated to a non-zero, the ...
Help! Two-Part SQL Update
xenophon -
3 Jun 2005 2:15 PM - 4 messages
I have a child table with semicolon-delimited data in a single column. Based on what is in the first part of the semicolon-delimited data, I need to write a value to a column in the parent table and ...
Join Efficieny
RTP -
3 Jun 2005 1:48 PM - 3 messages
I have this query...(Attached below) It does have a UNION in it and I need to expand this by probably adding even a couple more UNION clauses. My question is whether I should do this more efficiently using INNER and/or OUTER joins. Not sure how the efficiency Gods ...
Save BLOB to SQL2K TEXT column in VB.NET
David A. Beck -
3 Jun 2005 12:43 PM - 4 messages
In VB6 I store PDF files as BLOBS in a TEXT column of a SQL table The VB6 code works and I'm trying to do the same in VB.NET without success. Any help? Dim vText As Variant, vLinesFromFile As Variant ...
[DBNETLIB][ConnectionWrite (WrapperWrite()).] General Network error. Check
Peri -
3 Jun 2005 11:13 AM - 2 messages
Dear All, I am getting this error frequently and some times sql server is getting stopped automatically. [DBNETLIB][ConnectionWrite (WrapperWrite()).] General Network error. Check you network documentation. Can any one help me out to get rid of this. OS : Windows 2000 professional ...
Winzip a file
Madhivanan -
3 Jun 2005 10:53 AM - 5 messages
When I execute the below, the system hangs an no response. Am I missing anything? Exec master..xp_cmdshell '"c:\program files\winzip\winzip32.exe" -min -a -r -en F:\Users.zip F:\Users.txt' Madhivanan ...
YTD Sum problem
ChrisB -
3 Jun 2005 10:52 AM - 3 messages
I need to be able to add an extra field to a table. A YTD figure. How can I do this - it will also need to be grouped by a code as well EG: Month Budget New Field?(YTD) ...
Create a Table using another table!
Robert -
3 Jun 2005 9:41 AM - 3 messages
Hi, Sorry to trouble you all, but I am not getting anywhere! I need to copy the contents of 1 table into a new temporary table. What I am doing is : SELECT * FROM U_regulargiver WHERE Status ='I' OR Status ='N' ...
Problem populating table with a cursor from VB GUI
Chubbly Geezer -
3 Jun 2005 9:40 AM - 2 messages
Hi all I have a store proc that that does various bits of data manipulation, but the last part I have used a cursor to update 2 fields in a table. This sp is called by a VB front end and then the contents of the table in question ...
trigger help
Microsoft -
3 Jun 2005 9:37 AM - 3 messages
Hi I try to write a trigger that move one record to another table before the update take place...like this I think CREATE TRIGGER Table1 ON dbo.Table1 FOR UPDATE AS INSERT INTO Table2 SELECT * FROM OLD ...
Procedure parameter
Das -
3 Jun 2005 9:06 AM - 8 messages
Hi, I have written a procedure that takes a varchar argument. I pass a comma separated string to for a numeric field. acTest is numeric primary key. I try to select given records like 22,23,25 & I pass these values by a ...
Table scan joining to temp table
Todd Beaulieu -
3 Jun 2005 8:36 AM - 2 messages
I have a proc that creates a temp table and then does a join to an order table. I don't understand why I'm getting a table scan on the permanent table, with the results merged with the temp table. ...
bcp or bulkinsert
ichor -
3 Jun 2005 8:14 AM - 3 messages
hi what are the differences between bcp and bulk insert? Thanks ICHOR ...
sql question 6
ichor -
3 Jun 2005 7:43 AM - 8 messages
hi 35. (35) You are a database developer for a hospital. You are designing a SQL Server 2000 database that will contain physician and patient information. This database will contain a table named Physicians and a table named Patients. Physicians treat multiple patients. Patients have a primary physician and ...
binary_checksum and rowsize error?
liam.caffrey -
3 Jun 2005 7:35 AM - 2 messages
Hi, I can see that by using the object ID rather that the object name, the following SQL query works. Has anybody got any idea what is causing the error? -- Works OK select o.id ,checksum_agg(binary_checksum(m.text)) ...
sql question 5
ichor -
3 Jun 2005 6:50 AM - 2 messages
34. (34) You are a database developer for an SQL Server 2000 database. You are planning to add new indexes, drop some indexes, and change other indexes to composite and covering indexes. For documentation purposes, you must create a report that shows the indexes used by queries before and after you ...
Help with a query
Ivan Debono -
3 Jun 2005 6:40 AM - 7 messages
Hi all, I have a table that describes bus routes. The table includes the following columns: ID - just an autonumber Line - The line number / bus number Way - A way number. Each line/bus can have multiple ways it travels on ...
Calculating employees weekly hours
ninel -
3 Jun 2005 6:01 AM - 2 messages
The pay period begins on a sunday and ends on a saturday. Some
employees work on the weekends, some don't.
How can I calculate by week how many hours an employee has worked?
Date EmpNumber Hours
20050522(sun) 123 7.5
20050523(mon) 123 8
20050524(tues) 123 8.5
20050523(mon) 246 9
20050524(tues) 246 6.5
20050526(thur) 246 7.5
20050529(sun) 345 8
20050530(mon) 345 7
20050531(tues) 345 6.75
I need the outcome to look like this:
PayPeriodWeek EmpNumber Hours
20050522 123 24
20050522 246 23
20050529 345 21.75 ...
help with locking
Aussie Rules -
3 Jun 2005 5:37 AM - 4 messages
Hi, I have an application that calls a strored procedure that return a record built from several tables joined. This data is then present to the user in application where they can then edit and save. The problem I have is that the as the user changes different bits of data, ...
SET IDENTITY_INSERT
Aruna Tennakoon -
3 Jun 2005 4:53 AM - 10 messages
Hi guys.. small help.. When i execuet this I am getting this error SET IDENTITY_INSERT TABLE2 ON GO INSERT INTO TABLE2 SELECT * FROM TABLE1 GO SET IDENTITY_INSERT TABLE2 OFF Server: Msg 8101, Level 16, State 1, Line 1 An explicit value for the identity column in table 'TABLE2' can only be ...
sqlquestion
ichor -
3 Jun 2005 4:47 AM - 2 messages
why is the answer B and E? and why isnt it C and E? 28. (28) You are a database developer for Proseware,Inc. You are creating a database named Human Resources for the company. This database will contain all employee records and demographics information. The company has 2,000 ...
it cant be that easy
ChrisR -
3 Jun 2005 3:41 AM - 7 messages
sql2k There is no way this can be. CREATE TABLE [dbo].[PKauthors] ( [au_id] [int] NOT NULL , [au_lname] [varchar] (40) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL , [au_fname] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL , [phone] [char] (12) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL , [address] [varchar] (40) COLLATE SQL_Latin1_General_CP1_CI_AS NULL , ...
Is this possible?
Chris Botha -
3 Jun 2005 1:44 AM - 15 messages
I can write a stored proc to create a temp table and with "while" loops achieve this, but was wondering if there is a select/something simpler. As an example, if I have 3 tables, Clients (with ID and name), and ClientCities and ClientProducts. Then I want to list them something like: ...
Are 'inserted' and 'deleted' tables or views?
BGL -
3 Jun 2005 12:35 AM - 10 messages
How are 'inserted' and 'deleted' implemented by SQL Server? When I look at the execution plan of a trigger that selects from 'inserted', I can see that the user table is queried instead and aliased as 'inserted': Inserted Scan(OBJECT:[dbo].[MY_TABLE] AS [inserted])) ...
between
js -
2 Jun 2005 10:17 PM - 3 messages
Hi, can I use between for nvarchar field? can some one explain more detail please... fd1 has: 1000, 1000a, 1000b, a1000, b1000, 2000, 2000a, 2000b, b2000. select * from tb1 where fd1 between '1000' and 2000' ...
SQL Server Compatibility
Logan -
2 Jun 2005 9:50 PM - 2 messages
SQL Server 6.5 is a 32 bits version or 16 bits, or bout of them? ...
Calculating employees weekly hours
ninel gorbunov via SQLMonster.com -
2 Jun 2005 8:59 PM - 5 messages
The pay period begins on a sunday and ends on a saturday. Some employees work on the weekends, some don't. How can I calculate by week how many hours an employee has worked? Date EmpNumber Hours ...
Conditionally required field
Chris Lieb -
2 Jun 2005 8:48 PM - 4 messages
How can I make a field required based on the status of other fields? I have a Users table for my app that I also reference in forms that are filled out by everyone. Most users don't need to use this table for login, so they ...
Calculating Trends
CrazyHorse -
2 Jun 2005 8:36 PM - 4 messages
Hello, I am looking for the most efficient way to calculate a trend based upon individual figures in a table. Here is an example (e.g. sold items): Data: date number ...
Trigger question
Jack -
2 Jun 2005 8:15 PM - 2 messages
Hello, Trying to create a trigger. I was assigned the task (wrong guy for sure), and I have no idea what I am doing. Here is the table. CREATE TABLE [dbo].[Employee] ( [EmployeeName] [varchar] (50), [ActiveFlag] [smallint], [ActiveTS] [datetime] ...
Executing result without copying and pasting
Tracey -
2 Jun 2005 8:02 PM - 4 messages
I must be overlooking something because I cant figure out how to execute the results of a query. The query result is over 8000 characters long so I cant put it in a variable without having more than one and appending them together ...
Change Date Format from mm/dd/yyyy to dd/mm/yyyy
Kiran -
2 Jun 2005 8:01 PM - 3 messages
Hi, I have a query to retrieve data from a table for the give two dates(from and to) in a stored procedure. select * from employees where (DateJoined BETWEEN @FromDate AND @ToDate) now I have give the dates like this to get the results ...
Problems with SP and NULL values.
Tinchos -
2 Jun 2005 7:31 PM - 3 messages
Hi friends. I have two servers, one with SQL 7.0 SP4 (Production server) and the development server with SQL 2000 SP3. One developer tells me that in the development server the store procedures he creates permits the NULL output. On the production server, he says that ...
are old school joins slower
ChrisR -
2 Jun 2005 7:02 PM - 7 messages
The Exec Plans from these two simple queries are identical. Of course theres not much data here though. Are the old type of joins in query 1 typically slower, or just not liked/ ANSI standard? select a.*,titleauthor.title_id from authors a,titleauthor ...
Design Idea
XXX -
2 Jun 2005 5:59 PM - 4 messages
Need some design ideas. I have to create a table which will have 2 types of IDs MainID SubID 1 1 1 2 ...
Subject: [TCP/IP Sockets]ConnectionCheckForData()) Error
davidhg -
2 Jun 2005 5:48 PM - 2 messages
Error was returned when we compiled a proc. The proc compiles under SP3a. We're using Standard Edition SP4. The offending statement is a sub-select in a where clause that uses a union: and mv.INSTR_ID in ...
Selecting records from UNION
Chris Lieb -
2 Jun 2005 5:39 PM - 4 messages
I am trying to extract all of the supervisors that work in an office. They can appear in two different columns. Some appear in one column and not the other, and some in both. I have the following code: ...
book on performance tuning
ChrisR -
2 Jun 2005 4:10 PM - 6 messages
I need to sharpen my performance tuning skills... fast. Does anyone know of a good book for this? I don't need a book to tell me where to put Indexes. I need a book that will tell me "if you see this in the Graphical Eecution ...
Database unususally large
Troy Jerkins -
2 Jun 2005 4:06 PM - 4 messages
I've been running Project Server 2003 for close to a year now. Currently the database in SQL Server is at 16GB. I find it hard to believe that this is correct, given that there are only around 6 projects stored in the database ...
Cutting out the sentence
Enric -
2 Jun 2005 4:03 PM - 2 messages
dear all, I need do constantly queries against a remote server: select * from [xxx.xx.xxx.xx].db.owner.table I would like to avoid put every time the IP between brackets Thanks a lot, ...
use view inside a function?
Ann -
2 Jun 2005 3:49 PM - 3 messages
Can I use a view inside a fuction, My code runs fine in query analyzer ,but when I put it inside a fuction, I get the error could not use view or function '..... ' because of binding errors. Thanks ...
Determining LAST DB usage
mdgraves -
2 Jun 2005 3:35 PM - 4 messages
Trying to build routine to determine when LAST a database was used - accessed by a login. This would help determine AGE of databases, and build archival / removal plans. Anyone know how to get LAST ACCESSES info per database, per server instance? ...
Newbie: Simple data transformation
steve -
2 Jun 2005 3:32 PM - 2 messages
Hi I have the following table: tblMeasurement StationID, PollutantCode, Value e.g. 01220 013 23.4 01122 011 7.8 ..... I want to make a simple transformation-update to the data : IF the code is 013 then multiply the value by 0.2 and replace the existing ...
Novice Query question
Todd Heiks -
2 Jun 2005 3:18 PM - 9 messages
The fowwowing 2 queries run in less than 1 second: SELECT Table1.Key, Table1.Field FROM Table1 WHERE Table1.Key='ABC123' Returns 'ABC123', 'ABC' Select Tabel2.Key, Tabel2.Field From Table2 Where Table2.Key = "ABC" Returns "ABC", "DEF" ...
HOST_NAME function peculiarity
Enric -
2 Jun 2005 3:15 PM - 7 messages
Dear fellows, I've got a Query Analyzer session opened against a remote SQL (Argentina) but when I launch "select host_name" it returns me the name of the my local host instead of the remote one. Does anybody know here how can I obtain the real name? ...
Confusing Results
Chris Lieb -
2 Jun 2005 3:10 PM - 8 messages
I am working with some data in the form of dates formatted as mm/dd/yy. Over the years, people have made mistekes in entering dates using formats like mmdd. I am using a CASE statement to sort through these and apply the ...
Very strange behaviour
Enric -
2 Jun 2005 3:02 PM - 6 messages
Dear all, I put on my query analyzer: George Bush and then I press intro and after that, SQL takes 6 seconds till it say: Server: Msg 2812, Level 16, State 62, Line 1 Could not find stored procedure 'George'. ...
Simple question about nesting joins
Lisa Pearlson -
2 Jun 2005 12:19 PM - 2 messages
Hi, I used to have queries like this: SELECT P.Name, A.City, C.Country FROM People P LEFT OUTER JOIN Addresses A ON (A.ParentId = P.Id) ...
Problem with update query based on subquery
Marcin Zmyslowski -
2 Jun 2005 11:33 AM - 2 messages
Hello all! I have created a update query, which looks like this: UPDATE NMR.dbo.NMR_wpisy INNER JOIN (SELECT N.nr_NMR, Sum(ProductionConfirmation.[Confirmed Production Machine]) AS Confirmed_Production_Machine, Sum(ProductionConfirmation.[Confirmed Production Labor]) AS Confirmed_Production_Labor FROM NMR.dbo.NMR_wpisy N INNER JOIN ...
Stored Procedure, Temp table or Cursor
steven scaife -
2 Jun 2005 11:26 AM - 5 messages
Ok I have a complex search I need to perform and I am unsure of the best way to go about it. I'll try and describe it the best way I can. I have to whittle down from several values to one or more records, however I ...
execute query later
Kasper Birch Olsen -
2 Jun 2005 11:22 AM - 4 messages
Hi NG Im writing a web-interface that enables the user to update a DB. The (non)queries takes heaps of time, and since my page "waits" for the query to finish, wich is a pain. So basically I was wondering if there is kinda a ...
Test for existence of temp table
Bob -
2 Jun 2005 11:08 AM - 5 messages
Hello folks! If you want to see if a table exists you do something like this... if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[My_Table]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) GO What do you do if the table is a ##tmp table? How do you see if it ...
Backing up tr.log on another server
Alur -
2 Jun 2005 10:03 AM - 6 messages
In the main server(for example, THIS_SERVER): USE master EXEC sp_addumpdevice 'disk', 'INTERMEDIATE_LOG_DEVICE', '\\ANOTHER_SERVER_NAME\C:\SOME_FOLDER_NAME\ INTERMEDIATE_LOG.DAT' Everything is normal I wanted to back up trans. log on the another server in the local net, but failed. BACKUP LOG INTERMEDIATE ...
Audit trigger with dynamic SQL and Cursor - Am I close?
Steve'o -
2 Jun 2005 9:56 AM - 7 messages
Server = SQL Server 2000 SP3a Client = Access 2000 SP3 (.adp) Hi, can anyone advise me on creating an audit process to account for any changes in a table, I thought I'd come up with quite a good idea and started ...
SELECT DATETIME PROBLEM???
Tim::.. -
2 Jun 2005 9:54 AM - 4 messages
Hi... This is a very simple question I'm sure but I don't know how to solve the problem... I am trying to do a simple SELECT statement Select * From tblTAble Where id = @id or datecreated = '06/02/2005' ...
SQL Server Character Set.
Govardhan MV -
2 Jun 2005 9:38 AM - 2 messages
Hi. 1) How we query the database to get the character set for sql server 2000. 2) How do we change the database character set for sqlserver2000 Please do let me know the detail steps involved in changing the database ...
Is Cursor Best Way To Go?
Neil -
2 Jun 2005 9:26 AM - 11 messages
I need to get two values from a complex SQL statement which returns a single record and use those two values to update a single record in a table. In order to assign those two values to variables and then use those variables ...
Question concerning decimal datatype
kongsballa -
2 Jun 2005 7:46 AM - 7 messages
Hi! Until now I have a varchar field containing decimal numbers. I want too convert the field to decimal(10,5). This will be no problem because all the numbers in the varchar field is now true decimal numbers. The ...
sql qusetion 3
ichor -
2 Jun 2005 7:42 AM - 4 messages
Hi this a question from testking. 27. (27) You are a database developer for your Company's SQL Server 2000 database. You are deleting objects in the database that are no longer used. You are unable to drop the 1997 Sales view. After investigation, you find ...
sql question 2
ichor -
2 Jun 2005 7:24 AM - 2 messages
26. (26) You are a database developer for your Company's SQL Server 2000 database. This database contains a table named Sales, which has 2 million rows. The sales table contains sales information for all departments in the company. Each department is identified in the table by the DepartmentID ...
How to
gladiator -
2 Jun 2005 7:15 AM - 3 messages
Hello everyone: How to retrieve the user tables not system table? ...
from client how to access remote stored procedures
S V G Srinivas -
2 Jun 2005 6:51 AM - 3 messages
hai all can any one give syntax in sql server like how to access remote stored procedures ? wheather we have to set any permissions in client machine to access the ...
testking question
ichor -
2 Jun 2005 5:50 AM - 2 messages
hi in the question below why is C the right answer? doesnt the question say that the CSR and the Marketing employees need Select, insert and update permission? so basically both types of users need an overall access? 17. (17) You are designing your Company's SQL Server 2000 sales database, ...
Help with permission error
Chris -
2 Jun 2005 5:16 AM - 3 messages
Hi, I created a user and when logged in under that user name I get the foll error Server: Msg 3704, Level 16, State 1, Line 2 User does not have permission to perform this operation on table 'dbo.sale' ...
Help storing and retrieving .rtf blob as longvarbinary
Buddy G -
2 Jun 2005 4:16 AM - 3 messages
Hello, can anyone point me in the right direction? I have .rtf files stored in a table as image or sql_longvarbinary data. I would like to be able to pull out the data and assemble an .rtf file using VBscript or VBA ...
Cascade Delete enumeration?
Kerry -
2 Jun 2005 2:03 AM - 4 messages
Hello, Does anyone know a query I can run that will display all cascade actions (on delete or otherwise) for all tables/relationships in a given database? Thanks in advance -Kerry- ...
sql thingy
ichor -
2 Jun 2005 1:23 AM - 4 messages
hi is it possible to Query the sysprocesses and sysobjects system tables to find deadlocked resources and to identify which processes are accessing those resources and Set a shorter lock timeout for the processes that are accessing the deadlock resources?? ...
Mirrored Records?
Daren Hawes -
2 Jun 2005 12:48 AM - 12 messages
Hi I need some SQL script help. Need script to delete all table rows that are duplicates in mirror image. Table has 2 columns, ColumnA and ColumnB. Row1: ColumnA = x, ColumnB = y Row2: ColumnA = y, ColumnB = x Those 2 rows are exactly the same for me. Need a script that will delete ...
UPDATE table FROM same table
Ron Hinds -
2 Jun 2005 12:06 AM - 5 messages
I've got an update that sets columns to the value of other columns in the same table but in different rows. It is currently executed using two recordsets. I want to make it one UPDATE statement instead of looping ...
Problem with WHERE clause
Alien2_51 -
1 Jun 2005 11:49 PM - 3 messages
I'm migrating some reports to reporting services, some of the reports use a bunch of conditional logic to produce the desired results, I'm trying to eliminate as much of that as possible... Here's my query... At the end of the ...
sql question
ichor -
1 Jun 2005 11:43 PM - 2 messages
hi in the question below i would like to know what is a filegroup? and why is c the right answer thanks ICHOR 4. (4) You are a database developer for your company's SQL Server 2000 online transaction processing database. Many of the tables have 1 million or ...
|
|||||||||||||||||||||||