Where to write XQuery statements?

Shilpa

03-28-2006 02:15 PM
Hugo Kornelis

I have tables that I want to fire either an update or insert trigger on. I could write a script containing a long list of inserts but I'm looking...

John Smith

03-28-2006 08:30 AM
Madhivanan

Hello, I downloaded and installed SQL Server 2005 Express and Management Studio Express CTP, but I noticed that there are several limitation in MSEE:...

Maury

03-28-2006 07:55 AM
Maury

Hi, - SQLserver 2000 - Yellowfin 2.4 - Windows 2003 server I have been asked to investigate seting up LDAP authentication to access our Yellowfin...

duncan beaumont

03-27-2006 08:55 PM
Peter

Hello all. I'm running SQL Server 2000 and I'm trying to get a very few, recent rows of data from a table based on an indexed datetime column. ...

scott.swank@gmail.com

03-27-2006 06:08 PM
scott.swank@gmail.com

Hey Everyone, Release 2 of Stylus Studio 2006 has just been released. The following are some of the highlights of Stylus Studio 2006 Release 2...

Stylus Studio

03-27-2006 05:24 PM
Stylus Studio

Hi, I have an Orders Table that has Employee1 and Employee2 (one is the sales rep the other is the telemarketing rep) Both of these fields need to...

FreeToGolfAndSki

03-27-2006 04:41 PM
--CELKO--

I am using the following query which I found from a fragmanet of code by itzik ben-gan to assign a common group id for group of records in my case...

jacob.dba@gmail.com

03-27-2006 12:49 PM
jacob.dba@gmail.com

I have a problem with my sql server. I use a lot of Request.QueryString("Index1") But the Request.QueryString is always the same. I use in...

Newsgroup

03-27-2006 09:54 AM
das

We are running SQL Server 2000 SP3. We have linked servers in use that we use to access Oracle tables. Recently the claim has been made that you...

Mark D Powell

03-27-2006 09:04 AM
DM Unseen

We had a table that had logical fragmentation of 50%. After rebuilding (with default fillfactor 0) I noticed that inserts are much faster. If my...

Dave

03-27-2006 08:57 AM
Tibor Karaszi

Hello guys, I need help in something as I don't know if it is possible what I want. I have a select like this... SELECT Cod1 as SQL, Cod2 as Oracle...

Pumkin

03-27-2006 07:30 AM
Pumkin

Ladies, gentlemen, Upscene Productions is proud to announce the next version of the popular database development tool: Database Workbench 2.8.5 has...

Martijn Tonies

03-27-2006 04:27 AM
Martijn Tonies

Hi, I have an Orders Table that has Employee1 and Employee2 (one is the sales rep the other is the telemarketing rep) Both of these fields need to...

FreeToGolfAndSki

03-25-2006 11:21 AM
Jens

Hi, I have an Orders Table that has Employee1 and Employee2 (one is the sales rep the other is the telemarketing rep) Both of these fields need to...

FreeToGolfAndSki

03-25-2006 09:41 AM
FreeToGolfAndSki

Hi, I'm using table it has 100 rows, how can i update 10 or 15 rows at the same time with single query. In real case, if user enters "5" in textbox...

Khan

03-25-2006 04:05 AM
Erland Sommarskog

We are running SQL Server 2000 in a 32-bit environment. Are there any performance enhancements included in the new Service Pack 4? If so, how do...

imani_technology_spam@yahoo.com

03-25-2006 03:54 AM
John Bell

US funds MICROSOFT SQL Microsoft SQL Server 2000 Standard Ed. 10 Clients PN:228-00684 only $2395 Microsoft SQL Server 2000 Standard Ed....

davidc@estockware.com

03-24-2006 07:33 PM
davidc@estockware.com

I have the view below and if I use vwRouteReference as the rowsource for a combo box in an MS Access form or run "SELECT * FROM vwRouteReference" in...

Beowulf

03-24-2006 06:56 PM
--CELKO--

I have a SQL query I need to design to select name and email addresses for policies that are due and not renewed in a given time period. The problem...

clare at snyder.on.ca

03-24-2006 06:38 PM
clare at snyder.on.ca

Hi I'm trying to convert some verbose SQL Server 2000 T-SQL code that uses lots temp tables and the like into a SQL Server 2005 only...

Brian

03-24-2006 05:14 PM
Erland Sommarskog

I'd like to grant a WIndows account permission to connect to a db and exec stored procedures. But am having trouble. I want this type of effect but...

wackyphill@yahoo.com

03-24-2006 04:28 PM
Erland Sommarskog

I have several stored procedures, created in a development environment, that I need to move to a 'QA' environment, and then in turn, to...

nickwilson.nick@gmail.com

03-24-2006 04:21 PM
Erland Sommarskog

I have a question. I am doing some work for someone and I have a batch file that they can run that will execute an OSQL line and a DTSRUN line. In...

mike

03-24-2006 04:12 PM
Erland Sommarskog

Hi. I have a database I need to supply something (I'm assuming a t-sql script.. maybe something else is better) to update customer tables with. The...

Jeff Kish

03-24-2006 03:59 PM
Erland Sommarskog

We are about to build web application that connects to a MS SQL database. We are planning on building the application to connect to the database...

jaustin@nautalex.com

03-24-2006 11:17 AM
David Portas

Hi. Maybe I'm just being dim, but I'm struggling to get my head around optimising a query with regard to indexes. If I make a select query, such as...

Chris Weston

03-24-2006 10:44 AM
Doug

I noticed that my tables are not storing the milisecond values that I am inserting. Is this a bug? If not, can someone please explain what is going...

Dave

03-24-2006 09:29 AM
Dave

create table employee(empid int,empname varchar(20),managerid int not null, sal int) insert into employee values(1,'ranga',22,5000) insert into...

satish

03-23-2006 05:32 PM
Eric J. Holtman

A client wants to keep track of the number of searches for keywords in a date range. So, I'm storing each occurance of a search in a table. The...

jerball

03-23-2006 05:15 PM
Erland Sommarskog

Good Morning, I have a person table with personID. I have a personRate table with personID, rateID, and effectiveDate. I need to select fields from...

CK

03-23-2006 04:19 PM
CK

hi. I've tried to use the exec sql connect to ... in query analyzer, but could not get it to parse. Can someone show me how in a script, say the...

Jeff Kish

03-23-2006 03:40 PM
Jeff Kish

Gurus, How do I choose multi-name 'columns' like "Current LSN" or "Transaction ID" from ::fn_dblog? I CAN select single 'column' names like...

Doug

03-23-2006 10:28 AM
sdyckes

Gurus, How do you specify the Start and End LSN for ::fn_dblog? These LSNs are in HEX, I unsuccessfull used convert(), cast()...

Doug

03-23-2006 09:28 AM
Doug

Hi, We are using two databases Live and Contingency. Everyday Backup is taken and restored the same on Contingency Server. Cotingency Server act as...

Sun G

03-23-2006 08:58 AM
Jack Vamvas

Hi, I trying to write a select statement that will return each of my sales men a region code based on a table of post codes using wildcards......

cheesey_toastie

03-23-2006 07:54 AM
cheesey_toastie

Hi When we installed SqlServer2000 we left the default collation name (Sql_Latin1_General_CPI_CI_AS). The user defined databases we created...

David Greenberg

03-23-2006 05:43 AM
Erland Sommarskog

My client has a number of jobs that are run overnight. We've set them up to email me when they're completed. Every morning I get in to a bunch of...

teddysnips@hotmail.com

03-22-2006 05:53 PM
Gerry Sinkiewicz

Hi, I am new to SQL Server Administraion, and straight away there occured a case in which some users modified the database and I have to track 'em...

progrAMMAR

03-22-2006 04:57 PM
Erland Sommarskog

Hello, I am learning SQL Server 2005. I need to create a trigger which increments number of book's publications: CREATE TRIGGER InsertPublication ON...

R.A.M.

03-22-2006 04:40 PM
Erland Sommarskog

Hi All, I am designing a purge process for a db that has grown to almost 200GB. My purge process will remove about 1/3 of the 500 million rows...

hallpa1@yahoo.com

03-22-2006 12:32 PM
Doug

Hi All, I am trying to delete rows from a table using a SQL statement similar to this: DELETE FROM TableA where ID1 IN (Select ID1 From TableB where...

hallpa1@yahoo.com

03-22-2006 12:25 PM
Doug

Dear Comp.databases.ms-sqlserver News Group, Are you struggling with XML and relational data? Do you need to create complex web pages or XML...

Stylus Studio

03-22-2006 10:32 AM
Stylus Studio

I have two tables: tb_news-- -story_id -productlist tb_lookup-- -story_id -product

uspensky@gmail.com

03-22-2006 10:27 AM
Anith Sen

Hello, I'm trying to access .mdf file (a sql server database) without having SQL Server installed on the machine (neither MSDE). It can be done from...

Pietro

03-22-2006 10:10 AM
David Portas

Today many applications (SAP, SIEBEL, MANUGISTICS, PEOPLESOFT, and so on) does not have a client direct access to connect to the database. They use...

mleal

03-22-2006 09:41 AM
David Portas

In MS Sql Server 2000, if you run a stored procedure that query's more than 8 databases, you get this error gets raised: Maximum number of databases...

Michael.Suarez@gmail.com

03-22-2006 08:14 AM
figital

Hi, I am doing transactional replication with queued updation from subscribers. I have synchronized database at both the ends. If I chose 'No I...

prashant

03-22-2006 06:58 AM
prashant

Hi there I have small problem with IDENT_CURRENT... We have a table where PK is generated automatically. What I want is to get that value and insert...

john

03-22-2006 04:08 AM
Robert Klemme

I have 2 tables related as: T1.KEY, T1.FIELD1, T1.FIELD2 T2.KEY, T2.FIELDA, T2.FIELDB T2.KEY, T2.FIELDA, T2.FIELDB T1.KEY = T2.KEY I want to...

jeffvh

03-21-2006 08:01 PM
Doug