Use this tag for questions specific to the 2008 version of Microsoft's SQL Server.
0
votes
0answers
6 views
Convert sub query from SQL to Linq for SQL Server 2008
I have SQL query:
select
Photo.[Path]
from
Album
inner join
Photo on Album.AlbumId = Photo.AlbumId
where
Photo.PhotoId = (select top 1 Photo.PhotoId
from ...
0
votes
1answer
17 views
SQL Server Management Studio related
I have multiple queries in SSMS and SQL Server. I will give you my pc status.
I have installed SSMS 2008. I don't see any services or servers listed under SQL Server configuration manager.
Inside ...
0
votes
2answers
24 views
using sub query and join
query to display the book code, publication, price and supplier name of the book which is taken frequently.
The above question I used this query but it return error.
select ...
-3
votes
1answer
31 views
getting started with SQL server 2008 [closed]
So I bought Microsoft SQL Server 2008 and have been trying to get it set up, but it always seems like any instructions is missing a critical component. For instance:
Create Service Accounts
...
-9
votes
0answers
31 views
Concepts in database [closed]
Please answer following question.
1) Differentiate between database schema, meta-data and data dictionary?
2) DML(Data Manipulation Language) and DDL(Data Definition Language) are common, but what is ...
0
votes
2answers
22 views
convert select query to linq on sql server 2008
I have two tables: Album(AlbumId, AlbumName) and Photo(PhotoId, PhotoName, AlbumId)
I have :
select top 1 Photo.PhotoId
from Photo
where Album.AlbumId=Photo.AlbumId
order by NEWID()
This is ...
0
votes
1answer
34 views
inserting # in a stored procedure
I'm trying to insert a # in a stored procedure in SQL Server. When I write it I have a mistake and when I delete it, it works, why?.
The line where I want to write a '#' is this:
INSERT INTO ...
2
votes
1answer
30 views
getting the connection string for MS SQL Server 2008
I am new to SQL and not too sure how to connect R to an SQL database.
I would like to use R to connect to the database, but am unsure what the string is to be able to do this.
The database is not ...
-3
votes
0answers
25 views
How to use or in case statement in SQL Server 2008 [closed]
Below requirement is in CASE STATEMENT in SQL Server:
I have two tables EMPUDF_E and CSTMSELELEM_E and key column are:
EMPUDF_E.CUSTOMSELECTIONELEMENT_I=CSTMSELELEM_E.NUMBER_I
get ...
2
votes
1answer
46 views
Showing a progress bar for a database insertion
I have an application in which the user uploads an Excel file containing several hundreds rows and when he hits upload the file is converted to a DataTable and sent to the database to be inserted by a ...
-2
votes
0answers
38 views
SQL group by and random record .Please help me
Please support for me.
I have two tables:
Album: AlbumId, AlbumName
Photo: PhotoId, PhotoName, Path, AlbumId
When I execute a SQL query:
select AlbumId,PhotoName,Path
from Photo
group by ...
0
votes
2answers
43 views
Create a table with a dynamic number of columns in SQL Server
What is the best way to implement a table with a variable number of columns and different types?
(The number of columns is unknown)
We use a column of type XML. What do you think?
0
votes
2answers
32 views
How to increment a column based on two tables that are joined
I am trying to increment a column on a sql server table based on the join between the initial table and the joined table. The idea is to update tblForm10Objectives, set the ObjectiveNumber column to ...
0
votes
1answer
38 views
Error on calling a stored procedure from java - Invalid JDBC data type -10
I have a java class from which i am connecting to the SQL Server 2008 which is on a remote machine.I Can retrieve data using a class which means the connection is working fine.
But when i try to run a ...
2
votes
1answer
42 views
MS-SQL 2008 Whole Word Matches
I've spent a few hours researching this and am pretty stumped, probably due to my in-often use of RegEx expressions.
I am looking to match a whole word in either a VARCHAR or TEXT type column in ...
