I really don't know where to start here. This type of dynamic SQL is really really bad because it represents a huge gaping security flaw in the application. Imagine if a query managed to get through with the following in:
But the select (and therefore the query plan) are going to change each time...
Yes you are write, but there is caching of query plan, if i give the select statement in stored procedure string variable and pass only the where clause paramerter values but in this case i am doing this beucase in my search criteria user where clause vary on its selection.. What query you guys will suggest in this case:
Skill table has following fields: SkillName , SkillExperience
All skills are listed in listbox and user wants to search those profiles who have 2 years experience in ASP.Net and 3 years in Java, ......
I have created a DTS in SQL-server 2000 by using design wozard. It has transformation for importing data from a ".csv" file into a SQL-server database table. Its doing well.
Now I would like to change the source and destination od this DTS, how can I reset the source and destination connection properties at runtime.
Are you doing a job interview where they've given you access to the internet? You seem to be asking interview questions all over the place. If you don't know the answers to the basic questions that you've been asking, then I would suggest that a career in IT is probably not the best option for you.
Deja View - the feeling that you've seen this post before.
Using DataGridView connecting to SQL2005 database. I was able to view the dataset on one of the table that I selected.
I would like to use BindingNavigator to save or add a row onto this particular table.
Could someone please give me an example of how i'm going about to do this?
i have 6000 fields that i have to search, the Fields have different attributes, one of the Column is "Attribute_Code" it consist of 6 pairs of numbers ## ## ## ## ## ##, i dont want to tember with the first 5 pairs, but i want to Edit the last pair to All the 6000 receords.