.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
david stephan
Gaurav Pal
Post New Web Links

is there a future for T-SQL?

Posted By:      Posted Date: September 30, 2010    Points: 0   Category :Sql Server

hi friends,

recently i have sent off an email to one my college tutors for .NET applications regarding the implcication of SQL in business application, i have asked him about few good books to learn sql fast track... and he told me one thing, dont worry about TSQL just do LINQ.....

So im assuming that there will be battle between TSQL and LINQ, my tutor is a C# application developer and does not like SQL that much so i did not go further analysis and queries on the topic.

Basically at the memoment, i need to refresh certain things on queries and pretty have to a fast track on sql ...... becuase all the projcts that i have done i have only got to access the sp and documentatin says input and outputs and never go the chance to see the coding into so sql fading out

Do you think the is it waste time to invest on TSQL or go straight to LINQ or know both?




View Complete Post

More Related Resource Links

Editor's Note: A Look Into the Future


Josh Trupin takes a look at mobility, the theme of this month's issue.

Joshua Trupin

MSDN Magazine December 2006

Editor's Note: Back to the Future


As we head into the cold winter months, we've got great content to keep you warm! You might wonder why I started this Editor's Note with such a tired intro, but we have a reason. We're covering a lot of fresh, exciting new material this month, and we didn't want to upstage the good news.

MSDN Magazine January 2006

Editor's Note: Designing the PC of the Future


While spending some idle moments poking around on the Web between working on articles the other day, we ran across a design challenge that Microsoft is co-sponsoring. Along with the IDSA (Industrial Designers Society of America), Microsoft is inviting all you designers out there to draw up plans for the next-generation PC.

Joshua Trupin

MSDN Magazine July 2005

Editor's Note: The Future: A Few Days Away


The past year has been full of uncertainty and change. A year ago, everything seemed to be falling into place. Windows XP was nearing final release. An RC version of the Microsoft . NET Framework was whetting our appetites for the final February release.

MSDN Magazine November 2002

The Future of Productivity: Office Business Applications Evolved

Tune in to this live and on-demand content to explore how building Office Business Applications (OBAs) has progressed as we look at the types of solutions that you can build by using Microsoft Office 2010 and Microsoft SharePoint 2010.

AUTOMATICALLY send an email on a future date

HiI would like to achieve the following. 1- if a user goes to a web page in a web application hosted on the Internet and selects a FUTURE date from a "Calendar control" the date selected and the URL for the page are stored in the database (I know how to do this step) 2- when the date selected arrives the URL will be embedded in an email that is sent out AUTOMATICALLY to the user. How can I trigger the email to go out AUTOMATICALLY on the selected date?????? Does the link below help me answer this question??  I just need a high level steps on how to do this. Your help is greatly appreciated. http://msdn.microsoft.com/en-us/magazine/cc163821.aspx

Calculate Future Age and Date

I hope someone can help me. I am new to SharePoint and I was given the task to determine all the people who will be age 65 in 90 days from today (meaning current date), and display them in a list. I haven't a clue how to do that. By the way, we are still using version 2003. I would very much appreciate the help. Thanks! Kelly  

Adding a number to a date to give a future date

Gooday     , how can i write this ,inorder to add an int' to a 'date' type and receice a 'date' type as an answer . I tried the below code but without succsess.  thanks   rob                                                                                                                                                                                                 UPDATE  

How To Do Future Data Projections


We are looking at the best way to do data projections. Recalling my math classes, linear regression (least squares) lines come to mind. Though, is there a way to automatically choose the best model; ie; linear, logarithmic, exponential? What is the best way to do this in SQL 2008? Assume we have the following data:

Month            Profit
Jan                12.4
Feb                10.7
March             14.7
April               15.8
May                19.5
June               17.3

Then we want to project the next SIX months going forward. Thanks.

SSRS Chart calculation displaying future values


I'm new to SSRS and especially to the chart features.  I currently have a line graph chart where the data points are based on a % calculation for each month of a year.  The prior years are all displaying correctly. 

The current year however shows the correct values to the present date, but rather than stopping it continues the line to the end of the chart showing the most recent value.

What can I change so that it will stop the line at the most recent data point?

The calcuation being used is "=1-(Fields!ID2009_Backordered_Lines.Value)/Sum(Fields!ID2009_Fillable_Lines.Value)"

Any insight would be appreciated!







future of wcf duplex


hi experts,

 i want to know the future of wcf duplex.

Future Release of SQL Server


Esteemed users, 


The latest release of SQL Server is SQL Server 2008. 

I was wondering what will be next version name and when will be generally available? 

Maybe people who work in MS can answer this question. I searched the web but couldn't find the information. 

Problem with future date validation using CompareValidator


Realy simple aspx page:

<asp:TextBox ID="txtExpireDate" runat="server" Width="78px" MaxLength="10" ></asp:TextBox>


Was forced to shrink a log file. How do I prevent future fragmentation

I read that one of the side effects of truncating and shrinking a large log file is that it will incurr fragmentation as it grows.  What steps can I take to prevent this?  How do I monitor the log files internal fragmentation as it grows?

PDC 2010 WPF future

PDC 2010 WPF future.. I watched the PDC 2010 video this morning and would call it uninspiring. The talk showed many applications that use WPF and I think the only thing futuristic shown was a very nice ribbon bar. Incorporating Silverlight into WPF in the demo was embarrassing as it showed the same limitation as always. WPF cant draw with opacity on these containers.
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend