I need to create a query that will pull in records from two tables when the IDs match, and even if they don't. If there is no matching record, I need to use the ID from table A and insert a NULL in the fields for table B. Is this doable? If yes, how, and what is the name of this kind of que...more >>

Hi all I'm trying to setup a website using asp and sql. For the time being I'm doing it on my home computer but when finished I'll be moving it to another server. Will it be possible to do this considering all the database stuff will be pointing to a differnt database? thanks for any f...more >>

I made the querry like this below: DECLARE @doc xml SELECT @doc = '£¼Team name="Braves" /£¾' but the SQL2005 told me that he can not find the XML datetype! I am appriciate if someone so kind to help me!Thanks! ...more >>

When i try to define a Default Value or Binding for an int field in sql servr 2005 while creating a new table in designer, i type either 0 or (0) but on saving the table it gets converted to ((0)) and is not accessible by the code. I have installed sp2 for sql server 2005 and still it gives m...more >>

I have the following (sample) code Set @BaseString='ABCDEFGHIJKLMNOPQRSTUVWXYZ01234567890+-' Set @myLetter='c' Set @b1=CharIndex(@myLetter, @BaseString) @b1 is returning the value 3 instead of 29 because it is case-insensitive. Can I change this behaviour? Changing collations on the ins...more >>

I'm still having problems convery a char field to a small date. The char field has something like '20070216' in it and I want to convert it to a small date. Currently I have: UPdate TWDHPO Set TWDHPO.ScheduledDateTarget = CONVERT(varchar(10),CONVERT(smalldatetime,TWDHPO.PDDTE),101) I...more >>

I backed up (full backup) a table service.mdf without the service.ldf (size 10Gb) from the live server. However, whn I restore the table to a test server it also give me a service.ldf (same size, 10Gb) together with the service.mdf. Is this normal? Does the contents of the service.ldf the sa...more >>

I have a MS SQL 2000 database, size is about 1 GB but the log id 4 GB, is there a way to clear the file to reduce the file size ? What is this file useful for ? So far I have never used it. How can I delete content or make it smaller ? Aleks ...more >>

Does SQL Express limit the speed at which it will pull data? I just converted my Access tables into SQL Express 2005. I also made some views that are equivalent to some queries I have in Access. When I run one of my views (in SQL Server Management Studio Express) it will take 20 seconds f...more >>

I have made a query to add a record with increasing sequence numbers, and it seems to work properly. insert into mytable (SequenceNumber) select max(SequenceNumber)+1 as SequenceNumber from transactiontable PROBLEM 1 -------------- However I also need to add some data to the other field...more >>

I have a table which includes two columns LM_PostNo and LM_Empno. I want to return all those rows where LM_PostNo has more than 1 LM_Empno. I am using the following query (where I know this criteria applies) select LM_PostNo, LM_Empno, Count(LM_...more >>

I'm using Access as a front end and trying to convert a string like 20070213 to a smalldate field. Here's the access code I'm using: UPDATE TWDLIN SET TWDLIN.BOLD = "#" & Mid([twdlin].[lestdp],5,2) & "/" & Right([twdlin].[lestdp],2) & "/" & Left([twdlin].[lestdp],4) & "#" WHERE (((TWDLIN....more >>

I can't find the proper parameter(s) to the <providers> statement in the = web.config file ... specifically the type=3D statement for MySql .. Any Help you can provide??? Thanks...more >>

Hi all, I'm trying to migrate an Access database to Sql Server 2005. I downloaded and installed Sql Server 2005 Express and Sql Server Migration Assistant for Access. Worked ok and has complete table migration well, including linked tables. But queries... no. The problem is that my datab...more >>

My Hosting Site provides MYSQL DB support in my package with no add'l = fee vs. SQLEXPRESS or SQL which is how VWD created the Roles & = Membership DB (.mdf). ... So, I'm needing to download and install the = MYSQL "product" ... I'm very confused in searching the NET for the = "package" I need t...more >>

I need to set the primary key on an existing column within a table. Can't somehow seem to get the syntax right. I had assumed something like:- Alter Table <table name> Add Constraint <constraint name> Primary Key <column name> <constraint rule> but this don't work !! Any help greatly appre...more >>

I seem to be spending too much time "Googling" for info on what should be a a fairly straight forward task - porting an mySQL db schema over to SQL Server. The T-SQL documentation I have seen so far do not give any useful (i.e. detailed enough) examples. My tables generally tend to have ind...more >>

I have a table and one field is 'ItemCode' nvarchar 20. The data in this field are like xxxxxxxxxx-xxxxxx The '-' is not in a specific place in the data. I want to separate the two parts of the field into two different fields, Code1 and Code2. Is there any way using a stored procedure to ...more >>

Hello, I am migrating from MS Access to MS SQL SERVER 2005. But I have a problem with my SQL queries which were running fine on Access. Below there is a query which was ok but on SQL SERVER, it gives the following errors: Msg 156, Level 15, State 1, Line 1 Incorrect syntax near the keyword '...more >>

Hi, i defined a field as 'money' (and then as 'smallmoney'). When i insert a non integer value in that field, it's rounded: e.g. if i insert 17,95, it becomes 18,0000 in the table. Any way to prevent That? thanks michel ...more >>

I have a client that was, until recently, on SQL 7.0. Two times within a month they had problems connecting to SQL from their application (Dynamics SL). They would receive an error saying XPSQL70.dll was not located. I reapplied SP2 both times and that solved the problem. A month ago they ...more >>

I am a computer idiot - but I do not know what this is or why it is on my computer - I have a computer 'tower' with a magnifying glass in my bottom window but it won't go away - does anyone have a moment to help me?? PLEASE! ...more >>

Hi, i have to insert values into two tables. The first table (base table) has a primary key (type 'int') which is incremented automatically with each insert. The second table (detail table) contains a field (type 'int') which must get the value of the primarty key of the last record in tabl...more >>

Hi, I have 2 fields in a table: fld1 of type 'int' (primary key) and fld2 of type 'string'. I only insert value for fld2. The value of fld1 is put automatically because it's defined as primary key. I use the "insert into table ..." statement. My question is after testing, i would like t...more >>

Hi Working with SQL Server 2005 I am trying to create a table with the following code create table department (dept_id smallint unsigned not null auto_increment, name varchar(20) not null, constraint pk_department primary key (dept_id) ) but keep coming up with an error. I suspect th...more >>

Just started to work with MS SQL Server and trying to figure out a query that would give me: All the tables and fields in a database. The datatypes of all the fields If the field has an index and if so if it is a unique field The index stats The field data size I can do this in Interbase...more >>

how can i disconnect users, by code, from sql server? thanks ...more >>

Hi, i need an autonumbering field like in MS Access. At first glance, i couldn't find such a field. Is there a way to get the same result? Thanks Michel ...more >>

Hi, At least I got this far and it works properly when I execute it from the QUERY area in Enterprise. (excuse me, I do not know what that area is called) DELETE FROM Orders WHERE ([Date] <= DATEADD([day], - 30, GETDATE())) I am trying to understand how to create a stored procedure. ...more >>

A co-worker recently quit the company, and all of his stored procedures and DTS packages are apparently under his name. Is there any way to change his account to another (ie administrator or SA)?? I am afraid to delete his account in fear all the stored procedures will be lost. (we have back...more >>

Hi, I am new to Sql Server 2005. We are currenly migrating from Informix/AIX. Any recommendations for a Comprehensive book on Sql Server 2005. Focus on administration with coverage on development will be wonderful. Thanks. Kumar....more >>

I must be doing some daft thing- In Management Studio Express I have Northwind, Pubs and a db of my own. I can create SQL select queries and get results back fine but when I try to do an insert, update or delete I get the message: (1 row(s) affected) - making me think all has gone well, however...more >>

What tools can I use to manage SQL 2005 that comes with SBS 2003. I need to run scheduled management tasks to backup the sql database but I appear to have not loaded the correct if any tools to do this. With SQL 2000 you had enterprise manager to do. Thanks, Joe ...more >>

I'm stuck! How do I format an update statement that includes (') in the string? UPDATE <table> set <column> = 'A'T#N' ie, I want the column (varchar(16)) to equal the value: A'T#N I know I can edit the one row at the time in SQL Management Studio, but there are hundreds... Thanks Reg...more >>

I downloaded and installed both SQL Manager Lite and SQL Server = Configuration Manager 2005. I think I'm still missing the SQL Service = (engine) since when I try to lok for my .mdf database that was created = in VWD 2005, I get the following error: SQL Service does not exist or access denied...more >>

I did this on SQL Server 2005 standard with no problem. But apparently SQL Server Express doesn't have any way to import a database. If it does, I cannot find it. ...more >>

A thirdparty application fills populates a SQL Server database, every 24 hours. It overwrites all prior data. Backup is set to Simple. It used to import all branches, but now we've changed it so only import certain branches. ( that is, a branch/office of the company) The amount of data has m...more >>

I can't think of an efficient way to do this - assuming there is one. The data I receive provides monthly sales values for each salesperson all in one record: SalesID PrevJan PrevFeb PrevMar ..... CurrJan CurrFeb CurrMar ..... I need a view/query that shows the YTD...more >>

I'm fairly new to database design. I've come across a design problem and I'm not finding many solutions online or in my library of books. When I designed our ERP system we had a single family of products, they shared 95% of the same properties and were easy to model with a single table. ...more >>

I have SQL 2k and the log file is growing so big, we have been doing full backup daily and we are so close to run of the disk space, what is the best way to shrink the log file? what would happen if I delete it? Al...more >>

I would like to know if anyone has any experience in saving a directory structure to a SL database table. What I am trying to do is have it so that a directory structure can be saved to a database. This would not be a directory structure that exists on a hard drive somewhere. It would only e...more >>

Hello to All: I have gotten my Windows 2003R2 server application to work with Access & with SQL Server 2005 Express Edition. But my application will NOT connect with SQL Server 2000 with SP3a & later SP4 installed. Previously, connecting to the MDB file on the network drive was a snap. Bot...more >>

I'm moving a couple of my SQLS 2000 databases to a new cluster and need some help. The databases themselves are no problem. I can just do a restore, but I'm unsure how to copy the jobs. All of them just run DTS packages. A few have more than one step, but these are not very complicated jobs. ...more >>

Hello to All: I'm a nube... I have a couple of basic questions... Other than the connection strings, when writing VS2005 & ADO.NET code for data access, are there any differences in the coding (.NET or SQL) between versions of SQL Server... i.e., SQL Server 2000, 2005, or 2005 Express Ed...more >>

I just downloaded SQL Server Express (along with Visual Web Developer). However I am at a loss as to how to use it - since it appears to have installed only a service/server? - and there is no obvious documentation. I ahve a lot of experience with RDBMs (Sybase, MySQL, Oracle and PostgreSQL...more >>

I fill a table based on Budgets. There are two options - budget for the month, or budget for the Year to Date. Now, I can write two stored procedures, and decide in my vb code which to run. But the SPs are similiar, so I was wondering if there was a way to do it in just one SP. Below is the ...more >>

I am using Microsoft CRM 3.0 SBE which is using SQL 2005. I had added a lot of custom fields but now find that Microsoft CRM will not let me add anymore. I went into the Microsoft SQL Server Management Studio and went to the properties for that DB and saw that the space available is listed...more >>

Hi , I am trying to see the properties of a database in Sql Server Management Studio by selecting the database properties from context menu.I am getting the following error. "provider: Shared Memory Provider, error: 0 - No process is on the other end of the pipe".How can i solve this.Please h...more >>