|
database
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
SQL Server database programmingmicrosoft.public.sqlserver.programming
query to give me db sizes
Hassan -
21 May 2005 10:39 PM - 3 messages
Id like to have a query that gives me the all the total db data sizes such as DB1 100GB DB2 25GB ...
Permission to execute a job
Dave -
21 May 2005 10:04 PM - 2 messages
I have a stored proc that refreshes data and then does a table swap. As part of the table swap I need to drop and create a table. This requires basically dbo permissions. So I create a job to run my proc and the job runs under the sa accout. ...
Dynamic Where clause
Kenny M. -
21 May 2005 8:53 PM - 7 messages
Hi I have an array like this: myArray(n) ,and I need to make a dynamic WHERE clause e.g Where Value = myArray(0) or myArray(1)... But the where clause can not be explicit because the length of the array is ...
"simple" security?
Paul Pedersen -
21 May 2005 7:03 PM - 4 messages
I've heard that SQL Server's security system is good, but complicated. What is the easiest way to: 1. Limit who can make structural changes to the database, including stored procedures. 2. Limit read access to certain tables or fields, and limit write access for ...
Subquery in an EXISTS predicate
J. M. De Moor -
21 May 2005 7:01 PM - 3 messages
When using EXISTS, is it generally better to use * or 1 as the selected column in the subquery? I understand that (in SQL Server at least), using * allows the optimizer to choose the column used in the subquery. Does that ...
Help with Paging SPROC
scott -
21 May 2005 5:11 PM - 4 messages
I'm trying to learn from SQLMag.com's InstantDoc #40505 called "Server-Side Paging with SQL Server " This was a well written main feature story, however, their syntax in Listing 4 below is giving me errors. Can someone paste the below code into QA and ...
setup to access Oracle data
ykffc -
21 May 2005 12:56 PM - 5 messages
Newbie one with SQL. I used to access Oracle data from within an MS Access application, using ODBC. How do I setup my system to access Oracle data using SQL stored procedure? Our Oracle database server is separate from the SQL server box. Please ...
Group all transaction's updates - or getting current transaction id
Ido Ben -
21 May 2005 10:44 AM - 5 messages
Hi all, I need to find a mechanism to put triggers on tables, and when an update takes place - group all updates which happened in the same transaction togheter. (Thanks, nr...) For example: Let's say i have 3 tables : Hotel, RoomType and seasson. ...
Table export fails: "The server could not find DCOM"
kd -
21 May 2005 10:38 AM - 2 messages
Hi All, Exporting a table fails with the following error: "The server could not load DCOM" Only the table is copied, the data is not exported. How to get over this error? Thanks kd ...
Access permission to run SQL debugger
kd -
21 May 2005 7:21 AM - 2 messages
Hi All, When I try to step into the stored procedure (for debugging) in from vb.net environment, it gives the follwoing error. "Security hasn't been set up correctly for SQL debugging on server <servername>. SQL Debugging terminated. See SQL Debugginh documentation on ...
Syntax Help
The Gekkster via SQLMonster.com -
21 May 2005 6:24 AM - 2 messages
Hi all, My crash course in T-SQL has just passed 60 hours this week (so far), and right now I'm drawing a complete blank (definite brain overload)on the correct syntax to put an example such as this into a similarly functioning ...
Creating a Password Retrieval Stored Procedure
EvanK -
21 May 2005 3:27 AM - 3 messages
I would like to create a stored procedure to pass a login name and password to and have it verify the info and return a few fields of data back to the calling function from a javascript page. I have tried a few things but can't ...
How do I Import textfile into SQL table using schema
hushtech -
21 May 2005 1:58 AM - 7 messages
I've been importing delimited textfile data into Access db using a Schema.ini file to describe the text like this [Import.TXT] ( where the raw text is ) ColNameHeader=False Format=CSVDelimited CharacterSet=ANSI Col1 = Field1 text width 255 ...
clearing log
Paul Pedersen -
21 May 2005 1:33 AM - 4 messages
As a relative newcomer to MSSQL, I've been playing around with a database, adding and removing tables and tons of data. Now I'm ready to get down to business. I notice that the log (LDF file) is now three times the size of the database ...
URGENT: Count(*)ing by field value
Kirsten -
20 May 2005 11:05 PM - 5 messages
Suppose I have MyTable: A C -------- 1 x 2 x 2 y 3 x I need to return COUNT() when (c = x) and when (c = y) ...
Putting 'NA' in a Money Datatype Column
Alex A. -
20 May 2005 10:51 PM - 5 messages
Hello, Can anyone solve this prob... BACKGROUND: I have a column in my query that is calculated from money datatypes. To avoid the divide by zero error I created a nice inline case statement that places something else in that field instead. It works great with any number ...
Confused over query cost of execution plan
Khooseeraj Moloye -
20 May 2005 10:30 PM - 9 messages
I am a bit confused with the query cost information displayed by the execution plan. First request: I am using a function to get the required data. The implementation is quite complex so I am not posting it now. I hope it suffices to mention that the ...
Access 97 to SQL
Dianne -
20 May 2005 9:46 PM - 4 messages
I have an Access 97 program that for many years linked to tables in another database through drive letter access. Recently, because of speed, we converted the Access tables to a SQL Server 2000 database and linked the tables via an ODBC connection. ...
ntext problem
Ados -
20 May 2005 8:56 PM - 3 messages
Hi friends, Sorry for my not perfect English. I am new in sql, please help me with this problem. I have a table preview and table products. When the user clicks button "submit" all data from current posting in preview have to be moved in table customers. ...
Malicious user erase a table
BED -
20 May 2005 8:44 PM - 9 messages
Please. I need to find the way to identify a user of the database that erase a table. Since I can do it ? ...
PK/UQ dumb question?
Paul Pedersen -
20 May 2005 7:42 PM - 9 messages
If there's a primary key constraint on a field, is it redundant to have a unique key constraint on that same field? ...
maxdop 1 doesn't seem to work inside batch
Need more Zzzz -
20 May 2005 7:20 PM - 6 messages
I have several dynamically-generated queries that I would like to run with the option(maxdop 1). However, if I put the queries with the option in either Exec or sp_executesql, the option is ignored and the query runs with ...
SQL Syntax for Insert INTO with subselect
Bill Nguyen -
20 May 2005 6:49 PM - 4 messages
I need to insert rows into a table like this: INSERT INTO tableA (Column1, Column2) VALUES var1,var2) WHERE var1 IN (SELECT column3 from table2) Is this a legal T-Transact syntax? If not, what's the alternative? THanks ...
Run an SP without adding anything to the transaction log?
adami -
20 May 2005 6:41 PM - 4 messages
Hi, I have an SP that will basically copy one table's data to another with some transformation involved. The source table over 1 billion rows. The machine has limited disk space and the transaction log will grow too large ...
How to Insert Raw text into SQL table
tom d -
20 May 2005 6:34 PM - 3 messages
HI all, I have raw text like these: test1 test2 test3 .... I want to pass these text in to a SP from Query Analyzer as a paremeter and the SP will handle to import them to a sql table exactly like the format I ...
Slow queries using date parameters
George -
20 May 2005 6:23 PM - 6 messages
I'm rather new to learning T-SQL so I am probably missing something very basic. I am noticing a definate slowdown in queries that use date parameters than if I hard code dates into the stored procs. ...
Removing accented characters
MatthewR -
20 May 2005 6:23 PM - 5 messages
I have a list of French words and want to replace all of the accented characters with unaccented characters. I could go through and replace each accented character one at a time, but if I can somehow do it with collations ...
What's the best way to do Date Comparisons
Jim Abel -
20 May 2005 6:22 PM - 4 messages
I just ran into a snag with a comparison and would like suggestions of the best way to correct the issue. I am comparing the CUTTENT_TIMESTAMP to a saved date in the databse to establish a Yes or No answer. Because of the ...
Permissions...
Chris Marsh -
20 May 2005 5:22 PM - 5 messages
I have been looking for an example of applying permissions to all the tables, view, stored procs, etc., in X sql database without much luck. Clearly, it's simple to do for a single record but I have over 500 tables, ...
Problems Ordering Data
Richard -
20 May 2005 4:33 PM - 9 messages
Hey I'm new to sql programming and looking on google isn't helping, so i thought i'd try here! I'm trying to do a sql query to select data from a table, and order it by date, by putting data that's for today at the top, then the rest of them ...
Any special way to create an index
Vik Mohindra -
20 May 2005 4:13 PM - 3 messages
Hi All, I am not very experienced in creating indexes. Is there a preferred way one should follow. I created come indexes using EM. When I do that, and hit save on the table, does the SQL server at that point generate the ...
How to find what tables/views/functions a stored proc uses
Vik Mohindra -
20 May 2005 4:11 PM - 4 messages
Hi All, Is there any way How to find what tables/views/functions a stored proc uses. Thanks for your help. *** Sent via Developersdex [link] *** ...
What Data mdf file log file ?
MAF -
20 May 2005 3:48 PM - 9 messages
Is there a quick SQL statement that I can run on a server to tell me what mdf file and log file are associated with each database? ...
custom(and dynamic) record fields query
Pawel Rogozinski -
20 May 2005 3:09 PM - 7 messages
Hello, I need to create a query that depends on custom fields (virtual). First I'll try to outline the background. I got Nodes table, that has NodeID field, and other (not really important) fields like name, some boolean fields and so on. ...
Sproc works but doesn't work(?)
dj -
20 May 2005 2:19 PM - 4 messages
I have a sproc that clears and populates a table based on a number of input parameters. I can call the sproc from QA, passing in the expected parameters, and it runs fine and populates the table with some 90k rows. ...
Change collation with osql
szoli -
20 May 2005 1:09 PM - 4 messages
Hi, I have an MS SQL Server 2000 database with collation
'SQL_Hungarian_CP1250_CI_AS'. I wanted to run a script file to insert
values into one of my table by osql.exe the following way: OSQL.EXE -U myUserID -P mypassword -d myDB -i "C:\myscript.sql" -n ...
Top5 plus others per time period
John Shiangoli via SQLMonster.com -
20 May 2005 1:08 PM - 12 messages
Hello All, Please may I have your assistance on how I can improve the performance of the following query? At the moment it takes approximately 2 minutes which is far too long. Any advice would be greatly appreciated The original table structure is as follows ...
Query question.
Jack -
20 May 2005 12:49 PM - 4 messages
CREATE TABLE [dbo].[stuff] ( [c1] [char] (10) ) insert into stuff values ('a') insert into stuff values ('b') Is there an easy way to get this output ? The range of numbers could be larger a 1 a 2 ...
SELECT SERVER_NAME.DB_NAME.TABLE_NAME
Sergey -
20 May 2005 10:52 AM - 3 messages
Hi, In query analyzer I want use select statement with server and dbname (without using "use" statment) like this: SELECT * FROM SERVERNAME.DBNAME..sysobjects WHERE xtype = 'U' When servername is my local machine name: ------------------------------------------------ Could not find server 'MyMachine' in sysservers. Execute sp_addlinkedserver ...
logic of sum() with joining the same table
POKEMON -
20 May 2005 10:41 AM - 9 messages
hi everybody I have a question about the sum() function. when I join two tabeles and one of them is the main table which I used in the from statement, sum function I used for the joined table is giving the sum incorrectly(it is governing times ...
Execute program
simon -
20 May 2005 9:41 AM - 7 messages
Hi, I have exe program with user interface. If I run it with parameter than it do something and after that it unload itself. So, it doesn't require any user interaction. So I create a wsf script, which executes it. ...
Executing Dynamic SQL with out Select Permission
Prakash -
20 May 2005 9:00 AM - 5 messages
I have Procedures with Dynamic SQL, using EXEC(@sql) or Execute sp_executesql @sql I am executing the dynamic sql, few of my procedures are getting input parameter for table name and/or column names also. Now the database user is ...
Implementing cascade updates with instead of triggers
Razvan Socol -
20 May 2005 8:05 AM - 11 messages
Assuming the following DDL and sample data: IF EXISTS (SELECT * FROM sysobjects WHERE name='Conversions') DROP TABLE Conversions IF EXISTS (SELECT * FROM sysobjects WHERE name='Units') DROP TABLE Units CREATE TABLE Units ( Code varchar(3) PRIMARY KEY, ...
Query Response
Renjith -
20 May 2005 7:58 AM - 3 messages
Is there any way i can get , how much rows processed , how much left to process , when executing a select/update/delete statement ...
ROWNUM In Oracle
Renjith -
20 May 2005 5:51 AM - 6 messages
Is there any way to implement ROWNUM in Oracle to select row no. Is there any way to select the row no when retrieving records as 1 Tv 2 Fridge 3 Radio ...
Format a string
Mohd Sufian -
20 May 2005 5:03 AM - 5 messages
Hi all, My company haa a big detabase and i am working on a marketing and sale report. i had lot of junk data like: D-CAB PZTN4-3553-01 TOYOTA,Plate Hook A,7.0mm,(SET) TOYOTA LINER D-CAB (PZO53-0K003), Plate, Robot Hook A, 7.0 MM. ...
Create a View Command in Query Analyzer
A_PK -
20 May 2005 4:41 AM - 8 messages
Hey...a simple question that I forgot.... May I know how to create a view under Query Analyzer....below is what i have type, but command succesfully, but view not created....wonder why ? CREATE VIEW dbo.VIEW1 AS SELECT * FROM Table1 ...
permissions for user to rename a table
Tarren -
20 May 2005 1:57 AM - 7 messages
What permissions must I grant to allow a user to rename a table? I have my stored procedure rename a table when it is done, but it fails and says the user does not have permission. Thanks ...
Query help
Jack -
20 May 2005 12:49 AM - 4 messages
CREATE TABLE [dbo].[stuff] ( [c1] [char] (10) ) insert into stuff values ('a') insert into stuff values ('b') Is there an easy way to get this output ? a 1 a 2 a 3 ...
Handling Errors
Dave -
19 May 2005 11:54 PM - 4 messages
Is it possible to handle an FK violation error in SQL Server 2000? IOW, if I encounter this error, is it possible for the code in my proc to execute alternative code rather than immediately exiting with an error message? ...
Is it possible to select * from StoredProcedure into #tmptable
Joe -
19 May 2005 11:48 PM - 5 messages
Is it possible to do something like this? select * into #tmptable from sp_executesql... ...
Newbie, Howto create trigger to delete an external image file
robdob2003 -
19 May 2005 10:51 PM - 3 messages
Hello, I'm using SQL2000 and I have a table which has a field within it called "ImageFileName", what I would like to do is create a trigger to automatcially delete the disk resident image file that is contained within ...
Stored Procedures and temp tables
Joe -
19 May 2005 10:30 PM - 5 messages
I have a stored procedure that calls several other stored procedures. Is there anyway that a stored procedure can access a temp table created by another stored procedure? ...
DROP Temp table and creating not working ... any reason...
Rajesh -
19 May 2005 10:12 PM - 4 messages
if exists (select * from sysobjects where id = object_id('#Tab1')) begin print 'Dropping old version of table: #Tab1' print '' drop table #Tab1 end CREATE TABLE #Tab1 ( StateCd CHAR(2) ...
Calling program from SQL Stored Procedure
Monster T -
19 May 2005 10:06 PM - 6 messages
Hello, I don't know if this can be done, I'm not an SQL Server expert; But can you start a program ( VB app ) with a stored procedure. For instance if a record is written to a sql table then a trigger could be ...
Differential Backup Script
Joe K. -
19 May 2005 9:37 PM - 2 messages
I would like to test if the day is Sunday (listed below), if 'YES' then delete the files in the directory with following critieria (E:\NewOrleans\*FULL.BAK) and create a new full backup file. If 'NO' (Sunday) create check to see if a E:\NewOrleans\*FULL.BAK file ...
fn Now()
rkasse -
19 May 2005 8:58 PM - 9 messages
SELECT {fn NOW()} SELECT GETDATE() Both return the current datetime but I cannot find a reference anywhere to fn Now(). Can anyone explain what fn NOW() is? Ron ...
SQLAgentMail
Todd Bright -
19 May 2005 8:32 PM - 6 messages
I've configured my SQL Mail profile in SQL Server. In SQL Server Agent Properties it shows me my profile. I choose my profile (the same one that tested successfully in SQL Mail) and press 'Test' and I get the following ...
table as an argument to a stored procedure
tygrus -
19 May 2005 7:28 PM - 14 messages
Is it possible to pass a table to a stored procedure as an argument? ...
SQL Procedure Encryption Question
Mark -
19 May 2005 6:51 PM - 5 messages
Hi All: I am curious to know how SQL Server Procedure, View and other DB Object encryption work at the architecture level. Does SQL Server call any DLL or EXE off the bin directory for text encryption or what? Reason why I am sking ...
Long Running Queries in Procedure
Derek Fisher -
19 May 2005 5:35 PM - 6 messages
de***@programmer.net May 19, 12:57 pm show options Date: Thu, 19 May 2005 09:57:29 -0700 Local: Thurs,May 19 2005 12:57 pm Subject: Long Running Queries in Procedure ...
Argument data type ntext is invalid for argument 1 of rtrim function.
Touchring -
19 May 2005 5:07 PM - 2 messages
Hi, i'm getting this error after switching a field, outcontent from VARCHAR to NTEXT. select * from loglog where (ltrim(rtrim(outcontent))<>'') go Argument data type ntext is invalid for argument 1 of rtrim function. Can someone help advise how i should removed spaces from a field ...
Sql to Update every other
JLS -
19 May 2005 4:58 PM - 5 messages
I have a query that shows me which records will be duplicate; (Database schema is changing in next version, and the last column is no longer part of the key structure, therefore, duplicate.) Query: select a.gl_cmp_key, a.sl_ledger_key, a.sl_acct_keyvalue1, a.sl_dist_key, a.sl_dist_seqno from sl_dist_tbl a ...
Difference between unique constraint and primary key
Ray5531 -
19 May 2005 4:51 PM - 5 messages
Hi, Functionality wise is there any difference between unique constarint and primary key? thanks ...
Create Tables or Views in a Store
Danky -
19 May 2005 4:35 PM - 3 messages
Hello, Buddies Anybody Know if is possible to create tables or views in a store procedure? and if it is, Has it exceptions? where I can find references? Thanks in advence ...
Text files into SQL
Mal .mullerjannie@hotmail.com> -
19 May 2005 4:34 PM - 5 messages
Hi I need to upload and XML file into SQL. I cannot use openxml beucause it's a relational xml file. I cannot get enough info on sqlxml to use that so I'm uploading it via xp_cmdshell via dos command "type" . ...
DTS in SQL Server Workgroup or Personal Edition?
ChristyWarner -
19 May 2005 4:23 PM - 2 messages
Hi, I see that DTS is not available in the Workgroup edition of SQL server. Does anyone know if it's available in the Personal edition? If DTS is not available in an edition of SQL server, can I still use DTSPUMP ...
does sp_xml_concat work
woody hagar -
19 May 2005 4:01 PM - 3 messages
Hi All, I am trying to get the sp_xml_concat ([link]) to work will no luck. Here is the errors I am getting: Server: Msg 170, Level 15, State 1, Line 1 ...
Data security/filtering on field values
Guy -
19 May 2005 3:57 PM - 2 messages
My team is developing a new software system that is replacing several existing applications. The applications being replaced focus on billing and customer relationship management. Our company is an international corporation that serves a large number of customers (hundreds of thousands) spread throughout the US and Canada. For ...
Help w/ a SQL Query
George Durzi -
19 May 2005 3:46 PM - 5 messages
In a sales software system that I built, a sales person belongs to a department within the company. However, during their employment with the company, they might work in several departments. So I implemented department logging in the system. CREATE TABLE [USER_DepartmentLog] ( ...
sp_helpserver Question
Todd Bright -
19 May 2005 3:39 PM - 6 messages
I've got a SQL job I've set up that I'm issuing a call to 'sp_helpserver' in to determine if a given remote server is linked with the local server. If the remote server is not linked at the time of the call, I get an error... ...
group by
shine -
19 May 2005 3:15 PM - 6 messages
I've created a table containing columns date, cost, orders etc. I want to write a query group by the month part of the date. Is it possible to write it. if yes how. Any suggestion would be greatly appreciated. ...
group by
shine -
19 May 2005 3:15 PM - 3 messages
I've created a table containing columns date, cost, orders etc. I want to write a query group by the month part of the date. Is it possible to write it. if yes how. Any suggestion would be greatly appreciated. ...
Metadata for SP parameter default values
Joel Reinford -
19 May 2005 3:13 PM - 2 messages
I am looking for a way to list any default values for stored procedure parameters. For example with this stored procedure: CREATE PROC dbo.pr_GetSomeData ( @SomeInt int, @AnotherInt int = 0, @SomeDate datetime = NULL ) I'd like to be able to create a table that would look like this ...
[OT] Network cables
Mike Labosh -
19 May 2005 2:49 PM - 6 messages
I just absolutely had to share this. The below email just arrived at our helpdesk from one of the suits upstairs: <suit> Just a quick one. When I hooked up my PC I plugged in grey cable that was ...
Row by Row Processing
Lyners -
19 May 2005 2:44 PM - 11 messages
I am trying to create a procedure within SQL Server 2000 that will update a table for viewing over our intranet(nightly process). The final output will show current balances within accounts. The way the logic works for calculating the accounts is that the accounts ...
Simple concatenation not working...
Matt -
19 May 2005 2:38 PM - 6 messages
Hi all, I am trying to do the simplest of concatenating... select lastname + ', ' + firstname from usertbl (example right out of BOL) however, I alwyas get: "Syntax error converting the varchar value 'Adkins' to a column of data type smallint." Something not set right on the server? ...
Making a 'sort-of' unique ID field
darrel -
19 May 2005 2:16 PM - 12 messages
(I posted this in another newsgroup and it was recommended to me that I post in here) OK, that's an odd subject line. Let me try to explain what we have in our table: item language collectionID GUID ...
Schema question -- storing paths through a graph
Julian -
19 May 2005 1:58 PM - 2 messages
I'm modelling an approval process as a graph. Each node represents a stage in the approval process and each edge represents a transition from one stage to another. To move from one stage to another requires someone to take an action. ...
How to define a description for the table in SQL like in Access
karenmiddleol -
19 May 2005 1:17 PM - 8 messages
In Access our users are able to define descriptions for the tables and views(queries). We migrated a few Access applications to SQL Server and our users are asking for the same functionality against the SQL Server tables and views they could define descriptions. I see we can define descriptions ...
DTS for Import Export TO And From EXCEL
Prabhat -
19 May 2005 1:12 PM - 4 messages
Hi All, I want to design a DTS Package that will read an EXCEL Document (One Data Source) and ONE SQL Server (2nd Data Source) and Execute one Query which will have a JOIN from Both the source and Export the result to another Excel ...
Query, help with where clause to reduce resultset
ted -
19 May 2005 12:19 PM - 8 messages
I need some help with the @LanguageId part of this query to exclude/include rows to be returned. ctbl_content_rel can contain rows with different language ids, e.g 'dk' and 'nn'. If rows with the specified @LanguageId exists, then I want only those rows, ...
Database transfer
Philip Germanos -
19 May 2005 11:52 AM - 4 messages
hello, I have my database server environment on the same pc where i have my development environment because i am still in the testing mode, but when i want to switch to the production mode, i want to install my db server on a ...
Store Procedure to extract string tokens
mbellardi -
19 May 2005 11:39 AM - 4 messages
Hi everybody, i need to write a store procedure thar recive as input a string composed in this way: TEXT1.TEXT2.TEXT3.......TEXTn Store procedure has to extract TEXT1 TEXT2 and so on, then use those single strings to various purpouse. ...
Auto Incrementing field
macca via SQLMonster.com -
19 May 2005 10:45 AM - 7 messages
I have a asp.net form which is for orders with a field for numbers in it. What I want is when a user raises a new order the Order number field will be populated automatically with the next order number. I want this order ...
Restore Database from MDF file without LDF
Shansinn -
19 May 2005 9:45 AM - 2 messages
Shansinn wrote: ...
Restore Database from MDF file without LDF
Shansinn -
19 May 2005 9:43 AM - 4 messages
Iam having SQL Database MDF file how can i restore the database without
LDF.Please anyone reply me and this is very very urgent
--
Shansinn
------------------------------------------------------------------------
Posted via [link]
------------------------------------------------------------------------ ...
Allocate Range of AutoNumber ID's to each user
MarkCapo -
19 May 2005 9:39 AM - 8 messages
I have a non standard requirement that about 5 different users from different departments require sequential numbering for there records, however I want all records to be in the one central table. This comes about as each departments records ID's have a 4 letter acronym before the AutoNumber ID. ...
identify rows (for cleanup) with special characters
The Gekkster via SQLMonster.com -
19 May 2005 6:40 AM - 5 messages
Hey all, I need to do a bit of cleanup on some existing data that includes special characters (e.g. '@', '#', '<', '%' etc). If the column holds anything other than a-z and 0-9 then I need to change it. The column in question is ...
connecting nodes and calculating paths
Richard Wilde -
19 May 2005 6:00 AM - 9 messages
I have an interesting problem where I need to calculate paths between connecting nodes. For example:- Node 1 is connected to Node 2 Node 1 is connected to Node 4 Node 2 is connected to Node 3 Node 3 is connected to Node 4 ...
Select Textpointer on a word in a text typedata field
Christian Perthen -
19 May 2005 4:11 AM - 2 messages
Hi, Quick question I have problem getting the pointer position on a word in a text typedatefield. I am getting the error "NULL textptr (text, ntext, or image pointer) passed to UpdateText function.' ..... SELECT @Bptr = textptr(strData), @Bpos = charindex('replaceText' , ...
Search multiple columns?
Rudy -
19 May 2005 1:59 AM - 14 messages
Hello All! I have two DDL, one for Color, red,blue, green the other for size, small, med, large. So basicly when the user picks red and small, I will get this. I know about putting the string for the ddl and stuff, just keeping it simple. ...
Dynamic Column Naming
don larry -
18 May 2005 11:53 PM - 4 messages
Greetings, Very simple question, how do i assign a column same name as its value? declare @seas varchar(5) set @seas = 'Donie' SELECT @seas as (??????) NOT static please, dynamic. So, SELECT @seas as 'Donie' won't do me any ...
Creating table in tempdb using user-defined type
IraG -
18 May 2005 11:35 PM - 6 messages
I understand that to create a temp table in tempdb using a user-defined type, the udt must be defined in Model. However, this doesn't work in my situation, due to security limitations being placed on the Model ...
fn_listextendedproperty
Dave Akin -
18 May 2005 11:21 PM - 2 messages
A quick question... admittedly based in ingnoranceWhat is the significance of having to prefix the function system function fn_listextendedproperty, or other system functions forthat matter, with the two colons?SELECT * FROM ::fn_listextendedproperty(default, default, default, default, ...
datetime Issue
scott -
18 May 2005 10:40 PM - 4 messages
i have a datetime field that i'm just storing the date like 5/17/2005. i need to add the time like 10:30 PM to it. Should I store the time in another field and concatenate? Right now, i just have a calendar date picker ...
SELECT statement with grouping complication
Terri -
18 May 2005 10:24 PM - 6 messages
Given a table Positions: CREATE TABLE [dbo].[Positions] ( [AccountID] [int] NOT NULL , [SecurityID] [char] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL , [Quantity] [int] NULL ) ON [PRIMARY] GO INSERT INTO Positions (AccountID,SecurityID,Quantity) VALUES (1,'A',10) INSERT INTO Positions (AccountID,SecurityID,Quantity) VALUES (1,'A',20) ...
change table name
Laura K -
18 May 2005 10:00 PM - 3 messages
What is the syntax for changing a table name? Can not find it in my reference books. Thanks Laura K ...
question on query
Neil Jarman -
18 May 2005 10:00 PM - 7 messages
Hi, I need a query which returns all rows from one table and rows from another table if they are present. I also need to restrict the right hand table to certain rows. When I do this on;y the matching ros from RHS show. ...
|
|||||||||||||||||||||||