Use this tag for questions specific to scaled down, free edition of SQL Server 2005.
Questions tagged [sql-server-2005-express]
193 questions
1
vote
1 answer
How to Update Two tables with single statement in sql server?
I have two tables and I want to update both the tables with single Query
Sample query:
UPDATE T1, T2 SET T1.FirstName = T2.SecondName ,T2.SecondName = T1.FirstName
FROM Table1 T1, Table2 T2
WHERE T1.id = T2.id
Is there any mechanism for doing this…
Pankaj Kumar
- 655
- 3
- 10
- 16
1
vote
1 answer
NVARCHAR appears as "Binary 0" after join
I try to do a search on a MSSQL 2005 Express server where our WSUS database is installed. I'd like to get filenames and digest values for the current revision of sepcific updates. This is the query I'd like to run:
SELECT
*
FROM
…
meilon
- 693
- 1
- 6
- 20
1
vote
1 answer
Procedure tr_EMPLOYEE2_FORINSERT, Line 10 Insert Error: Column name or number of supplied values does not match table definition
ALTER TRIGGER tr_EMPLOYEE2_FORINSERT
ON EMPLOYEE2
FOR INSERT
AS
BEGIN
-- SELECT * FROM INSERTED --INSERTED Table is a special table created for the purposes of Triggers, it is available only in the context of the trigger.
DECLARE @ID INT
…
user2935170
- 11
- 1
1
vote
1 answer
SQL Server Business Intelligence 2005 for SSIS in Express edition
Is there anyway to use Business Intelligence Development Studio with SQL Server 2005 Express Edition? Or is it available for Enterprise and Developer Editions?
If it is possible to have BIDS standalone install for SSIS?
1
vote
3 answers
How to fill a varbinary(MAX) column with a default image for all the records in SQL Server 2005 Express
I want to fill the varbinary(MAX) column of a SQL Server database table when ever a new record is created with a default picture. How do I do this using a trigger or in that case by any other means?
This is the T-SQL code I have tried:
SET…
Feroz Khan
- 11
- 3
1
vote
1 answer
Retrieve datename from SQL on DELPHI
Im using Delphi XE2 and SQL Server 2005 Express.
I have a table named maintenance with the columns:
id Integer;
Activity Varchar(x); = actividad
Description Memo; = descripcion
Day Integer;= dia_sem
User Integer; = usuario
id, activity,…
Edgar Holguin
- 179
- 1
- 4
- 11
1
vote
2 answers
SQL Server - can't do COUNT on DATEDIFF without doing CREATE VIEW
I am trying to get some information on the differences in two dates and how often that difference has occurred. I can use:
SELECT
DATEDIFF (day, db1.dbo.t1.Date1, db2.dbo.t2.Date2) AS Days
FROM
db1.dbo.t1
JOIN
db2.dbo.t2 ON…
Adrian
- 11
- 2
1
vote
1 answer
For Loop in SQL Server 2005 Express?
I have a program using SQL Server 2005 Express and I need some help looping through 2 tables to calculate inventory.
Table 1: stores all products with the inventory total upon setup
Table 2: stores the transactions against all products from table…
Matt
- 53
- 6
1
vote
1 answer
dynamic query not working properly
I am trying to write a dynamic query. The search criteria will come from an ASP page and be
passed over to a stored procedure in the SQL Server 2005 Express database. The search is not giving any errors but it returns all data in the database and…
JerseyGirl1201
- 11
- 1
- 4
1
vote
2 answers
Axapta v3.0 with SQL 2005?
I managed to find an old Axapta version to practice some programming and learn Axapta a little. The problem is I can't get it started. I had installed SP1-2-3 and started it, it is supposed to create the database. Well it creates some tables then I…
Ufuk Hacıoğulları
- 37,978
- 12
- 114
- 156
1
vote
2 answers
Linked server setup between SQL Server Express and SQL Server
Can you please explain how to setup a linked server between a SQL Server (A) and a SQL Server Express (B) scenario.
Server A is SQL Server 2000, whereas Server B is SQL Server 2005 Express.
I have set these up in the past, but none where connected…
Billy Logan
- 2,833
- 16
- 43
- 49
1
vote
3 answers
how to connect to another sql server database(server pc) in local area network
i m creating an application, inwhich client has to acces a database stored in a remote location connnected through a live ip. how can i connect simply with a database server placed in LAN. both using sql server 2005 express edition. please refer me…
user155575
1
vote
4 answers
SQL2005 Express slow from remote VB6 application
I have a legacy VB6 application that was built using MSDE.
As many client's database grow towards the MSDE 2 GB limit they are upgraded to SQL 2005 Express.
This has proven very successful until today.
I have spent the entire day troubleshooting a…
Stuart Helwig
- 9,318
- 8
- 51
- 67
1
vote
3 answers
LINQtoSQL Not saving to database,but changes show in app
Hey all, I have a linq app using C# express2008 and sqlserver express 2005 (mdf file connection)
I followed the regular dml generation and vanilla datacontext. However i created a repository class to manage the Linq stuff.
In using the functions,…
D0cNet
- 314
- 4
- 20
1
vote
2 answers
Populating Listbox with data from SQL Server
I don't know what is happening to my program, it took me (4) four minutes to load the result of my code.... can someone tell me why? Can someone tell me how to fix this loading problem?
This is my code:
Imports System.Data.SqlClient
Public Class…
Danjor
- 121
- 2
- 5
- 20