For better online technical videos, go to http://www.pluralsight.com/
This was paid site, but we will get trail period. Good enough to get something from best resources :p
Source control is a mechanism that allows a development team to track individual changes of files in a project over time.
Have you ever used "Change Tracking" feature inside a Microsoft Word file? As you type, Word will track what you write, what you delete, and other assorted changes that you make. You are able to comment on each change, and later accept or reject them.
Source control works the same. As you work on a project that probably contains tens to hundreds of files, the source control system manages what is happening. You can audit the changes, and even rollback changes if they are not acceptable.
VS.NET Provides FREE version of TFS, Team Foundation Server.
Use it, feel it :)
Today, I was trying optimize the query. For SQL Server temporary table variables, we cannot reseed for Identity ID. So I followed below approach: This process is used while you are trying to use the same temp table variable in while loop. Delete all the records from the table. Then while Inserting you can use Row_Number() to freshly start with new IDs from 1,2,3, etc. DECLARE @index int SET @index =0 DECLARE @TAB TABLE (ID INT ,VALUE VARCHAR(100)) INSERT INTO @Tab SELECT TOP 2 ROW_NUMBER() OVER (ORDER BY name) AS Row ,EmployeeName FROM dbo.Employee llb --ORDER BY llb.LoBName SELECT * FROM @Tab DELETE FROM @tab -- deleted two reords INSERT INTO @Tab SELECT TOP 4 ROW_NUMBER() OVER (ORDER BY name DESC ) AS ID ,EmployeeName FROM dbo.Employee llb --ORDER BY llb.LoBName desc SELECT * FROM @Tab -- now we got new 4 records starting from ID : 1,2,3,4
Hey Guys, For SQL Server 2008, sometimes we might not get auto-complete feature. In scripts, keywords to be in UPPER case. While formatting, it would be difficult. So we have a FREE tool from APEX, it is an add-in for both SSMS and VS-IDE. http://www.apexsql.com/sql_tools_complete_features.aspx For Intelligent SQL auto-complete add-in Code smarter, faster, and easier. Try it, its worth installing the tool. Enjoy guys!!
In VB.NET, We generally use ternary operator, IIF. Today we came across with some atypical behaviors. Dim a As Boolean = True Dim b As Integer = 1 Dim c As Integer = Nothing Dim d As Integer = CInt(IIf(a = True, b = 3, c.ToString())) What is the result? It throws error. Null cannot be converted to string. But if we use same statements with IF..ELSE, it will give you correct result. If (a = True) Then b = 3 Else Response.Write(c.ToString()) End If It works fine. First observation: In IIF, it evaluates both true and false conditions. That’s why it gives error. Another example: Dim a As Boolean = True Dim b As Integer = 1 Dim c As Integer = 2 Dim d As Integer = CInt(IIf(a = True, b = 3, c=4)) What is the value of B now? It should be 3, right? But, it will be 1. Yes One Second observation: a= true is right, so it goes to b=3 statement. But it won’t consider it as assignment, instead it treats as conditional EQUAL operator. So b= 3 means is 1=3 ? Obviously 1 is not equal to 3. So it returns false, which is 0. Note: When Visual Basic converts numeric data type values to Boolean, 0 becomes False and all other values become True. So my dear folks, please be careful while using IIF in VB.NET. Few things seems to be simple but very dangerous.
Samanyudu mamuluga - Bhayameste bederevadu.. Bhadeste Aedchevadu.. Kopamoste arichevadu.. Sahanam chaste teginchevadu.. Mari samanya bharateyudu ?? Aedythe adhaiendi.. manaku voregedemundhi.. enka poidemundhi anukoni pattinchukovadam manesevadu.. Btw, lite teesko -Sri
Viluvalaku manugadaleni e visala jagathi lo Edyna cheyalane aakanksha Cheyagalama ane sandheham Cheyileni chetaganitanam Alochanalu anni prasnardhkalu Kaanarani dharulu Chesedhileka thalavanchi saginche jeevitham Ae geetha samanyudi thala raatha marchuno mari!! - Sri