I am trying to replace all null value with space for all columns in a table.
(note: just we have to pass parameter table name "XYZ" result will come aotumaticly, we dont need to bother about column name)
i have done it through C# application. but love to do it through Sqlserver only like using storeprocedure, function.
my C# code is like that
[code]....
I am SELECTING two columns:
SELECT ([FirstName] + [LastName]) AS [FullName], UserID WHERE CustomerID = @CustomerID
I would just like to know if there is a way to add a space between the two columns in the select statement.
This SqlDataSource Binds to a DropDownList so TextValue = "FullName" and DataValue = "UserId"
but of course, the way it is now the fullname is all one word.
I creat a Family Website and i use Dataset to get Family members from sql databace.
In my databace i have MemberID, Name, MiddleName and Last Name.
I want also return the Member FullName and i use this Query to return the members from database table:
SELECT MemberID, ParentID, Name, MiddleName, LastName, Name + MiddleName + LastName AS FullName
when we have Name="Jon" MiddleName="" Lastname="Smith" it return JohnSmith
my only problem is how can i get space between the Name MiddleName And Last name like "Jon Smith"
How to replace a character in a String to space or white-space?
View 3 RepliesI'm trying to add these 4 co,umns to the table as bit type woth a defaut of FALSE. What am I doing wrong here? I get a syntax error near (
create PROCEDURE [dbo].[AddADIFields]
AS
ALTER TABLE dbo.tblTESTS ADD (AI1 Bit 0,AI2 Bit 0,AI3 Bit 0,AI4 Bit 0)
I have created a table in my SQL database that has a primary column (Title) and another column named Callsign. How can I access the table row that has a certain title and Callsign using C# in a web page event handler?
View 7 RepliesIs it possible in to set up an SQL table column to have multiple values? Or would I have to put my values into a new table and link it to the original one?
View 6 RepliesI have just started using LINQ with VS2008. I have added extra columns to my table, saved the changes, but class ClassName.Designer.CS didn't get updated. What do I have to do to updated the class? Do I have to do it manually, or is there a way to automatically synchronize tables and ClassName.Designer.CS?
View 2 RepliesI wanted to know if it is possible to dynamically add columns to a table in the Database?I know how to create a table dynamically in the DB the code for it is given below, howver I do not know, how do I add columns to it dynamically.
Dim NewTable As String = "CREATE TABLE Dynamic " +
" (" +
" job_id smallint" +
" IDENTITY(1,1)" +[CODE].....
i want to pass null value into varbinary(max) column n to by table
if i do like this i have this function in my app_code .vb class
Public Function Remove_Attachment(ByVal Id As Integer) As Integer
Try
Dim db As New dbAccess
db.commandText = "SP_RemoveAtt_DML"
db.commandType = CommandType.StoredProcedure
db.addParameter("@InOutVal_Id", Id)
db.addParameter("@Document", System.Data.SqlTypes.SqlBinary.Null.Value)
db.executeQuery()
Catch ex As Exception
Throw ex
End Try
End Function
i got this error. Data is Null. This method or property cannot be called on Null values.
how can i find the total null values in a table without using sql cursor .
i want to find the percentage of the data which is avaibale in the table and how much percentage of data is unavailable ( or null). to make a comparision chart.
i have 6000 rows and 200 columns in a table , if i use sql cursor , it is taking too much time to execute ( 6000 * 200 ) loops. is there any inbuilt-function in sql to do it .?
I've requirement where user can enter multiple columns like first name, lastname, email, age, sex fields and insert them into database.on my frontend aspx page, i'll be showing a single row initially with 5 text boxes(first name, lastname, email, age, sex) and a button to add more columns. when user clicks on add more, another 5 textboxes will be shown and then i'll be taking 5 + 5 (textbox values) and comma seperate them and need to insert into a table with primary auto increment key ID and the remaining 5 columns(firstname, lastname, email, age, sex). I previously worked on the same requirmeent but with only single column. Now i need to insert for 5 columns, How can i do this? Below is my stored proc which i used for single column insertion.
[Code]....
I'm using to replace space with background color in my editor. txt1.text = " ";
This displays output as text instead of adding empty space.
If i use " " which in return shows empty space with no padding and no margin almost invisible with no background color. I want to add so that I can see proper space with background color.
I set the CellPadding and CellSpacing properties to 0 and BorderStyle to 'None' on my gridview.
I set up a hover event on the row so that the entire row is highlighted on mouse over. When this happens, I can still see a gap between the two columns.Am I missing a property setting here?
I know this might be a trivial question but I can't find how to do it...
I want to increase the space between the columns, there barely is any space, the columns are just very near each other...
I have a problem with DataSet.GetXml() in ASP.NET 4.0:
First I populate the dataset with some tables.
Then I run the .GetXml() method on the dataset and some XML is returned. The output of this method is not want I want it to be, however.
The desired result is this:
[code]....
How do I stop this from happening? I mean, how do I stop the cell from being included at all?
In ASP.NET 1.1 the same code is used and the desired output is returned. This means that it is probably some new thing in 4.0 that I have to switch on/off. But what?
i have a grid view that displays a load of figures, and as there is a lot of zero's in these tables i wondered if it would be possible to just display nothing were there is a "0" ... just to make it look cleaner?
View 13 RepliesI have two columns first name and last name , that have duplicates, how can i remove the duplicates and only leave the distinct members intact?
View 6 Replieslet's say I have the following string:
string s = "A B C D TESTTEST BLA BLA TEST TEST2"
Then I need the following:
"A B C D TESTTEST BLA BLA TEST TEST2"
So the rules are:a) replace every second space (between non space chars) with
b) If the last space is replaced with , try to move it backwards (if possible) one step so the next word is not touched by the force space.
Background:I want to use that to print data from the database to my website. But I want to optimize the forced spaces to use less space. I also want the last forced space not to touch the next word (if possible) so it is easier for some search engines to catch that word.
Will I need to loop through every char in that string and count the occurrence or is there an easier, faster and more fancy way?]So I did a benchmark to figure out which solution to accept:
@Guffa, your solution needs 22 seconds for 1 Million runs
@Timwi, your solution needs 7 seconds for 1 Million runs
I will give you both an upvote, but I will accept Timwi's solution.
i have a query like this and its running correctly
SELECT CAST(REPLACE(LTRIM(RTRIM(SUBSTRING(P.Telephone, 2, LEN(P.Telephone)))), ' ', '') AS BIGINT)
FROM P INNER JOIN PCommunication ON P.ID = PCommunication.ID
WHERE P.Telephone IS NOT NULL AND CAST(REPLACE(LTRIM(RTRIM(SUBSTRING(P.Telephone, 2, LEN(P.Telephone)))), ' ', '') AS BIGINT) > 5000000000
AND PCommunication.TypesID = '7667d187-5fe1-4aaf-9e31-79761561da58'
i am trying to use it with dynamic query like this but its not working
@query = 'SELECT CAST(REPLACE(LTRIM(RTRIM(SUBSTRING(P.Telephone, 2, LEN(P.Telephone)))), ''' ''', '''''') AS BIGINT)
I have been facing a problam with replace null datetime Field with String.
Like
My DB filed entrydate not mendetory DateTime is dataType.
Its return Entry date or Null.
When designing Crystal report Enrry date display but when it return null its simply display blankspace.
I want like
Enrry date
-----------
07-03-2011
Unavl
12-03-2011
13-03-2011
I have a query which is returning records like below which returns a list of tasks with a corresponding task type. there is a task table (wh_task) and a task type table (wh_task_type). What i want to achieve is a count of all the tickets per ticket type. So at the end of the query i will have a total for Administration / Maintenance tasks (1) and a total for Routine Maintenance Tasks (3). ** and all the other types *
There are many different types of task type so I dont want to have to hard code it. Can count all the occurencies of the different ticket types.
Task Name
Task Type
Date Completed
SBS Server C drive running out of space
Administration / Maintenance
16/07/2007 16:03:34
Patching Server(s).
Routine Maintenance
08/01/2009 06:51:56
Patching Server(s).
Routine Maintenance
11/02/2009 10:06:06
Patching Server(s).
Routine Maintenance
04/05/2009 06:53:24
I can also get wh_task_type_id.
Here is my SQL:
[Code]....
I have a dataset.table which has some null values. am trying to trasform this using xslt to display like excel. If the value is null, then that node is ommitted by the xml. i tried deafulting the null values from the database itself and thats not generic. Handling null values is troublesome. I tried couple of methods to default null values by looping and thats not optimal solution. I used LINQ to handle null values but couldnt comeup with a neat solution. what am looking for is a generic optimal solution to handle these values.
View 2 RepliesI have two columns in my Gridview marked false for the visible property but which are clearly listed in the DataKeyNames that are still getting set to null in my database table on update.
The first one is a column MId# which is a type int. It starts as 0 but on edit is turned into null. The Second is RequireSKU which is also converted to null.
My database is not allowing me to execute store procedure as perssion is denied by administrator. But I have to run a store procedure in my application, described below.
Can I replace this store procedure with "select query " on .net coding page i.e I want to make a function which will only select data from database and give the result same as this store procedure . store procedure-
CREATE procedure NEW_VIV
@user varchar(50),
@year char(50),
@month char(50)
[Code]....