I've got dynamically changing columns in a table. One way is to define many parameter columns in this table with the datatype nvarchar and a second table that is defining the datatype, max and min values of these parameter fields. Because I want to have more flexibility I think to save the ...more >>

Hello I am using SQL Server 2000, SP4 I am calculating number of hours passed between two dates. Both dates have time set to 00:00:00. I use datediff function it works ok unless the time interval I pass includes date when time is changed due to Daylite Saving Time (DST) issue. Instead of...more >>

Dear all, I need to insert 200 rows data with the same fields data. e.g. Column-A Column-B Column-C A B C A B ...more >>

Dear all, I want to insert 10 rows data as follows column-A column-B column-C A A 1 A A 2 A ...more >>

is there any limit to how long of a string SqlDataReader.GetString() can return? ...more >>

I'm running into an issue where CHARINDEX on a text datatype column returns 0 if the expression I'm searching for exists at a position greater than 8000. For example: use pubs; select charindex('New Moon Books',pr_info,8000) from pub_info returns zero, even though I know 'New Moon Books...more >>

I'm in query analyzer and I have 2 databases on this same server that I want to reference in a query. How do I go about doing that? In other words, I want to create an insert query which takes records from one database and inserts them into a table in another database. Thanks, Brian ...more >>

Hi, How to getting a previous rows result to currect rows by using sql query, like below example... ColsA Rows1 ColsB Rows1 ColsA Rows2 ColsB Rows2 ColsA Rows3 ColsB Rows3 ColsA Rows1 * ColsA Rows1 = ColsB Row1 Next ColsB Rows1 * ColsA Rows2 = ColsB Row2 Next ColsB Rows2 * ColsA...more >>

I'd like to execute a stored procedure that needs 5 parameters. One of them is an OUTPUT parameter. What does the exec sp_name... code, executed in QA SQL Server 2000, look like for this? Also, if the OUTPUT parameter is declared last in the spoc, how can I call it by name as the first p...more >>

My C++ SQLDMO app correctly reports the database property SpaceAvialableInMB on SQL2000, but is way off on SQL2005. For example, in SQL2005, it reports SpaceAvailableInMB as 108MB, but viewing the database's property pages displays a space available as 32Meg. I am just using the SQLDMO Dat...more >>

Current situation, an extended stored procedure in C++, which accept around 100 input parameter, some calculation (no database, I/O, etc) and ouput about 100s parameter. To use the extended stored procedure, open a cursor on a big table with millions of rows and pass column values as para...more >>

Hi, Computer A is where is installed SQL server 2000 and the BE. Computer B, I have the FE (ADP in access 2003). The both computers are connected the internet. So, how can I connect to SQL Server over the internet? I mean, I want connect my FE Computer B) to BE (computer A). I listen somet...more >>

Hi, What is wrong with the following query? select a.name, rtrim(a.name) from ( select top 100 name from dbo.table1 )a whre table1 has the following in name column A.B.xyz<space> AB.xyz<space> and so on... When i cut and paste the result set from query analyzer into Exce...more >>

Using SQL2k. When I run the command below in query analyzer I get 3 columns of info. However, when I run the same SELECT from code I get nothing. Can anyone help? Thanks. SELECT SERVERPROPERTY('productversion') As SQLVersion, SERVERPROPERTY('productlevel') As ProdLevel, SERVERPROPERTY('...more >>

I've been squeezing my noggin trying to figure this problem out with little to show for it though I admit my SQL ability is dismal. I have 3 tables as follows (greatly simplified here): tblProperties int ID 1001 1002 1003 tblOwners int ID 2001 2002 2003 tblPrope...more >>

I recently had the misfortune of writing a query which came up with the following error: Server: Msg 8624, Level 16, State 24, Line 11 Internal SQL Server error. Article Q280468 directly relates to this issue (last reviewed October 16, 2003) and STILL IS NOT FIXED. SQL 2005 gives a COMPL...more >>

I got the following error message: Deploying File: c:\work\apper\debug\RSql.dll Deployment to database failed Function signature of "FillRow" method (as designated by SqlFunctionAttribute.FillRowMethodName) does not match SQL declaration for table valued CLR function'MyUDF' due to column 1....more >>

I have three tables: 1. SoftwareSupported, 2. VersionsSupported, 2. MappingTable (this one marries the two) SoftwareSupported(SofwareID[PK], SoftwareName) VersionSupported(VersionID[PK], SoftwareID[FK], VersionDesc) MappingTable(AppID[PK], SoftwareID[PK], VersionID) Facts state that: 1. ...more >>

Looking at an if exists statement created by SQL Enterprise Manager such as: if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[DeleteAllData]') and OBJECTPROPERTY(id, N'IsProcedure') = 1), what does the N do? I've seen cases where it is and isn't necessary, but I cannot f...more >>

we are medical company I need to a some words to the dictionary that SQL containstable uses how can I do it? These are not noise words example the 2 letters SP is a word we use over and over also HiCNR -- cindy...more >>

I am trying to convert a 10 character field (all records are 10 digits, no letters) into a 10 digit numerical field. I have been trying for some time now ;) Can someone see why this wont work: UPDATE tabletoupdate SET newfieldnumeric = convert(substring([oldvcharfield] as numeric (10,0)) ...more >>

Hi All, Is there anyway to tell the frequency of joins between two tables in a database?. I need help on this one. Thanks. -- Message posted via http://www.sqlmonster.com...more >>

Oops - posted this to the wrong ng. This is more appropriate: I have two tables, Table A and Table B. For the sake of this, we will say that their DDL is identical. They have an associated key, ID. I need to return for each ID only those columns that are different. A plain English state...more >>

Is there a way to list all tables used in a SP? I have a very large DB that has a couple hunderd tables and I need to know what tables are used by about 85 SP. Thanks. G. ...more >>

Hi, Is text datatype supported in triggers in SQL 2005? Thanks Christian ...more >>

I am having a hard time figuring out how to include my PK constraints in the Import/Export wizard. I have a large number of tables that I am exporting to a production machine. The tables on that machine should, in many cases, have the tables recreated instead of have data appended to them. ...more >>

I have 4 processor SQL server. When I run this query in query analyzer (two table joins with weekly aggregation approx 500,000 rows each) ... it takes only 7 seconds.... when I run it in a stored procedure.... it takes about 60 minutes. I dont see parallelism in the execution plan of SP.... I ha...more >>

I have a .net application that is using SQLDMO.dll and I'm wondering about best location to install it. Right now we just add it to our application path but I have seen reference to others creating the Microsoft Sql Server directory and dumping it in there. Does anyone have any insight about a...more >>

Greetings, In SQL Server (7, 2000), can we bulk insert data from a data structure (any possible kind) from the memory without using physical file as source. Thanks in advance, Don *** Sent via Developersdex http://www.developersdex.com ***...more >>

I am in the process of trying to extract data from a column and insert into another table. I need to extract the bold characters within each attribute of the column. It begins at the 15th character and 3 characters long. H 5555 I 12345WAT F6 The database has been moved from MS Access a...more >>

I'm creating a new SQL 2005 Express database and want to have a Customers table. How do I auto-increment the CustomerID field? Programming in VB.Net 2005. I'm new to SQL, so go easy on me please ;-) -- TIA, Burt =============================== There's nothing so permanent as ...more >>

In the last hour a few people have referred to the site: = http://www.sommarskog.se/error-handling-II.html I am trying to figure out the error checking. I used the document and = the bol. For example, I cut this from the bol: USE pubs GO UPDATE authors SET au_id =3D '172 32 1176' WHERE au...more >>

To all, I am totally new to database programming and SQLServer. I need to find out how to "copy" the data in database 1 to the database 2. How, in general one does this type of "copy" or "migration". Is there a SQL standard way to do this? Thanks in advance. Reza ...more >>

I have some legacy C++ code and I am creating a C# project for UDF function and another project for C++ classes. I always got error message when I am trying to add reference to the class lib project: A reference to 'classModel' could not be added. SQL Server projects can reference only othe...more >>

I have several functions written that simply format dates. I was told that this string manipulation kind of stuff was much more efficient in the C# than in T-SQL, but I have written the same function in C# and ran it in a timed performance test calling it in cursor loop and the T-SQL function...more >>

Hello there, After connecting a legacy access application to sql 2005 (prior connected to a database in sql 2000, the database remains identical) I founded this strange behaviour : print messages, or even sql warnings cause recordsets not returning any information example, this works:...more >>

hello, i have a table Orders with 3 columns OrderCreationDate(varchar(10) Material int OrderQuantity int in the example there is only used material (1,2,3,4) example 20060401 1 10 20060401 4 1 20060401 2 5 20060404 1 11 20060405 4 10 20060405 3 13 20060408 2 24 i want t...more >>

Hi, sorry for the cross-post but I'm a bit unsure on which side of the line I could find such things. I'm looking for a T-SQL Parser in .NET that produces an abstract syntax tree. Ideally it should also be able to parse Stored Procedures as well. I would hate to have to write one myself but w...more >>

Dear All, How can I assign an image to an image-field in a SQL Server 2005 Express with the tooling of Microsoft (I have Visual Studio 2005 Team edition). I cannot find a way. Further I tried to write an small program with an DataGridView, but here I can fill in all other fields except the...more >>

Hello, I was wondering if under SQL Server 2005 and its new support for developers if there are events exposed in a traditional sense that can be trapped for using C# and VB.Net? Thanks & Regards, TC ...more >>

I was trying to write a stored procedure last night. I figured I could break it out into two Transactions to allow for faster release of resources. For some reason I could not. My transaction format was basically: Declare variables Begin Tran Code Code Code Commit If @@...more >>

What is the best way to create a M:M relationship between a column and itself. For example I have a table of suburbs and I would like associate with each suburb it's surrounding suburbs which effectively will be a M:M relationship with itself ? CREATE TABLE Suburbs ( SuburbID INT IDE...more >>

Why would this not format a date into the dd/mm/yy format ? CONVERT(datetime, Actioned,103) As Actioned Actioned is a column of type datetime. Thanks in advance... ...more >>

Hi, I am using disconnected ADO record sets while using an Access DB for storing my intermediate values in processing. I had initially used a server side cursor, however it gave a bad performance while inserting a record one at a time. Now using a client side cursor gave a decent pe...more >>

hello Is it possible to select the return status i.e. declare @rs int @rs = UPDATE DeliveryTable SET Status = 2 WHERE Status = 2 it would be nice if @rs then would hold the value of changed rows. thanks ...more >>