|
sql
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
How to look for values in a table
Hi - pretty basic question but I want to look up for a certain value in a
table. I have the need to modify the data in a table from time to time, the table is very large and doesn't seem to be in any specific order. Currently I have to find the right row by sight. Is there a way I can do a search for a value. I don't want to do this via query as you can't edit the data from that, I know I could write an update query to do this but if possible I just want to locate the value and amend it - much easier and quicker. Any help? Thanks You should develop your own customized application for this purpose. It
would be very easy to do that using Visual Studio. -- Show quoteHide quoteEkrem Önsoy "stacko111" <stacko***@discussions.microsoft.com> wrote in message news:E95B5922-2CD9-4548-84C4-63A8B25CD9FE@microsoft.com... > Hi - pretty basic question but I want to look up for a certain value in a > table. > > I have the need to modify the data in a table from time to time, the table > is very large and doesn't seem to be in any specific order. Currently I > have > to find the right row by sight. > > Is there a way I can do a search for a value. > > I don't want to do this via query as you can't edit the data from that, I > know I could write an update query to do this but if possible I just want > to > locate the value and amend it - much easier and quicker. > > Any help? Thanks Hmm yes - easy for someone with the knowledge to do so, unfortunately I
don't. Was just wondering if there was an easy way to find a value in a table like how you can do in Access and Excel. Show quoteHide quote "Ekrem Önsoy" wrote: > You should develop your own customized application for this purpose. It > would be very easy to do that using Visual Studio. > > -- > Ekrem Önsoy > > > > > "stacko111" <stacko***@discussions.microsoft.com> wrote in message > news:E95B5922-2CD9-4548-84C4-63A8B25CD9FE@microsoft.com... > > Hi - pretty basic question but I want to look up for a certain value in a > > table. > > > > I have the need to modify the data in a table from time to time, the table > > is very large and doesn't seem to be in any specific order. Currently I > > have > > to find the right row by sight. > > > > Is there a way I can do a search for a value. > > > > I don't want to do this via query as you can't edit the data from that, I > > know I could write an update query to do this but if possible I just want > > to > > locate the value and amend it - much easier and quicker. > > > > Any help? Thanks > Well, there's no an interface like Access' s in SQL Server. I know you said
that you do not want to bother yourself with T-SQL, but you may want to write a Stored Procedure for once and search the value using this view and another SP to amend data. Also, I remember that there is a way called Pass-Through to link tables from Access to SQL Server and I just have googled about it now and I found this link: http://www.mssqltips.com/tip.asp?tip=1482 This feature may work for ya? -- Show quoteHide quoteEkrem Önsoy "stacko111" <stacko***@discussions.microsoft.com> wrote in message news:D7C56B07-85BF-4AD7-8023-9B252C9C2136@microsoft.com... > Hmm yes - easy for someone with the knowledge to do so, unfortunately I > don't. Was just wondering if there was an easy way to find a value in a > table > like how you can do in Access and Excel. > > "Ekrem Önsoy" wrote: > >> You should develop your own customized application for this purpose. It >> would be very easy to do that using Visual Studio. >> >> -- >> Ekrem Önsoy >> >> >> >> >> "stacko111" <stacko***@discussions.microsoft.com> wrote in message >> news:E95B5922-2CD9-4548-84C4-63A8B25CD9FE@microsoft.com... >> > Hi - pretty basic question but I want to look up for a certain value in >> > a >> > table. >> > >> > I have the need to modify the data in a table from time to time, the >> > table >> > is very large and doesn't seem to be in any specific order. Currently I >> > have >> > to find the right row by sight. >> > >> > Is there a way I can do a search for a value. >> > >> > I don't want to do this via query as you can't edit the data from that, >> > I >> > know I could write an update query to do this but if possible I just >> > want >> > to >> > locate the value and amend it - much easier and quicker. >> > >> > Any help? Thanks >> I performed a test about linking a table from SQL Server to Access.
You did not mention what version of Access you use, however I performed the test using 2007 and I remember I did this before with 2003 version too. (2007) Simply, you need to go to External Data (from the ribbon menu interface) and click "More" from Import. Then create an ODBC Database connection by choosing "Link to the data source by creating a linked table." option. Create a DSN to connect to your SQL Server Instance and choose the appropriate database name as the default database while creating the DSN. Then create a Form according to your needs from Access for this updatable table. So, changes you perform from this Access application will be applied to the table in your SQL Server database. -- Show quoteHide quoteEkrem Önsoy "stacko111" <stacko***@discussions.microsoft.com> wrote in message news:D7C56B07-85BF-4AD7-8023-9B252C9C2136@microsoft.com... > Hmm yes - easy for someone with the knowledge to do so, unfortunately I > don't. Was just wondering if there was an easy way to find a value in a > table > like how you can do in Access and Excel. > > "Ekrem Önsoy" wrote: > >> You should develop your own customized application for this purpose. It >> would be very easy to do that using Visual Studio. >> >> -- >> Ekrem Önsoy >> >> >> >> >> "stacko111" <stacko***@discussions.microsoft.com> wrote in message >> news:E95B5922-2CD9-4548-84C4-63A8B25CD9FE@microsoft.com... >> > Hi - pretty basic question but I want to look up for a certain value in >> > a >> > table. >> > >> > I have the need to modify the data in a table from time to time, the >> > table >> > is very large and doesn't seem to be in any specific order. Currently I >> > have >> > to find the right row by sight. >> > >> > Is there a way I can do a search for a value. >> > >> > I don't want to do this via query as you can't edit the data from that, >> > I >> > know I could write an update query to do this but if possible I just >> > want >> > to >> > locate the value and amend it - much easier and quicker. >> > >> > Any help? Thanks >>  
Other interesting topics
Combining 2 queries
ORDER BY @OrderBy problem Intermittent and undesired SQL execution performance behavior Partition Table Split Range Performance SQL2005 spaces in T-SQL An error occurred during the execution of xp_cmdshell. A call to 'CreateProcessAsUser' failed with e the alert couldn't send an email where to find the errors generated by stored procedures 64 bit standard edition doesn't use page file Transaction Log Backup Doesn't Truncate Log |
|||||||||||||||||||||||
