Database

mjawadkhatri wrote:

this query is not working.. please tell me ERROR

select firms.nmbr as nmbr, firms.name as name, "firm" as type from firms
UNION
select people.id as nmbr, people.surname as name, "people" as type from people;

select firma_adi[Kişi/Firma],telefon1[Telefon No],telefon2[Telefon No],Telefon3[Telefon No],Telefon4[Telefon No],Telefon5[Telefon No] from Firmalar
Union
select kisi[Kişi/Firma],numara1[Telefon No],numara2[Telefon No],numara3[Telefon No],Numara4[Telefon No],Numara5[Telefon No] from Rehber

khurram_shahzad wrote:

Such that if i created a database then i know all my data is in this created database ..... but if i talk about creating/using stored procedures then were are they stored

select * from sys.sql_modules where object_id=object_id('Name_of_your_sp')

jadughar wrote:

I would like to know how to create a view in Access???

jadughar wrote:

In SqlServer there is a folder "Views" where u can create views in a very simple way.

jadughar wrote:

Searching with google i found that in access are used sql queries instead of views, but didn't understand well.

SELECT * from table where subpart_id IN (SELECT subpart_id FROM parts_table where part_id='1001')

Hiren Solanki wrote:

Your question is not quite clear on what you want to exactly achieve.

liquid_ wrote:

Is it possible at all?

USE [AdventureWorks]
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER function [dbo].[fn_Join](@managerID int)
returns varchar(max)
AS
BEGIN
DEclare @ret varchar(max)
SELECT @ret = SUBSTRING(
(SELECT ',' + s.Title
FROM HumanResources.Employee s
WHERE ManagerID = @managerID
FOR XML PATH('')),2,200000)
RETURN(@ret)
END

select distinct ManagerID,dbo.fn_Join(ManagerID)
from HumanResources.Employee
WHERE ManagerID is not null