For questions specific to the 2005 version of Microsoft's SQL Server.
1
vote
0answers
8 views
how to rollback committed data in sql server 2005
by mistake i have updated my table without any condition like update mytable set status = 1 and all row of my table got updated.
Can committed data be rolled back in SQL Server? If yes then how can we ...
0
votes
1answer
11 views
Visual Query Designer in MS SQL Server Management Studio
Is there any Visual Query Designer or builder in MS SQL Server Management Studio 2008 ?
Where is it ? which menu ?
0
votes
2answers
19 views
how to find foreign key mapping?
I have a Database in MS SQL Server 2008 .
It has a table BRANCH.
this table has a column BRANCH_ID. This is a foreign key to another table.
I want to find to which table this foreign key is ...
1
vote
1answer
16 views
SQL Server - Keep synchronized a read-only database
I need to keep synchronized a couple of databases, one is on sql 2000 and the other on 2005. The one on 2000 should be kept in read-only mode to make sure the users does not enter data. The 2005 is ...
0
votes
2answers
11 views
LDF file continues to grow very large during transaction phase - SQL Server 2005
We have a 6 step where we copy tables from one database to another. Each step is executing a stored procedure.
Remove tables from destination database
Create tables in destination database
Shrink ...
-1
votes
1answer
26 views
Conversion failed when converting from a character string to uniqueidentifier - why?
I am getting this error when running:
SELECT *
FROM repsresidents rr
LEFT JOIN
(SELECT *
FROM residents r1
INNER JOIN
(SELECT res_peopleidy AS peopleidy,
...
0
votes
2answers
50 views
How to join multiple tables (SQL) to find the difference between an order and shipped quantities?
I have a collection of orders that were submitted to an internal ERP, which were processed and partially shipped.
The table hierarchy is as follows:
Order table contains OrderReference(PO), OrderID
...
0
votes
1answer
21 views
how to generate 3digit cyclic sequence number in sql server
Pleas suggest how can I do this in Sql server 2005. It looks v2005 doesn't support?
CREATE SEQUENCE DecSeq
AS decimal(3,0)
START WITH 125
INCREMENT BY 25
MINVALUE 100
MAXVALUE 200
CYCLE
CACHE 3
0
votes
0answers
23 views
Select @@version and select serverproperty gives different product levels (SP versions)
While checking the current version of SQL Server using select @@version and select serverproperty I get different product levels (SP versions).
One gives SP2 and other SP4.
SQL Server 2005 is in ...
3
votes
3answers
29 views
Get substring from varchar column in SQL server table
I have one column called Name and in the column I have values
Name
001 BASI Distributor (EXAM)
002 BASI Supplier (EXAM2)
MASI DISTRIBUTOR (EXAM002)
MASI SUPPLIER (EXAM003)
EXAM_ND Distributor ...
-1
votes
2answers
39 views
query solution sql
i struggling with query:
select bl.REF_CORP_ID as [Dept id] , bl.REF_CORE_BUDGET_ID, rc.Col_1 , bl.SubmittedDate as [Created Date time] , bl.APPROVED_BY , bl.APPROVED_DATETIME , bl.APPROVAL_FROM
from ...
0
votes
1answer
16 views
Using NamedParameterJdbcTemplate, how to retrieve record sets from sql server that match a list of regex patterns
I'm new to spring framework. I'm trying to retrieve record sets from a SQL server 2005 database table using NamedParameterJdbcTemplate that matches multiple patterns(patterns are stored in an ...
0
votes
1answer
16 views
Xquery (SQL Server 2005/2008) except / outer join?
I'm using SQL Server 2005/2008 xml/xquery. I have the following xml and I want to return all the elements in <all> except these in <except>.
declare @x xml = '
<except>
...
0
votes
0answers
17 views
Seperate complex comma seprated string
I have table that stores comma seperated strings - I've created a solution via PHP that can seperate the array and display the data as required; however, I now have the need to do this strictly by SQL ...
-1
votes
1answer
19 views
Send email on buttonclick event in asp.net 3.5?
I'm developing a web application where after filling in a registration form, I want a button click to send an email to the address which is specified in the textbox of that particular form.
Consider a ...
