I want to know if there is a way to create a fuction in SQL Server for the following purpose. I have a select statement that pulls up a list of names from the database based on an ID which is the input parameter for the function. I want to be able to concactinate the values of names got from the query and return a String value.
View 4 Replies
i need to creat table wtih XML. This table will put the pictures.
View 3 RepliesI would like to know which one is better, table-valued function or View, in terms of perfomance.Earlier I have created view which is performing cross join (which takes time) and 2/3 Left outer join and it's taking time. To reduce execution time I have created table-valued function with parameter to reduce cross join execution time and it returns the same result as view.Just give me an idea about table-valued function and View, in terms of perfomance. Which one is better?
View 1 Replieshow can i use cursor in this function ?
ALTER FUNCTION [dbo].[GetCatIDChilds]
(
@CatID [code].....
In Sql Server, there's a Row_Number and now I want to do the same thing with LinQ when I get data from a table and I want to create a new row like Row Number.
View 3 RepliesI Getting A Problem In DataGrid's ItemDataBound Event. I Am Calling A JavaScript Function In DataGrid's ItemDataBound Which Retrun The CellIndex And RowIndex Number On Which UserClick After That I Am Re-Binding The DataGrid With jQuery Function After That ItemDataBound Event Not Working. I Want To Call The Same Function Again. Is Their Any Method To Call A Server-Side Function On ItemDataBound Event Except Client-Side Function..
View 4 RepliesHow to create sub Domain in asp.net. am created some pages in sample folder i need to create sub domain like sample.mydomain.com
how to integrate codings.
i want to creat gridview and connect it with the database.and add a text box and win i enter the id in that text box all the information about that id should be displayed in grid view.
View 3 RepliesI have a big fat problem that i cannot wrap my head around with. I have a table and on each cell dbclick event i let the user edit the content on that cell, and one of those cell have a date in it and i would like the use to input date using the datepicker thus i need to find out how to creat the datepicker dynamically, i have the following text so far but it does not work.
[Code]....
How can I put a SQL Function as 'WITH ENCRYPTION' like you can with a Stored Procedure?
View 2 RepliesI'm on training in a company and i'm making a web application with an SQL server database..Now I created everything but i need to know how to program a search function..t's the point that when I search to a computer it'll put all the pc's with the matching word into the dropdownlist..Like when you search for "A" I get all the pc's wich has an 'A' in their name, I made everything, in the query builder I made a parameter with the textbox but i need not EXACT the value I typed but verything wich has it in it.
View 6 RepliesI need to create a hash key on my tables for uniqueness and someone mentioned to me about md5. But I have read about checksum and binary sum; would this not serve the same purpose? To ensure no duplicates in a specific field.
How can implement this? do I need to write code in my vb application which populates the tables with stored procedures or can I do this from SQL server 2005 studio express?
I have a stored procedure returned a row of data which are written in business layer logics in ASP .net C#. If I bind the data in grid view, I can read the specific cell values from the grid. However, I don't want the grid view visible to the users.
If possible, no data display at all. I only need to save two cell values into variables. how to complete the getProfileValues() function?
[code]....
i am calling a scalar function from a stored procedure. Does using user defined scalar finction has a negative impact on performance.
View 1 RepliesI have a tbale in database tow tables city and Intrest I need to calculate somethign like this
city1*intrest1 + city2*Intrest2 + city3*intreste3
final result I ned to asing in other column
If I create a new EDMX model and then I import a function, then I can see my function generated in the Designer. If I perform the same process but I add a T4 template (for Self-Tracking Entities) then I loose the function definition, although TT file has code adding a region named "Function Imports". Is this a bug or am I performing something wrong?
View 1 RepliesI have the following query which returns all appointments for a given date, grouped by client and appointment date. For those clients that have multiple appointments on that date, I get multiple rows, one for each appointment time. I only want the earliest appointment for each client, which would result in only one row per client. If I add the MIN function to SchedTime, I'm forced to put all columns in a GROUP BY clause, which isn't what I want.Can I use a derived table and/or MIN(Schedule.SchedTime) to achieve this? Or is my thinking wrong to begin with?
"SELECT Schedule.ClientId, " +
"ClientData.FirstName, " +
"ClientData.LastName, " +
[code]...
Could you teach me how to make girdview pass my object (with all it properties) to my ObjectDataSource delete method please?So far the object received by the delete method has only the datakey value, other properties are null.From this article indicates that this is default behaviour - ttp://www.manuelabadia.com/blog/PermaLink,guid,c72852ae-1fdd-4934-a715-f565ceaf21cc.aspxBut i need the other properties pass to the delete method too so i can do other thing before I actually delete the record.
View 3 Repliesi try to return string value from the function i wrote for getting string value from the table for that i havecommon stored procedure
public string getdata(string str)
{
string datanew;
[code]...
Can a ASP.Net 4.0 Web Aplication use (or host) a silverlight control directly without first creating a Silverlight Application
View 4 RepliesI dont understand why this is occurring, my store pro worked ok before (and i am very sure i am not passing too many arguments to the store pro) but since i have switched to using a "formview"control it has stopped. store pro and ASP.NET with sql data source are shown below. Apologies if the formatting nacks up.
View 3 RepliesI have a problem here.In my database I store member status in 1 and 0, when it come to my gridview I need change 1 and 0 to active and inactive. My company is using Linq, so I must follow. I wrote in this style, I calling a changeToWord() function to change 1 and 0 to active and inactive.
var q=from a in db.members
select new{
mem_name=a.name,
status=ChangeToWords(a.status)
}
It compiles with no error, but when I execute the page, it prompt out a error message to me.
i have created a function to call username to pass user id as pararameter,
how to call userdefined function in asp.net
here is my function in sql
CREATE FUNCTION getusername
( @userid bigint )
RETURNS table
AS
RETURN (
SELECT login_id
FROM mst_useraccount
WHERE user_key =@userid
)
go
I've never used the RetrieveData() function and I don't know much about it.Having failed to work it out myself could someone show me some examples of how I call this method?Here's what I know about it:
1.It hadles the work of contacting the database and creating the DataSet.2. You must import System.Data, System.Data.SqlClient and System.Web.Configuration namespaces in teh web page.3. It can be called in any event handler in the web page code.I've tried typing this method in my page_Load() but I get the squiggly red underline which indicates that it doesn't recognise this method.
<asp:LinkButton CssClass="button" ID="btnApply" runat="server" OnClick="btnApply_Click()" OnClientClick="Apply1('btnApply')" >
hi ihave this functin in .vb file
Protected Sub btnApply_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles btnApply.Click
end sub
and javascript function also in aspx
function ApplySummerization(id)
{
alert("hai");
}
