How Do I Enter NULL In A Table Cell In The Enterprise Manager UI For Table Data Entry?
I have a column defined as smalldatetime. Default length (4), and "allow NULLS" is checked.In the Enterprise Manager UI, when i enter data into that table row, if i just tab past that column, all is well, and the value is represented in the UI as <NULL>.The problem comes once i ever enter a date into that column. Say i have entered a date (all is well), and now i want to remove that entry and go back to NULL (after the date value has been committed, different entry session, say).How is that done?It seems to me, once a date has ever been entered into that column, now, if i try to remove it, i get the error "The value you entered is not consistant with the data type or length of the column, or over grid buffer limit". I have tried deleting the value, entering spaces, entering the string NULL or the string <NULL>; maybe some other tries as well, but none works, i always get that error message and am not allowed to proceed past that cell until i restore a date value to it. I want to get back to <NULL>.Anybody know?Thank you.Tom
View Complete Forum Thread with Replies
Related Forum Messages:
Checking For Null Values In A Table/Matrix Cell
What would be an equivalent expression for ISNULL(datafield, 0) for a table/matrix cell? I am using iif( Len().. to find out if there is something in the cell, and displaying zero in the cell if the length of cell item is 0, however am wondering if there is any better/elegant way of doing that?
View Replies !
Export SQL Table Using SQL Enterprise Manager
How do I export an sql table from a server db using SQL Enterprise Manager? I have tried using Microsoft Web Data Administrator but it can't connect to the db. The db that is live has all the data, but I don't have a copy locally (I accidently deleted it)...which is why i need to export it to an sql file. Can someone please help me as I have exhausted my own knowledge. Cheers
View Replies !
Enterprise Manager Can Not See Table Tolumns
My Enterprise Manager seems to have lost its ability to see table tolumns. When I click Database|(db name here)|Objects|Tables|(table name here) it comes up showing the table as not having any columns. Also I cannot see any of the table indexes. The db is otherwise OK! How can I fix this? Thanks! Jim
View Replies !
Sql Enterprise Manager - Copy Table
Hi, I can't work out how to easily copy a table through sql enterprise manager including all data structure and the data ... I tried exporting one table then importing it into another but it wont transfer any of the actual data. I don't feel like retyping all 6000 records and I need somehow duplicate this table ... any ideas ??????? Cheers
View Replies !
Grid Pane In The Table In Enterprise Manager
HI When you right click open table to return all rows, click on the "Show/Hide Grid pane" icon . When you click on any row the first column called "Column" a dropdown shows all the filed names of that particular table. This feature used to work fine untill recently wherein when I click on the column, I don't get to see all the filed names but now it just shows TableName.* i.e. all columns. This is the case when I try to create a view in enterprise manager also. When you add a table to create a view, I cannot see all the filed names . I'm not sure what to do , to get the field names to appear? Is it some kind of setting in enterprise manager. All the info would be appreciated. Ta N
View Replies !
Cannot Open Table In SQL Server Enterprise Manager
I recently installed SQL 2000, runing on a Win2000 Server. If I try to use Enterprise Manager to open a table using the return rows command, I get the following error "An unpected error happened during this operation" Reinstalling the client Tools has not helped. Any help would be appreciated.
View Replies !
Cannot Open Table In SQL Server Enterprise Manager
When do right click on the table in SQL EM and select Open Table | Return all rows, get Error: An unexpected error happened during this operation. [Query]- Query Designer encountered a query error: unspecified error. It's happening on all tables, all databases, all protocols, all servers, on 2(!) of 3 installations of SQL EM. I can successfully run Select in Query Analyser against the same servers/dababases. Today is the first day it started. I cannot recall anything particular I've done on Friday that can cause this. Thanks
View Replies !
Rows In Table Not Showing Up In Enterprise Manager
I have just installed SQL Server 7 on a server. Everything was installed fine without any errors. The only problem occurs when I use Enterprise Manager, I right click on a table in the Northwinds database to open table and return all rows. The form pops up and no rows appear. Nothing in the table form works. I can view the records from Query Analyzer, and can also view them through Enterprise Manager when using a workstation client. This problem only occurs at the server. Any thoughts.
View Replies !
Enterprise Manager - Unable To Open A Table
After having installed my software at customer's I found out that it's impossible to open tables from Enteprise Manager (Query Designer error). I'm not sure it's because of my soft, but my clients are quite annoyed. I have had this situation on my own server , and the only thing I could do was to reinstall the server. Any other ideas? And what is the origin for this error? Thanks in advance, Asnate
View Replies !
Import Cell Data From XLS Into SQL Table
I'm trying to use DTS to import data from an XLS into a SQL table.It works fine in that it INSERT's the data. However, I need it toUPDATE the table, based upon a ProjectID. Can this be done?Can a DTS package be fired from a SP using parameters?Eg UPDATE tProjects SET MyField1=XLS.Sheet1.CellA1,MyField2=XLS.Sheet2.CellA1 WHERE ProjectID = @ProjectID.Also, it must handle dynamic XLS file names, eg 981-Budget.xls,513-Budget.xls, xyz-Budget.xlsIs this the best way to go? Other suggestions most welcome?Thanks everyone in advance!
View Replies !
Enterprise Manager Cannot Display Table Records Or Run Query
I have a new installation of SQL Server 2000 Dev Edition on a Win2K3 Standard Edition Server that I used for development. I just set this machine up in th last week and installed all Win2K3 patches and then installed SQL2K and SP3a. I have a single named instance. I just noticed today that I cannot view table data or use the Query part of EM. When I right click a table and select Open Table->Return All Rows it gives me an error dialog "An unexpected error happened during this operation". While the EM is diplaying this dialog the EM screen looks like Internet Explorer and says "Action Canceled - You might not have permission to view this directory or page using the credentials you supplied." I believe that this is a EM issue as I cannot view table content on other remote server. ANy ideas? Might this be an IE security patch disallowing some connectivity ?--Frank--Message posted via http://www.sqlmonster.com
View Replies !
Unspecified Error Opening Table(s) In Enterprise Manager
Greetings: We have a database with approximately 15-20 tables. Last week, using Enterprise Manager, we were able to open any of these tables and return all rows. Yesterday, when we tried to do this, we got the following message: An Unexpected Error happened during this operation. [Query] - Query Designer encountered a Query Error: Unspecified Error Can anyone tell me what might be causing this and how to fix it? Barring that, can anyone suggest some general steps I might take to possibly eliminate this problem without knowing the cause? Last, can you point me to a good resource for investigating problems of this kind, such as a knowledge base (other than Microsoft's TechNet)? Many, many thanks.
View Replies !
How To Format Cell / Data Apprearecnce Under A Table
Hello All, I uploaded custtable under the database, the data looks fine except that the name that apprears has a lot of distance e.g it should be : firstname lastname however the format appears very strange: firstname lastname firstname lastname fistname lastname Same is the case with the address, I need to adjust or format the apperance that appears on the cell. Is there a way/ sql statement to format the data under the table so that the apprearence looks okay. I will really appreciate any sort of help on this one. Thanks, Rashi
View Replies !
Is There A Way To Do Mass Formatting Of Cells In A Table Instead Of Cell By Cell?
Hi, I'm working with MRS and I've got a table with a lot of entries. For each value in the table I'm trying to get the text colour to be set to 'red' when the value of the cell is less than 0. Otherwise remain black. I can do this by setting the colour property cell by cell. But I have a lot of cells in the table. Is there a way to set the statement to apply to ALL cells in the table? Basically I'm asking if there is a way to set the property in bulk instead of going through tediously cell by cell. Any help would be much appreciated. Thanks!
View Replies !
Help: Table Name Displaying Twice In SQL Statement Inside SQL Server Enterprise Manager
For some reason whenever I look at the SQL statement of a particular table, the table name displays twice.For example,SELECT * FROM State StateEven when I execute this statement, it still returns the correct results. It does this for all tables in this particular database. I also check another database and thoses display the table names in the SQL statements correctly. Does anyone know why the table name would display twice in a table inside of a particular database?
View Replies !
How To Switch Off Automatic Blanking Of Table Views In Enterprise Manager ?
Hi Sqlserver experts,I use the SQL Server enterprise manager of MSSQL 2000 regularly.I'm often annoyed by the automatic blanking of the table views.If this happens then mostly with the hint :"The Results pane have been cleared to conserve server resources.To re-establish the result set, run query again."Is there any possibility to switch that blanking off ?Best regards,Daniel Wetzler
View Replies !
What Is The Keystroke In Enterprise Manager For Null
In MS Sql Server 2000 Enterprise Manager, how do I set the column value back to $null? I've tried Google searches and MSDN, just can't find it. However; I knew it and used it 3 years ago; alas poor memory and lack of use has deleted the trick. Maybe someone here knows it. Thank you very much, in advance.
View Replies !
How To Replace Squares Shows For Enter Key In A Sql Table Field
when insert a multiple line string value into a field it display with two squares when open table. insert into temptest (test,refdetails,cardno)values('test1','this is first line and second line and third line', '23243') this record shows in the database with squares for enter key. how to replace these squares with space? pat this is first line and [][]second line [][]and third line
View Replies !
How To Dynamically Enter Error Code And Description In A Pre-define Table?
Hi, I want to implement error handling my SSIS package. for this I am putting an execute SQL task for a container(which contains different interlinked tasks) in event handler. Say my first task fails in this container.Immedaitely my sql task which inserts the error code and description should exceute in the event handler and populate my error table in OLAP database. Any help will be great SSIS gurus. Thanks in advance. Regards, Aman
View Replies !
- Using Inner Join When The Field In My Data Table Has The Null Default Value:
I have a datatable : Data_Table and a look up table: Lk_table. Myfield that I use in Inner Join is defined in both the data and look table. So I build my query like this: SELECT * FROM dbo. Data_Table INNER JOIN dbo. Lk_table ON dbo.Data_Table.MyField = dbo.Lk_table.Myfield The pb, sometimes I have myfield still with its default null value in the datatable: Data_Table. So, I end up getting 0 record when I execute the query shown above. How do I turn that around so that even if myfield in Data_Table is Null, I still get the records from Data_Table. (I don t want a set of records including all possible values from the look up table: Lk_Table)
View Replies !
Overwriting Entry In Table
Task: To insert entries into a table. The table has a primary key based on a field 'ID'. When inserting into the destination table, I want to make sure that the new entry will overwrite the old entry. What's the quickest/cleaniest way to do this ? thanks, Clayton
View Replies !
Determining Last Entry ID In Table
Not sure if this is the right place to post this but hopefully someone can help me. I would like to determine what the last automatically incremented ID is in a table I need to return it as a variable to a VB.NET program but I'm not sure what the SELECT statement would look like for this. Any help would be greatly appreciated.
View Replies !
Table Entry Problem
While i execute the below query ,Entry is put in status_report table.But the same if i put in scheduling (Sql Agent) no entry is made in the table and the message success is shown in "Agent Job Activity". Purpose of the sp is to transfer data from One Server to Another Server. But if see in the Destination Tables No entry is made. CREATE procedure RBI_Control_sp as begin set nocount on begin try BEGIN TRANSACTION insert into fin_wh..Status_report ( [object_name], row, st_date ) select 'Data Tranfer', 'Inprogress--', getdate() --Data Transfer From the Live Server [RamcoFin02(scmdb)] to Dw-Server[Ramcovm392(fin_ods)] exec fin_ods..RBI_Data_Transfer_sp --temp table Table population,Fetching data from the fin_ods[erp Table] exec FIN_wh..RBI_SPExecution_sp Update fin_wh..Status_report set row= 'Success', [error_message] = 'No Error', end_date= getdate() where row= 'Inprogress--' COMMIT TRANSACTION end try begin catch ROLLBACK TRANSACTION Update fin_wh..Status_report set row= 'Failure', end_date= getdate(), [error_message]= cast(error_number() as varchar) + '***' + error_message() where row= 'Inprogress--' end catch set nocount off end Txs in advance
View Replies !
Data Flow Task - Have Null Values Take Table Default
Hi, I have a data transform from a flat-file to a SQL server database. Some of the flat-file fields have NULL values. The SQL table I'm importing into does not allow NULL values in any field, but each field has a Default value specified. I need to have it so that if a null value comes across in a field using the data transform, it takes the table default on import. I could of sworn I had this working a few days ago, but I get errors now that state I'm violating table constraints. Has anyone done this before? Thanks Jeff
View Replies !
How To Validate Flat File Data Against Not Null Columns Of A Table?
Hi all, I am facing a problem on validating the data from a flat file while inserting the data into the destination table of sql server 2005 database. In my package, i have to validate the input data whether the values are coming as null or not, before inserting into the destination database. The flat file may not contain data for all NOT NULL columns. I have to find out that row(s) and reject the record. If the rows are coming as Null for the Not Null columns, the OLEDB Destination throws OLEDB exception for the constraint. To resolve this, i have an script component in data flow, to check whether the input data is coming as null. I have added the output column of boolean type to the script component, it will be assigned to TRUE when there is null for the Not Null column in the script. And in the follwing conditional split, i am checking the flag for TRUE to reject the record. Is there any other way to handle this validation? Regards Madhav
View Replies !
EM Transfer Manager Fails Moving Data After 80th Table?
Hello: I am running on mssql 6.5, sp4. We have been trying to use EM transfer manager to move one test database on one server to another database on another server. We are dealing with 135 tables on this database. The transfer works up until about the 80th atble and then just dies but the scheduled task says it failed and check error log. The transfer creates the tables on the destination database but only loads the data until this one table. WE use all of the options in EM Transfer manager which are st as defaults. THere is no one on the source or destination databases locking this table. Other smaller databases were successfully transferred from one database on one server to the other database on the other server without any problems today and yesterday. Has any one run across something like this? THanks. David Spaisman
View Replies !
Table Cell Filter
Hi, I have a couple of data sets which i want to use in a top level report. Ideally i want to include these in the same table but i'm not sure if what i want to do is possible. The first problem i have is that one dataset comes from an analysis cube and the other from a transactional database. Using the cube DS i have set up the basis table with the following headings: SystemID CustomerID CustomerName Sessions In addition i'd like to have a column which shows the last SystemContactDate. This data would be taken from the second dataset using the transactional data. Is there any way i can add the date column with a filter which uses the SystemID field in the table to present the max date for that SystemID? The only way at present i can see to do this is to include a sub report in the table cell but i imagine that upon scaling up the report this will become very inefficient. Any suggestions people can make would be much appreciated. TIA, Grant
View Replies !
Multicolumn Cell In Table
Hi, I need to realize multicolumn cell in table for grouping fields, but i don't know how to do that. Help me please. 1col. 2 col. 3 col. long text grouping field first second third data data data Thank you.
View Replies !
Graph Bar In Table Cell
Hi, A few months back i saw a sample rds file where there was a kind of line graph in a table cell that indicated how much percent a sales person had to the complete sale figure. But i cannot find the link anymore. I would like to have such a linge graph next to all my agents that indicates a value againts a total value. Does anybody has any pointers where i could find that info ? Greetings Vinnie
View Replies !
Blanks In Table Cell
Hello, In my .NET.ASP application I generate a random five digit password, like so: string password = Membership.GeneratePassword(5, 1); The result could be a password like "0l$IE" and I the save this password to an SQL server. The problem is however that with the generated password five blanks are also added. Instead of "0l$IE" I get "0l$IE ". I hope you understand what I mean? Is there an easy way to correct this? I appreciate any help!
View Replies !
What's The Accepted Way To Retrieve Records In A SQL Table With Null Values Using A Visual Studio 2005 Table Adapter?
I'm using an ObjectDataSource in Visual Studio to retrieve records from a SQL Server 2005 database. I have a very simple dilemma. In a table I have fields FirstName, Surname, Address1, Address2, Address3 etc. None of these are mandatory fields. It is quite common for the user not to enter data in Address2, Address3, so the values are <null> in the SQL table. In Visual Studio 2005 I have an aspx form where users can pass search parameters to the ObjectDataSource and the results are returned according to the passed in parameters. The WHERE clause in my Table Adapter is:WHERE (Address1 LIKE @Address1 + '%') AND (Address2 LIKE @Address2 + '%') AND (Address3 LIKE @Address3 + '%') AND (FirstName LIKE @FirstName + '%') AND (Surname LIKE @Surname + '%') If, for example, I simply want to search WHERE FirstName LIKE ‘R’, this does not return any results if the value of Address3 is <null> My query is this: Could someone please show me the best way in Visual Studio 2005 to return records even if one of the Address fields is <null>. For reference, I have tried: Address3 LIKE @Address3 + '%' OR IS NULLThis does work, however itsimply returns every instance where Address3 is <null> (accounting for about 95% of the records in the database). Thanks in advance Simon
View Replies !
How To Prevent Doublicate Entry To A Table
hi, If I have a table which contains customer names. I want to have some kind of process to validate any new insert record into the customer table. so if the inserted new customer already exist in the table I will get a message that say " Sorry , this customer name is already in the system " .... how can I do that, I am using sql server 2000. thanks Ali
View Replies !
DTS Export To Excel Data Cell Inherits Formatting Attribute Of Cell On Top
When I do DTS export from SQL7 connection to an Excel file, the data cells in worksheet inherits cell formatting attributes from first row of worksheet which contains column headings. Is there any way to fix this? As a workaround,I tried to save the Excel template with cursor parked one additional cell below the header, and the result looks fine except one blank line in between.
View Replies !
Run A Query That I Have Stored In A Table Cell
This is embarasing.I'm creating a 500 line query from XML, CSV's, etc. and I can't fingure this out. I'm building a very complex "SELECT" query and then shoving it into the [Select] column in a SQL 2005 table. I want to call a stored procedure that just "executes" that query and returns the results....Any help would rock.
View Replies !
Update Just One Cell In Record Of Table
I really want to update just one cell without notify the others in record ,but i can not. example; my table like this. ID Increasingnumber LastModified 1 15 1/1/1900 i want to modify the "increasingnumber" cell only and also not let "LastModify" cell being updated. Can anyone help me solve this problem?
View Replies !
Multiple Values Per Table Cell?
I am converting a site from asp to .net and the previus writer did something I never saw.(I am somewhat new to programming all together). He put multiple values in a single cell of the database. I have always learned to use a seperate column for each value. Is this a classic asp thing and there are better ways now? Or is this something I should do myself? The columns type is text and the contents look like this:<Details Expertise="bla bla" Description="We are a three-divisional company ...," WebSite="www.blabla.com" AccountLevel="Free" AccountStatus="Active" WorkHomeZIP="22222" ContractStartDate="01/01/2003" ContractEndDate="12/31/2003"><Address Location="Work" State="Oh" ZIP="22222"/><Email Location="Work" Value=""/><Phone Location="Fax" Code="9801" Ext=""/></Details>
View Replies !
Embedding Reports Within The Table Cell !!!
Using SQL Server2000 Report Server or SQL server 2005 server, is it possible to embed a report within the cell of a Cross-Tab (Pivot Table).I dont want to provide a report link within the cell, rather the report itself carrying few data values . regards, MADNI
View Replies !
Multiple Images On Top Of Each Other In Table Cell
Hella all, Is it possible to stack two images on top of each other in a table ? Let me clarify where i'm going to. I have a report where in one table i would like to display (in a graphical way) how much a sales person has sold towards the whole sales amount. To do so i would like to set my background of my cell to yellow and then use an image (just a green rectangle) where i adjust the padding according to the percentage. When i set my background to yellow and i insert my image in the cell, the textbox cell properties disapear and are replaced with the image properties. So also my background that was defined in my textbox is gone. Now i was thinking if i could set two images on top of each other (a yellow rectangle and a green rectangle). But when i do that, one image is replaced with another. Am i doing something wrong or is there another way to achieve what i want to do? Greetz Vinnie
View Replies !
Useing Previous Cell Value In A Table
Is there a way to use value from a field in a table? For example: In the first cell i have the value of "=Field.myField.Value * 2" and in the second cell I want to use The previous value. some thing like: "=Field.SecondField + MY_PREVIOUS_FIELD_VALUE" of course I want it to happen in every row. Thanks.
View Replies !
Preventing Duplicate Entry For A Given Foreign Key In Db Table
Hi,i am using SQL server 2005 and have a table with 4 columns.Column1 is primary key,col2 is foreign key and col3 and col4 are regular data column.When the user enters the data i want to make sure that for a given foreign key(col2),entries in col3 are not duplicated.Is there a way,i can make sure this at db level,using some kind of constraints or something?Thanks a bunch..
View Replies !
Table With Duplicate Entry With Primary Keys
We have a SQL Server 6.5 table, with composite Primary Key, having the Duplicate Entry for the Key. I wonder how it got entered there? Now when we are trying to import this table to SQL2K, it's failing with Duplicate row error. Any Help?
View Replies !
Replace Characters On Condition In Table And Cell
need help condition 1 replace characters on condition in table and cells but only if how to do it - if i put * (asterisk) like in employee 111 in day1 - the the upper characters the (A S B) i replace characters with '-' and it must work dynamically condition 2 replace characters on condition in table and cells but only if if i put number or 1 , 2 , 3 , 4 above any cell for example( employee id=222 name =bbbb day1) i replace characters with '0' and '#' and it must work dynamically table before the replace id fname val day1 day11 day111 day2 day22 day222 day3 day33 day333 day4 day44 day444 day5 day55 day555 111 aaaa 2 A S B e t y R Y M j o p 111 aaaa 1 * * * * 222 bbbb 2 1 1 222 bbbb 1 A - - - B - 333 cccc 2 333 cccc 1 444 dddd 2 3 4 444 dddd 1 - - C C 555 EEE 2 A G C 555 EEE 1 * table after the replace id fname val day1 day11 day111 day2 day22 day222 day3 day33 day333 day4 day44 day444 day5 day55 day555 111 aaaa 2 - - - - - - - - - - - - 111 aaaa 1 null null null null 222 bbbb 2 0 0 222 bbbb 1 # - - - # - 333 cccc 2 333 cccc 1 444 dddd 2 0 0 444 dddd 1 - - # # 555 EEE 2 - - - 555 EEE 1 null tnx for the help
View Replies !
Table Cell, Image, Background Colour
Is there any way I can set the background colour for an image in a table cell (or even for a non-embedded image for that matter)? I always seem to get a white background. It is a GIF image file. Thanks
View Replies !
Using Enterprise Manager To Export Tables/data
Hi, I'm trying to use enterprise manager (v 8.0) to generate a sql script. I know I can select the tables I want to script and then select "Generate SQL Script". My problem is that I can't seem to figure out a way to get the INSERT statements for all the data in the tables into that same script. I can get the table CREATES, ALTERS, etc. Is there a way to include the INSERTs for data as well???
View Replies !
Ssrs Table Cell Background Gradient Color
Has anyone found a way to apply background gradient color to a table cell? I tried hard coding the xml file with the <BackgroundGradientEndColor>...</BackgroundGradientEndColor> and <BackgroundGradientType>...</BackgroundGradientType> in the style but it didn't pick up the change. This seems to be something microsoft over looked on SSR
View Replies !
READ EXCEL DATA CELL BY CELL FROM SP
HI,I HAVE AN EXCEL SHEET WITH SOME DATA, I WANT TO IMPORT THAT DATA (CELLBY CELL WITH MANIPULATION) INTO THE SQL SERVER TABLES BY USING STOREDPROCEDURE(IF POSSIBLE).IF ANYBODY HAVE DONE SIMILER TYPE OF JOB OR KNOWING ABOUT IT, PLS. LETME KNOW.THANKS IN ADV.T.S.NEGI
View Replies !
|
TRACKER
