1
Updating SQL 2000 Data
Hi I have a database with test card numbers, I have encrytpted the card numbers and updated the database, when i run a card scanner program on my MDF file it still finds the cards that i have updated. how can i get rid of these permanently. I have a deadline to apply this same principle [...]
Answer Question
| March 31, 2012 3:56 PM
MDF File, SQL 2000, SQL Data Set, SQL Database
Hi I have a database with test card numbers, I have encrytpted the card numbers and updated the database, when i run a card scanner program on my MDF file it still finds the cards that i have updated. how can i get rid of these permanently. I have a deadline to apply this same principle [...]
Answer Question
| March 31, 2012 3:56 PM
MDF File, SQL 2000, SQL Data Set, SQL Database
To increase number and combine data using sql
hi, I want to create a sql that generate a number of 4 digits with combination of character input.The number will increase if it is new record. for example : category = ‘P’ so the output will be : P-0001 for the next record the output will be : P-0002 any ideas? thanks.
Answer Question
| September 22, 2010 3:39 AM
Oracle, SQL, SQL Data Set, TOAD
hi, I want to create a sql that generate a number of 4 digits with combination of character input.The number will increase if it is new record. for example : category = ‘P’ so the output will be : P-0001 for the next record the output will be : P-0002 any ideas? thanks.
Answer Question
| September 22, 2010 3:39 AM
Oracle, SQL, SQL Data Set, TOAD
steps for accessing sql data through ado.net code over LAN NETWORK
steps for accesing sql data through ado.net code over LAN NETWORK
Answer Question
| August 10, 2010 5:29 AM
ADO.NET, SQL, SQL Data Set, SQL Server 2005, Visual Studio 2008, Windows 7, Windows 7 in 2010
steps for accesing sql data through ado.net code over LAN NETWORK
Answer Question
| August 10, 2010 5:29 AM
ADO.NET, SQL, SQL Data Set, SQL Server 2005, Visual Studio 2008, Windows 7, Windows 7 in 2010
SQL query How to select nth row from a table if they are not in any order
How to select nth row from a table if they are not in any order
Answer Question
| July 30, 2010 8:40 AM
SQL, SQL Data Set, SQL Query, SQL tables
How to select nth row from a table if they are not in any order
Answer Question
| July 30, 2010 8:40 AM
SQL, SQL Data Set, SQL Query, SQL tables
SQL Server 2008 query To Find Columns with incorrect information
This is difficult to expalain so i will try and give you an example Record Surname Age Town 1 Smith 50 SMITH AB 2 Jones 45 Leeds 3 Patel 38 PATEL AR What someone has done is put in the wrong data in town name and instead used details that we put in a different field. What i [...]
Answer Question
| July 1, 2010 11:09 AM
SQL Data Set, SQL Database, SQL Query, SQL Server 2008
This is difficult to expalain so i will try and give you an example Record Surname Age Town 1 Smith 50 SMITH AB 2 Jones 45 Leeds 3 Patel 38 PATEL AR What someone has done is put in the wrong data in town name and instead used details that we put in a different field. What i [...]
Answer Question
| July 1, 2010 11:09 AM
SQL Data Set, SQL Database, SQL Query, SQL Server 2008
Textbox input to a a sql dataset table in Vb.net
How do I input data from textboxes in Vb.net to …a table in a data set ….and then display generated data back to some more textboxes ???? I am using sqlexpress ….Thx. mace100
Answer Question
| January 23, 2010 3:24 PM
data input, SQL, SQL Data Set, VB.NET
How do I input data from textboxes in Vb.net to …a table in a data set ….and then display generated data back to some more textboxes ???? I am using sqlexpress ….Thx. mace100
Answer Question
| January 23, 2010 3:24 PM
data input, SQL, SQL Data Set, VB.NET
1
