16,018,353 members
Sign in
Sign in
Email
Password
Forgot your password?
Sign in with
home
articles
Browse Topics
>
Latest Articles
Top Articles
Posting/Update Guidelines
Article Help Forum
Submit an article or tip
Import GitHub Project
Import your Blog
quick answers
Q&A
Ask a Question
View Unanswered Questions
View All Questions
View C# questions
View C++ questions
View Javascript questions
View Visual Basic questions
View .NET questions
discussions
forums
CodeProject.AI Server
All Message Boards...
Application Lifecycle
>
Running a Business
Sales / Marketing
Collaboration / Beta Testing
Work Issues
Design and Architecture
Artificial Intelligence
ASP.NET
JavaScript
Internet of Things
C / C++ / MFC
>
ATL / WTL / STL
Managed C++/CLI
C#
Free Tools
Objective-C and Swift
Database
Hardware & Devices
>
System Admin
Hosting and Servers
Java
Linux Programming
Python
.NET (Core and Framework)
Android
iOS
Mobile
WPF
Visual Basic
Web Development
Site Bugs / Suggestions
Spam and Abuse Watch
features
features
Competitions
News
The Insider Newsletter
The Daily Build Newsletter
Newsletter archive
Surveys
CodeProject Stuff
community
lounge
Who's Who
Most Valuable Professionals
The Lounge
The CodeProject Blog
Where I Am: Member Photos
The Insider News
The Weird & The Wonderful
help
?
What is 'CodeProject'?
General FAQ
Ask a Question
Bugs and Suggestions
Article Help Forum
About Us
Search within:
Articles
Quick Answers
Messages
Comments by Lolo1986 (Top 11 by date)
Lolo1986
25-Feb-15 16:30pm
View
This option will create a .sql file.
Lolo1986
23-Dec-14 14:05pm
View
Thanks guys! wish you happy holidays !
Lolo1986
8-Dec-14 12:28pm
View
Like you said, you can update a DB with the help of the PK, if you want to update a row.The execution plan is going to use the PK.BUT you can have a scenario where you need to update a data set, in this scenario you don't want to create a cursor to loop through each records but use an update statement based on some criteria. At this time you will realize that you execution plan won't use the PK but certainly a different index based on you WHERE clause, or maybe scan you PK, which you don't want. I am agree with most of the things you said, but it is really dangerous of saying the PK is use to update a row. You will notoce in your article in W3 Schools, they are not mentioning that a PK is used to update a row, neither on MSDN. The primary objective of the PK is uniquely identify each row of a table to enforce the integrity of the data. We are pretty much saying the same thing on 2 different point of views.
http://msdn.microsoft.com/en-us/library/ms179610.aspx
Lolo1986
8-Dec-14 12:28pm
View
Deleted
Like you said, you can update a DB with the help of the PK, if you want to update a row.The execution plan is going to use the PK.BUT you can have a scenario where you need to update a data set, in this scenario you don't want to create a cursor to loop through each records but use an update statement based on some criteria. At this time you will realize that you execution plan won't use the PK but certainly a different index based on you WHERE clause, or maybe scan you PK, which you don't want. I am agree with most of the things you said, but it is really dangerous of saying the PK is use to update a row. You will notoce in your article in W3 Schools, they are not mentioning that a PK is used to update a row, neither on MSDN. The primary objective of the PK is uniquely identify each row of a table to enforce the integrity of the data. We are pretty much saying the same thing on 2 different point of views.
http://msdn.microsoft.com/en-us/library/ms179610.aspx
Lolo1986
5-Dec-14 19:20pm
View
Hi Thomas,
"We use the primary key to control what row is to be updated," this is not true at all ! You can update a table base on whatever field you want. The primary is here only to identity uniquely each row of the table.
Lolo1986
5-Dec-14 19:04pm
View
I am doing few stuff with LightSwitch. There is an HTML version wher eyou can plug in some report. You should take a look.
Lolo1986
3-Dec-14 0:46am
View
It doesn't matter. Convert your package to run in 32bits. It will be compatible with your 64bit architecture.
Lolo1986
2-Dec-14 10:36am
View
Not sure how you deploy your DB here but you should provide us more information about the machine you are deploying from, the target, which version of VS you are using and which DB version you have.
Lolo1986
29-Sep-14 16:24pm
View
What is the data type of {sp_cr_getSubsequentVisitBySubVisitID;1.Judgement} ?? And what is the datatype of your field in the report?
Lolo1986
29-Sep-14 16:20pm
View
That's a good question :)
Lolo1986
29-Sep-14 14:55pm
View
sp_cr_getSubsequentVisitBySubVisitID that's the name of the source (look like a SP) and Judgement the name of the column.
Show More