Database

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

liquid_ wrote:

There is no straight way to create function or procedure or I don't know about it.

WHERE Land_use_code LIKE '%R%'

new SQLCommand("...WHERE (Land_use_code LIKE '%" + Landusecode1 + "%'");