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 |
|
Tamer
Starting Member
22 Posts |
 Posted - 2008-08-27 : 07:58:27
|
| Dear Experts,How can I search for a specific value in a specific field withoutbrowsing any table or transfering data to another table.In other words,how can I move the pointer from the top of the tableto the record containe the value by SQL statment?Thanks In AdvanceTamer |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-08-27 : 08:03:48
|
| didnt get you. pointer? which pointer you're refering to? |
 |
|
|
Tamer
Starting Member
22 Posts |
Posted - 2008-08-27 : 08:24:15
|
| If you insert a record the pointer will be set on this recordand if you delete a record the pointer will be on the previousrecord.my question is how can I move this pointer to record by particularcriteria ?Is there in the SQL something called locate ? what this syntax do ? |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-08-27 : 08:27:49
|
| pointer? there's nothing like such a pointer in sql |
|
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2008-08-27 : 08:29:20
|
| Use QuerySelect columns from tablewhere col='some value'Dont open the table from Management Studio/Enterprise ManagerMadhivananFailing to plan is Planning to fail |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-08-27 : 08:35:03
|
quote:
Originally posted by madhivanan
Use QuerySelect columns from tablewhere col='some value'Dont open the table from Management Studio/Enterprise ManagerMadhivananFailing to plan is Planning to fail
ah..so was that pointer one in SSMSi could guess that  |
|
|
|
Tamer
Starting Member
22 Posts |
Posted - 2008-08-27 : 09:12:26
|
| I think the only way to search for a value in the SQL is to put itin a virtual table by a query.Thanks everybody |
|
|
|
|
|
|
Search