View Complete Post
I get a message - "Function without an 'As' clause" for HMAC_MD5 and "Variable declaration without an 'As' clause" for Key and Value. But the code works. But the messages still exists. Is there a way to fix this to avoid the messages?
Function HMAC_MD5(ByVal Key, ByVal Value)
Can anyone please show me the example as how to replicated the functionality same as SQL "IN" clause using LINQ to XML ?
I have an XML file that I want to filter by passing multiple values to attribute parameters.
Any help will be greately appreciated
I want to use the QueryString to specify the column names in the SQL Select expression of <asp:SqlDataSource.
One of several data bases I referr to in the select clause has the columns:
pres, sep, temp, torn are the possible values transmitted by the Query String for the column "Seccion"
Is there an elegant way to bind the column names to the Query String?
Something like MOSS_Personal.horas_<%=Request.QueryString["Seccion"] %>... which is unfortunatly not working!
I have a query which has a paging functionality and for which i'm using ROW_NUMBER() function. The order by clause in my rownumber function is dynamic and gets changed all the time when ever the sp is called. It works fine for few columns but for one column
which is of datetime datatype, it takes lot of time. Amazing thing is with when i sort by the same column in descending order, the query runs in a sec but ascending order takes lot of time :(.
I tried creating a non clustered index(as i already i have a clustered index on that table) on that datetime column but it did not help me.
Could you please suggest what i can do to improve the performance.
With linq to entities, how can I delete and update data inside a database without first selecting the complete entity at first?The idea behind this is to improve performance.