Part 3: More about CASE, @@ROWCOUNT and TABLES in T-SQL

Posted on April 2, 2007 by Jag
Hello,
 
This is third in series focusing on the following topics:
 
  • A bit more concentration on CASE
  • CASE with IF
  • Utilizing @@ROWCOUNT
  • Working with TABLES (Table Variables) in T-SQL

The article is available at http://www.aspfree.com/c/a/MS-SQL-Server/Using-ROWCOUNT-and-TABLE-Variables-for-Database-Interactions-with-TransactSQL/

thanks

Jag

About Jag

.NET Architect
This entry was posted in SQL Server 2005 and tagged . Bookmark the permalink.

44 Responses to Part 3: More about CASE, @@ROWCOUNT and TABLES in T-SQL

  1. Sri Padma Latha says:
    October 17, 2007 at 3:44 AM

    {"The HTTP request is unauthorized with client authentication scheme \’Anonymous\’. The authentication header received from the server was \’Negotiate,NTLM\’."}{"The remote server returned an error: (401) Unauthorized."}"   at System.Net.HttpWebRequest.GetResponse()   at System.ServiceModel.Channels.HttpChannelFactory.HttpRequestChannel.HttpChannelRequest.WaitForReply(TimeSpan timeout)""Server stack trace:    at System.ServiceModel.Security.IssuanceTokenProviderBase`1.DoNegotiation(TimeSpan timeout)   at System.ServiceModel.Security.SspiNegotiationTokenProvider.OnOpen(TimeSpan timeout)   at System.ServiceModel.Security.WrapperSecurityCommunicationObject.OnOpen(TimeSpan timeout)   at System.ServiceModel.Channels.CommunicationObject.Open(TimeSpan timeout)   at System.ServiceModel.Security.CommunicationObjectSecurityTokenProvider.Open(TimeSpan timeout)   at System.ServiceModel.Security.SecurityUtils.OpenCommunicationObject(ICommunicationObject obj, TimeSpan timeout)   at System.ServiceModel.Security.SecurityUtils.OpenTokenProviderIfRequired(SecurityTokenProvider tokenProvider, TimeSpan timeout)   at System.ServiceModel.Security.SymmetricSecurityProtocol.OnOpen(TimeSpan timeout)   at System.ServiceModel.Security.WrapperSecurityCommunicationObject.OnOpen(TimeSpan timeout)   at System.ServiceModel.Channels.CommunicationObject.Open(TimeSpan timeout)   at System.ServiceModel.Security.SecurityProtocol.Open(TimeSpan timeout)   at System.ServiceModel.Channels.SecurityChannelFactory`1.ClientSecurityChannel`1.OnOpen(TimeSpan timeout)   at System.ServiceModel.Channels.CommunicationObject.Open(TimeSpan timeout)   at System.ServiceModel.Security.SecuritySessionSecurityTokenProvider.DoOperation(SecuritySessionOperation operation, EndpointAddress target, Uri via, SecurityToken currentToken, TimeSpan timeout)   at System.ServiceModel.Security.SecuritySessionSecurityTokenProvider.GetTokenCore(TimeSpan timeout)   at System.IdentityModel.Selectors.SecurityTokenProvider.GetToken(TimeSpan timeout)   at System.ServiceModel.Security.SecuritySessionClientSettings`1.ClientSecuritySessionChannel.OnOpen(TimeSpan timeout)   at System.ServiceModel.Channels.CommunicationObject.Open(TimeSpan timeout)   at System.ServiceModel.Channels.ServiceChannel.OnOpen(TimeSpan timeout)   at System.ServiceModel.Channels.CommunicationObject.Open(TimeSpan timeout)   at System.ServiceModel.Channels.ServiceChannel.CallOpenOnce.System.ServiceModel.Channels.ServiceChannel.ICallOnce.Call(ServiceChannel channel, TimeSpan timeout)   at System.ServiceModel.Channels.ServiceChannel.CallOnceManager.CallOnce(TimeSpan timeout, CallOnceManager cascade)   at System.ServiceModel.Channels.ServiceChannel.EnsureOpened(TimeSpan timeout)   at System.ServiceModel.Channels.ServiceChannel.Call(String action, Boolean oneway, ProxyOperationRuntime operation, Object[] ins, Object[] outs, TimeSpan timeout)   at System.ServiceModel.Channels.ServiceChannel.Call(String action, Boolean oneway, ProxyOperationRuntime operation, Object[] ins, Object[] outs)   at System.ServiceModel.Channels.ServiceChannelProxy.InvokeService(IMethodCallMessage methodCall, ProxyOperationRuntime operation)   at System.ServiceModel.Channels.ServiceChannelProxy.Invoke(IMessage message)
    Exception rethrown at [0]:    at System.Runtime.Remoting.Proxies.RealProxy.HandleReturnMessage(IMessage reqMsg, IMessage retMsg)   at System.Runtime.Remoting.Proxies.RealProxy.PrivateInvoke(MessageData& msgData, Int32 type)   at WCFSampleClient.com_tcs_india_01hw120290.IEmpService.GetNames()   at WCFSampleClient.com_tcs_india_01hw120290.EmpServiceClient.GetNames() in C:\\Padma\\WebServices\\WCFSampleClient\\Service References\\com.tcs.india.01hw120290.vb:line 134   at WCFSampleClient.Form1.btnShow_Click(Object sender, EventArgs e) in C:\\Padma\\WebServices\\WCFSampleClient\\Form1.vb:line 31"
     
     
    I am getting the above error when i am trying to run the client application.
    I have created Certificates..How should i use the? Could you please help me out?

Comments are closed.