|
database
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
SQL Server database programmingmicrosoft.public.sqlserver.programming
Cannot create new SQL database.....
wally -
1 Jul 2006 11:46 PM - 8 messages
I have Visual Studio 2005 Pro. I installed SQL Express 2005 and rebooted. But, when I right click on "Data Connections" in the Server Explorer and choose "Create New SQL Server Database..." and attempt to create a new database on the local PC, I get the following error "An error has occurred ...
Good books about huge databases ?
Jarod -
1 Jul 2006 8:23 PM - 6 messages
Hey I need some good books about working with enormous amount of data. The table rows are counted in milions. Have you used SS-2005 with such big amount of data ? What was your experiences ? Any bad things happend ? Any supprises ? ...
Need help with SQL Syntax
D. Patrick -
1 Jul 2006 7:26 PM - 6 messages
I didn't create the architecture, it doesn't have any unique numeric key IDs, and I can't change anything. I need to create a select statement that returns all items that are in stock. Table rows look like this (I am simplifying it to convey the point): ...
UNION or other solution?
Rob Meade -
1 Jul 2006 6:33 PM - 1 message
Hi all, I have a table which contains training course details.... There's a hierarchy with the training courses which is basically this.. A package can contain any number of series', a series can contain any number of courses... In the main SKU table, each row has a column, SKUID, this might begin ...
ADO and distributed transaction on SQL server 2000
sqlserverprog -
1 Jul 2006 10:56 AM - 1 message
Hi all, I am using a program which performs ADO connection which by the mean of stored procedures, performs distirbuted transaction between 2 SQL Server instances. Recently this program failed due to several access violation, thus closing unexpectedly any opened connection on the local sql server instance to which ...
dbcc inputbuffer value
Vikram -
1 Jul 2006 8:39 AM - 2 messages
Hi, I want to store DBCC inputbuffer value in a variable and then want to comapare the value. How ca i store the value in a variable or table inside a script? ...
How to move a SQL Server 7 (no Service Pack) database to SQL Server 2005???
Alan Mailer -
1 Jul 2006 6:08 AM - 5 messages
I'm not proud of this, but I currently run a database on SQL Server 7 with NO service pack applied. How do I transition that database to SQL Server 2005? Admittedly my research has been very preliminary, but I'm not finding much help on ...
Writeable views
Just D -
1 Jul 2006 3:29 AM - 2 messages
All, I know that in some conditions the views can be writeable. Did anybody see or maybe know the links where we can find this information in detail? I mean if we have many tables in our views using INNER JOIN and we need to insert ...
[ database_name . [ schema_name ] . | schema_name . ] table_name
RBC -
1 Jul 2006 2:54 AM - 12 messages
Hi, I try to create 2 schema as the syntax display's as below, but I get a error of only use 1. Do I have to change any parameters in SQL 2005? And will I get any other problems in the future to use 2 schema? ...
Progress Versus SQL Server
pkohn -
1 Jul 2006 2:20 AM - 3 messages
Progress is a piece of crap! Sure it runs on Unix. But the time invested in learning and working with it obscene! With SQL Server I could easily plan a maintenance backup plan and transaction backup plan ...
SQL Server maintenance fails
aneeshattingal -
1 Jul 2006 2:00 AM - 1 message
Hi, The sql server maintenace job is failing giving the following log. Whenever i restart the Service it again starts running .. Everyday this is happening ... Microsoft (R) SQLMaint Utility (Unicode), Version Logged on to SQL Server as 'NT AUTHORITY\SYSTEM' (trusted) ...
select based on containing only certain characters
JR -
30 Jun 2006 9:46 PM - 9 messages
I need to select rows in a table where a particular column contains only the following characters and not in any particular order. "AZ{<" So "A", "Z", "{", and "<" without the quotes. If that's all there is ...
Help with select statement
rhaazy -
30 Jun 2006 8:15 PM - 3 messages
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[FK_tblScan_tblAsset]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1) ALTER TABLE [dbo].[tblScan] DROP CONSTRAINT FK_tblScan_tblAsset GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[tblAsset]') and OBJECTPROPERTY(id, N'IsUserTable') = ...
Counting Consecutive days in SQL
VibroluxOn10 -
30 Jun 2006 7:36 PM - 2 messages
I've been trying to figure out how to count the number of consecutive days of entries in a table. the table stores data on number of minutes exercised in a day for users of an exercise program: ExerciseId int ...
More Efficient SQL Statement - Select Count(1)
Joe K. -
30 Jun 2006 6:55 PM - 13 messages
I know that you can write select statement (Select Count(1)) within Oracle if finds one record it will stop the search critieria. Please help me modify the SQL statement listed below to use the equivalent if it finds one records it stops and output is 1 if not the output is 0. ...
query running slow
vicky -
30 Jun 2006 6:45 PM - 6 messages
I have a query which runs under 15 sec. through query analyzer. But when same query is getting executed by .net console application, using ado.net, it takes 10-15 min. What can be the problem? ...
How to count existing items??
JLuv -
30 Jun 2006 6:38 PM - 9 messages
I want to check and see if an item exists within one of my tables before I go and replicate. let's say that "John Doe" already exists in a names database and the user tries to add him again, i want to notify ...
Guardar y recuperar texto con formato
Raul Romero -
30 Jun 2006 6:25 PM - 2 messages
Buenas tardes ... Por favor alguien si me pudiera indicar como puedo hacer para guardar texto con formato (Negrillas, subrayado, cursiva, espacios, etc.) en una tabla de una BD SQL y despues poder recuperar este mismo texto con el mismo formato ...
migrate sql2k dts packages to sql2k5
=== Steve L === -
30 Jun 2006 6:16 PM - 3 messages
new to sql2k5. i have some sql2k dts packages i migrated to sql2k5 using wizard and they showed up under intergration services, stored packages, msdb, but I can't open or edit any of the package. For the same packages, if I saved them as external file in sql2k, then ...
SQL 2005 Role Permissions
Sherri -
30 Jun 2006 5:51 PM - 2 messages
How can permissions be set across schemas? I have tables in one schema and views from those tables in another schema. Is this possible? If so can you point me to any articles describing how this can be done? ...
Help with this SQL script.
sa -
30 Jun 2006 5:42 PM - 5 messages
I have code below to analyze existing network username to potential new user's usernames. If no match then user gets first initial and lastname if there is a match (conflict) then if the person have middle name then first ...
Passing a parameter as list in a Stored procedure
MittyKom -
30 Jun 2006 5:25 PM - 11 messages
Hi All How can i create a stored procedure which can pass a parameter as a list. Below is sample sp: create procedure spxx (@@param1 varchar(100)) as select * from tb1 where col1 = @@param1 When executing i like would like to be able to do this: ...
Backup using TSQL Question
Mark Moss -
30 Jun 2006 5:20 PM - 3 messages
Ladies / Gentlemen When I issue the command to 'BACKUP' my Database it does so with no problem. However it appends to the last backup. How do I make it ...
TimeStamp as a String/VarChar
sloan -
30 Jun 2006 5:07 PM - 3 messages
I am passing xml into a stored procedure. So I can handle 1 or more database updates in a single call. (I already know the pros and cons of this). ... Well, I'm trying to work in some concurrency checking with the TimeStamp ...
SQL Mail Audit
Rob -
30 Jun 2006 4:45 PM - 1 message
Hi, In our company recently, two groups have merged and their SQL servers have been acquired by our support team. Some of the SQL servers acquired from the other group are configured to use SQL Mail. Unfortunately, I've don't have the expertise with SQL Mail as I've ...
SQLCMD question
A McGuire -
30 Jun 2006 4:31 PM - 3 messages
Hello, I'm trying to loop through a cursor, which is essentially querying the server names of the SQL Servers I manage. I pretty much understand this won't work, but many of you will understand what I'm attempting to do. Is there another way to approach this that will work? This will basically allow me to automate the process connecting to various servers versus having to use the tedious process of clicking "Query -> Connection -> Change Connection". ...
sql merge
brianfakemail -
30 Jun 2006 4:03 PM - 4 messages
Hi all, I googled, but didn't find answer to my problem. Is it possible to execute a single (complex) SQL query and get a merged result as explained below? 1) a query gives me back as result let's say 3 lines - these are my ...
Declare in a view
ITDUDE27 -
30 Jun 2006 3:43 PM - 5 messages
hello, I have a quick question, can you declare a varchar within a view? the code at the bottom generate error: Incorrect syntax near the keyword 'declare'. CODE: SET QUOTED_IDENTIFIER ON GO SET ANSI_NULLS ON GO
/*--------------------------------------------------------------------------------------------------- 05/25/06 - RA : starting code to query data from shamrock db
----------------------------------------------------------------------------------------------*/ ...
SQL question
Jack -
30 Jun 2006 3:15 PM - 7 messages
Hello, I have no idea what to do with this. I appreciate your consideration. CREATE TABLE [dbo].[DisplayValues] ( [u_key] [int], [GroupNumber] [int] NULL , [u_desc] [nvarchar] (50) , [u_parentkey] [int] NULL , [u_childkey] [int] NULL ) ON [PRIMARY] GO insert into DisplayValues values (1, 1, 'Accident/Injury',0,0) ...
Surprizingly poor .NET performance in SQL Server
dennis.forbes -
30 Jun 2006 2:53 PM - 1 message
Evaluating a scenario, we've created a .NET user-defined function which does nothing more than return a bigint from a previously initialized static field of a class (this value is initialized on system startup, and holds a unique runtime value, for reasons unnecessary to go into ...
Update a field after a user logs in
jmawebco -
30 Jun 2006 2:49 PM - 2 messages
I have a .NET application (2.0) and would like to do the following; A user logs into the system and when his/her identity is validated a field is updated to mart the individual as online. I want to do this by ...
Concat key Query Question
Ed -
30 Jun 2006 2:41 PM - 5 messages
I have 2 tables with the fields: FiscalYear, Account, Region, Program I want to treat these values as if they are a concatenated key. I want to compare 2 tables to see if the one table has any concatenated key in that table that ...
How to sort
Faye -
30 Jun 2006 2:11 PM - 3 messages
Here is my select statement. I would like to sort the result so that they will list by the freqency of the available data for each column. SELECT ABA_NR , SUM(CASE YEAR(SURV_YY_DT) WHEN 2006 THEN 1 ELSE 0 END) ...
Function results
sparty1022 -
30 Jun 2006 2:06 PM - 8 messages
I am trying to convert a string value, from a parameter field, into a date to insert into a SQL2005 db smalldatetime field. The function returns a bit value, which I test by using the isdate function, and if true convert this to ...
Do not Display "NULL" in Results tab
Mark -
30 Jun 2006 12:37 PM - 4 messages
Is there a setting in Management Studio to NOT display "NULL" in the Results tab for either Grid or Text view? I didn't see anything under Options. I'm currently having to do search and replace to remove it ...
Incorrect information from a "View"
mtt_trcy -
30 Jun 2006 12:04 PM - 8 messages
I am created a "view" like the one below CREATE VIEW Tenant_Yearly AS SELECT tn_proj as Company, LTRIM(prj_name) as Company_Name, tn_id as Tenant_ID, ISNULL(monthly_rent.trm_amount,0) as Monthly_Rent_Amt, ISNULL(monthly_other.tro_amount,0) as Monthly_Other_Amt, ...
Interesting interview question...........
Jaison Jose -
30 Jun 2006 11:19 AM - 6 messages
Hi all, One small question. I am having a table named maverick and having 2 fields, tkno(int) and name(varchar(20)). The table is filled with 10 entries. tkno name ...
SQL 2005 DML Triggers Auditing
Maxus -
30 Jun 2006 10:31 AM - 2 messages
Hi People, I was wondering how I could create a generic audit trail trigger for the tables in my database using SQL DML commands idealy. what I would like to do is: what changed, when it changed and who changed it. I have ...
SQL Server - Concurrent update
Microsoft -
30 Jun 2006 9:45 AM - 1 message
Hi, I am using OPEN STA to test web based application which uses SQL server as backend. My problem is the database update takes longer time even after completeing the processs. approx. it took 45mins for 100 symultaneous updates to be completed. ...
String or binary data will be truncated. How?
Waldy -
30 Jun 2006 9:34 AM - 9 messages
Hi there, I am having trouble with a stored procedure that is reporting a data truncation error when I insert into table. How can there be data ...
calculated columns in a table
samuelberthelot -
30 Jun 2006 9:19 AM - 3 messages
Hi, I have a table with fields FirstName and LastName. I also have a column FullName. Each time the table is updated, I'd like the field FullName to be calculated automatically based on the values of FirstName and LastName (FullName = FirstName + ' ' + LastName). ...
Deleting records from two tables
Peter Newman -
30 Jun 2006 8:04 AM - 4 messages
im having a very blond day .. carnt get my head round this today Im rining SQl2005 i have two tables ( A & B ) A contains the 'master' record abd B contains the 'detail' For every record in A there will be a minimum of 1 record in B ...
Code 128 from SQL
checcouno -
30 Jun 2006 7:59 AM - 2 messages
I need a function or a SP tha codes mystring into CODE128 for barcode. Some link? thanks ...
Considering blank spaces
checcouno -
30 Jun 2006 7:26 AM - 5 messages
I need to make a function for coding string in which i make difference between strings that are identical except from final blank spaces. In SQL 200 exists an option (collate set or something else) that can make SQL distinguish betwene two string like these: ...
Currency conversion
Ivan Debono -
30 Jun 2006 7:04 AM - 2 messages
Hi all, I have an application based in Germany where the currency is the following format: #.###,00 Users enter values in the above format but SQL Server requires the standard format: #,###.00 Is there a way that I can tell SQL Server to convert formats automatically ...
When sql express management studio final version will be released ?
Luqman -
30 Jun 2006 6:59 AM - 2 messages
When sql express management studio final version will be released ? Best Regards, Luqman ...
Update of field if parameter is not null
Scott A. Keen -
30 Jun 2006 6:30 AM - 4 messages
Hi, I need a little help writing the code to conditionally update field(s) if the parameter value passed in is not null. Here's my first stab at doing this, but it's very lengthy. I have to write ...
Can't create fulltextcatalogs
Lasse Edsvik -
30 Jun 2006 6:02 AM - 2 messages
Hello I have a strange problem. I'm trying to create some fulltext catalogs using management studio 2005, and it works great. But on one table I have a composite key (?) PRIMARY KEY(A,B), and when I rightclick table and pick ...
Cursor type changed?
TonyH -
30 Jun 2006 5:54 AM - 3 messages
Hi, I just posted this on sqlserver.connect since I'm not sure where it belongs. So here goes. We've recently began migrating to SQL 2005 from SQL 7 and have had a few issues. Right now we have an issue when trying to logon to the server through our ...
Tring to replace a Line Break with a <br>
Marco Napoli -
30 Jun 2006 5:44 AM - 6 messages
I am trying to replace in a SELECT statement a field's value that has Line Breaks and replace each Line Break with a <br> I cannot fined what the value should be to represend a Line Break, I tried ...
How to assign the result of READTEXT to a variable?
Jun Yuan -
30 Jun 2006 3:06 AM - 3 messages
Hi, is there a way to store the result of READTEXT function to a variable? Thanks ...
selecting on a null col.
Aussie Rules -
29 Jun 2006 11:42 PM - 9 messages
Hi, I have a date type column and want to be able to select from the table with a where clause on the date column. I want to be able to select where the date is say less than now (getdate), ...
Search
Samuel Shulman -
29 Jun 2006 10:42 PM - 7 messages
Hi Since I have never had a good search methods I am looking for some reading material/source code to know what is achievable relatively easily Thank you for your suggestions, Samuel ...
Data is there BUT could NOT find it!
Seequell -
29 Jun 2006 10:05 PM - 6 messages
Here is the situvation. I can get BO_ID Field Value based on ROW_ID but I could not get the same record if I give the BO_ID Value. Please hava a look at the following query and other details. Can someone explain why and how it happens? Is it due to QUOTED_IDENTIFIER ...
CTE, I have a dream...
guercheLE -
29 Jun 2006 9:44 PM - 2 messages
If they (CTE) were parameterized, I would stop working user functions for use in only one place. /* * CTE, I have a dream... */ With TopRatedEmployees ( @DepartmentId int ) RETURNS TABLE AS ( SELECT TOP 10 EmployeeId, EmployeeName, ...
Basic Insted Of Insert Trigger
Paul -
29 Jun 2006 9:43 PM - 3 messages
I am using SQL 2005. Could you please give me the most basic Instead Of Insert Trigger for updating a view composed of two Tables. F0r example: ProductTable Columns are ProductID (int, key) ProductName (varchar) ProductAttribute Columns are Attribute1, Attribute2, ProductID. ...
db connection jump from 350 to 2000
andrew007 -
29 Jun 2006 9:04 PM - 7 messages
Approximately once a week for the past 3 weeks we have had some issues with the custome web content management system sql database that have caused signification problems with the editorial tool and/or live site rendering. The primary symptoms have been extreme sluggishness in the tool, the publish ...
sql 2000 UDF return table function
WebBuilder451 -
29 Jun 2006 8:56 PM - 4 messages
I'm trying to create a UDF that reutrns a table and i'm attempting to ise conditional logic. So far i'm missing something. It wouldn't be the first time. Anyway, semi psudo code is below: something like this ...
Bulk Insert Problem
hedgracer -
29 Jun 2006 8:44 PM - 2 messages
I am trying to do a bulk insert with the following statement: BULK INSERT dbo.Rand_By_Day from 'C:\Test\Randfinal.txt' I get the following error: Msg 4861, Level 16, State 1, Line 3 Cannot bulk load because the file "C:\Test\Randfinal.txt" could not be ...
simple query for someone ! need a ickle bit of help
luna -
29 Jun 2006 8:44 PM - 3 messages
i have a really simple (heh select ID,surname,postcode from table) query that selects from a table 3 columns ID (key field - auto increment) Surname Postcode for example it returns 1 smith blah 2 smith blah 3 smith blah ...
Diagram of the SP relations
Just D -
29 Jun 2006 8:38 PM - 3 messages
All, Is it possible to get something like a diagram of the SP relations? I'm working with one DB and the business logic is done so that the SP can execute another SP inside itself, the next SP can call another one, etc. So ...
Performance Problems Restoring SQL 7 Win2000 DB To SQL 2000 Win2003 x64
Alexander J. Oss -
29 Jun 2006 8:37 PM - 4 messages
I have a new Windows 2003 64-bit server on which I'm running a 32-bit SQL Server 2000. I backed up the database on the old (Windows 2000 SQL Server 7) server, copied the backup file across the network, and restored it on the ...
Join 2 colums
blackduke77 -
29 Jun 2006 8:23 PM - 2 messages
Hi can anyone help me out here, i have a table which I am importing data
into usin SQL 2000 DTS,it has a number of columns but i am only
interested in the two shown below. Table name as400DocData ...
SQL Statement for finding duplicates
rwyarger -
29 Jun 2006 8:23 PM - 2 messages
Hi - Sorry for this post (as I'm sure it's been answered a million times by now), but I wasn't able to find a real clear example of what I am trying to do. I have a customer who has some data that I am wanting to import in ...
Date Conversion Help
Chamark via SQLMonster.com -
29 Jun 2006 8:21 PM - 3 messages
Here is my query SELECT TOP 1000 Team, Segment, Associate, SUM([Adjusted Weight]) AS [SumOfAdjusted Weight], SUM(ExtSatWt) AS SumOfExtSatWt, SUM(VerSatWt) AS SumOfVerSatWt, COUNT([Surv Strt Tm]) ...
Re: Advice on SQL statement please.
Tracy McKibben -
29 Jun 2006 8:17 PM - 1 message
Tracy McKibben wrote: Sorry, those CASE statements are missing ENDs... ...
Can't be rocket science to delete data older than 30 days?
Kevini -
29 Jun 2006 7:37 PM - 14 messages
Can it ? is it this simple? Or is it supposed to > ? DELETE FROM LOGRECS WHERE datediff(d,getdate(), time)<=30 ...
Advice on SQL statement please.
Russell Verdun -
29 Jun 2006 7:01 PM - 4 messages
I have a query that generates the dataset below, based on the year being filtered I get the sum of an amount Group By the type. What I would like to do is use the exact qry using a differnet date, to generate a third column ...
Select Each User last login time
Lontae Jones -
29 Jun 2006 6:59 PM - 4 messages
Hello I have a table called Logs which has 4 columns IP varchar(30), Users varchar(30), Logdate (smalldatetime), Logtime varchar(30) Not best table design but its a quick project. I need to find the most recent logdate and time for each user. ...
Is 'SET NOCOUNT OFF' required?
Cipher -
29 Jun 2006 6:30 PM - 4 messages
Normally I bracket my stored procedure code with 'SET NOCOUNT ON' and 'SET NOCOUNT OFF' statements. Do I actually have to explicitly add the 'SET NOCOUNT OFF' statement at the end of the Stored procedure or does SQL Server ...
CASE function
Rob -
29 Jun 2006 5:41 PM - 3 messages
Hi, I have a date column where the application users puposely enter a date way in the future as part of their business rule. For instance, entering the year 2033 if the given value for this date column is unknown. ...
String Load Error during C# RMO replication???
Crash -
29 Jun 2006 5:23 PM - 1 message
I have been google-ing to no avail on this one... Tablet PC Windows XP SP2 SQLExpress SP1 ..NET 2.0 I am using RMO from C# to implement a merge pull replication in my Tablet PC application. The code runs fine when the user is a local administrator on the ...
SQLXML 4.0 "timestamp" updategram question
Ryan -
29 Jun 2006 4:36 PM - 12 messages
Greetings, We're currently starting to utilize updategrams with SQLXML 4.0 and SQL 2005. Part of the research, at this point, is utilizing optimistic concurrency in the updategram using record timestamps. This seems pretty straight forward, however we're having a problem that's causing me much ...
Need to calculate a weighted average using sql
JMainus -
29 Jun 2006 4:28 PM - 4 messages
Help!!! I'm in a time crunch and need to calculate a weighted average. Example: 85% of players will win $10.00, 5% will win $100. I have a table that is storing the counter information. I just drawing a blank!!! ...
help selecting all rows that contains no null value
timhzhou -
29 Jun 2006 3:48 PM - 6 messages
I have data on MS SQL Server that have over 60 columns, I would like to select 30 of these columns that may or may not contain NULL and I don't want to write out all 30 columns and check for IN NOT NULL. Does anyone ...
Identity keys in a One-to-Zero-or-Many relationship
Richard Carpenter -
29 Jun 2006 3:19 PM - 24 messages
Considering the following: CREATE TABLE CustomerTypes ( PKCustomerType INT IDENTITY (1,1) NOT NULL, CustomerTypeDesc VARCHAR(30) ) GO INSERT CustomerTypes (CustomerTypeDesc) VALUES ('Retail') INSERT CustomerTypes (CustomerTypeDesc) VALUES ('Wholesale') INSERT CustomerTypes (CustomerTypeDesc) VALUES ('Corporate') ...
Insert in every ID
Hitesh -
29 Jun 2006 2:57 PM - 10 messages
Hi, I have a table with following raws. account Channel abc1 PT abc1 ST abc1 ZZ ...
Visio 2003 and SqlServer 2005
eXecDeveloper -
29 Jun 2006 2:41 PM - 1 message
Hi, I'd like to know if there's a tool that allow to create a SQL db from a Visio db model. many thanks in advance. ...
SP Flow of Control
Brian Shannon -
29 Jun 2006 2:27 PM - 4 messages
What happens when you run a SP inside of another SP? My case: At the beginning of the SP I want to call another SP. If I do this will the called SP finish running before proceeding to run the rest of the code? Or ...
Exception_Access_Violation Error?
MVChauhan@googlemail.com -
29 Jun 2006 2:21 PM - 7 messages
Hi all, Our production server had a raid failure, which we fixed overnight. This is where the problem started, at least i think. Now all of a sudden(after the server was restarted) i am getting following error, when one of the stored procedure gets executed ...
Help with Update, then Insert what wasn't updated statement.
rhaazy -
29 Jun 2006 2:09 PM - 2 messages
Using MS SQL 2000 I have a stored procedure that processes an XML file generated from an Audit program. The XML looks somewhat like this: <ComputerScan> <scanheader> <ScanDate>somedate&time</ScanDate> ...
Help with a Query
rhaazy -
29 Jun 2006 1:49 PM - 2 messages
Using MS SQL 2000 I will try and post all relevant information. -------- if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[FK_tblScan_tblAsset]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1) ALTER TABLE [dbo].[tblScan] DROP CONSTRAINT FK_tblScan_tblAsset GO if exists (select * from dbo.sysobjects where id = ...
Announcing_a_new_SQL_Comparison_tool_=E2=80=93_get_your_free_copy,_no_catch
yoni -
29 Jun 2006 1:45 PM - 2 messages
Nob Hill Software, creator of several SQL Server tools, now have their own SQL Server schema comparison tool. It is Superior to other tools on the market in several ways; You can download your own copy at : [link] ...
Common Table Expressions
JI -
29 Jun 2006 1:43 PM - 3 messages
Can I use a CTE inside a user defined function? If so, could you lead me to an example. Thanks, ji ...
Apostrophes and Dynamic SQL ASP
burty1109 -
29 Jun 2006 1:37 PM - 1 message
Howdy all, please assist me here. I am trying to insert an excel sheet into an Access database using a
simple SQL query, insert/update and FIXFORSQL command. This is to
remove the apostrophe and other characters that SQL hates. My problem
is that the cell contains several hundred character and it seems the
maximum amount of characters that the below fixforsql or replace
command will work with is 256 characters. Please see the code below
and help - I have needed to add a left command to only insert the first
254 characters and this works ok, I want to be able to add an unlimited
amount of characters into the memo field. ...
Back Up Strategy
SSUK -
29 Jun 2006 1:24 PM - 4 messages
Would like to take your valuable views on ,What’s the best strategy for Database back up and files back up:- I have few options:- • Using Database Maintenance plan • Using State Store ...
How to connect to a remote SQL server through a proxy server?
mizi -
29 Jun 2006 12:39 PM - 1 message
Hi, I want to connect a remote SQL server through an ASP page. But my webhosting provider told me I need using a proxy server. They said "While we do not allow remote connections to our database servers, you can ...
date comparison
Q -
29 Jun 2006 12:33 PM - 4 messages
Hi there! I'm having some problems with a query considering it's performance. I want to make a view of saleslines (table 1) joined with a purchline (table 2). The purchline should show the last purchamount of an item, ...
Query help
Peter Newman -
29 Jun 2006 11:29 AM - 3 messages
For reasons i wont go into i need to have an identity field when returning a select statement ie Select * from Table1 returnn Field1 field2 etc aa aa aa ...
Contents of a SP
Robert Bravery -
29 Jun 2006 11:24 AM - 9 messages
Hi all, How can I select the contents of a SP to a text file Thanks Robert ...
Update DateTime field to Date only
Peter Hartlén -
29 Jun 2006 11:01 AM - 7 messages
I want to update the DateTime field of a table to contain only Date information. The query below works fine but I wonder if there are better solutions to this? Example: Old values: [id] [inDate] ID1 2006-06-27 06:03:23.230 ...
alternative to union
Freddie -
29 Jun 2006 10:53 AM - 4 messages
hi, i have tables like sells, byus, rents, credits they all have a FK to table partners - partner_guid how do i get all sells, buys ... for a given partner w/ 1 query? i`ve been thinking about UNION but it will require(will it ?) me to ...
Current Process
ricky -
29 Jun 2006 9:29 AM - 2 messages
Hi I've been told that I can use the following SQL expressions to find out the current SQL being executed under a certain SPID, but for some reason I cannot get this to work. Is there something wrong, in what I have written? ...
Issues with SourceSafe integration with Sql Server Management Stud
Rowland Shaw -
29 Jun 2006 8:16 AM - 4 messages
We have a Sql Server Manageent Studio Solution, that on loading gives the following error: [ Source Control ] There appears to be a discrepancy between the solution's source control information about some project(s) and the information in the project file(s). ...
Eleminate trailing zeros in the numeric field
Subbaiah -
29 Jun 2006 8:12 AM - 2 messages
Hello, I have a numeric field with 4 decimal places. In the select query i want to eliminate trailing zeros. DB Value Result 1.1234 1.1234 1.1230 1.123 ...
Re: Find subsequent days
jsfromynr -
29 Jun 2006 7:57 AM - 1 message
Hi There, You may like to try this!! I assume that SS_From is smaller than SS_Till Select Min(SS_From),Max(SS_Till) from ShortStay where SS_WLID=3 And convert(varchar(6),'20060509',112) = convert(varchar(6),SS_From,112) And convert(varchar(6),'20060509',112) = ...
Rights running Exec (SQL)
Geir Holme -
29 Jun 2006 6:53 AM - 3 messages
Hi all. It looks like I need READ rights on the involved tables using Exec (SQL) within a prosedure instead of SELECT TableName and so on.It is not enough to have EXEC rights on the prosedure itself. Is there any way around this or do ...
XML Query
Malkesh -
29 Jun 2006 6:29 AM - 2 messages
Hi, I'm using SQL 2000. I've XML data stored ntext column. The XML is <vItem> <platform configuredProviderGuid="00000000-0000-0000-0000-000000000000" /> <properties priority="Normal" exclusive="false" /> </vItem> Now i want to create a query and want to Display Priority (Attribute under ...
sp_helpdevice - How do I access the Return Code within TSQL ?
Mark Moss -
29 Jun 2006 6:12 AM - 2 messages
Ladies / Gentlemen I would like to use the sp_helpdevice with the sp_addumpdevice to check to see if the device is already added before I try to add it again. Set @Return_Code = ( sp_helpdevice 'myDataBase' ) ...
Retrieving NEWSEQUENTIALID
Roy -
29 Jun 2006 3:44 AM - 7 messages
Hi, We are thinking of changing the primary key of our table from GUID type to squential id using the new NEWSEQUENTIALID function. But the issue we are having is how to efficiently retrieve the generated value because we need to ...
The conversion of a char data type to a datetime data type resulted in an out-of-range datetime valu
Can both SQL Management Studio (2005) and SQL Enterprise Management (2000) coexist in 1 desktop/serv
Next »
|
|||||||||||||||||||||||