Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
innocent73
Starting Member
20 Posts |
 Posted - 2002-05-08 : 03:35:29
|
| Hello Again,I have a predefined query in my access database named "KalipBilgisi".I can easily access to predefined query via ODBC and DAO.This predefined query treats like a view or database table on an ODBC data source.But when I migrate this predefined query to an SQL server environment I could not get it.Any idea???------------------------------------------------------------Orignal access predefined query is:PARAMETERS [ModelKoduParam] Long, [KalipKoduParam] Long, [BedenKoduParam] Long;SELECT T_MODEL.M_Adi, T_KALIP.K_Adi, T_BEDEN.BedenAdiFROM T_MODEL, T_KALIP, T_BEDENWHERE (((T_MODEL.ModelKodu)=[ModelKoduParam]) AND ((T_KALIP.KalipKodu)=[KalipKoduParam]) AND ((T_BEDEN.BedenKodu)=[BedenKoduParam]) AND ((T_BEDEN.ModelKodu)=[ModelKoduParam]));-------------------------------------------------------------and I have created a stored procedure with the same name(KalipBilgisi)----------------------------------------------------------------------CREATE PROCEDURE dbo.KalipBilgisi2 ASDECLARE@ModelKoduParam int,@KalipKoduParam int,@BedenKoduParam intSELECT T_MODEL.M_Adi, T_KALIP.K_Adi, T_BEDEN.BedenAdiFROM T_MODEL, T_KALIP, T_BEDENWHERE T_MODEL.ModelKodu=@ModelKoduParamAND T_KALIP.KalipKodu=@KalipKoduParam AND T_BEDEN.BedenKodu=@BedenKoduParamAND T_BEDEN.ModelKodu=@ModelKoduParamGO |
|
|
robvolk
Most Valuable Yak
15732 Posts |
|
|
|
|
|
|
|
Is it possible to see a UDF or St. Proc. via ODBC?