3,481 Topics
 | |
| | This thing is really getting me in trouble. If any have any idea please share [B]Msg 7399, Level 16, State 1, Line 1 The OLE DB provider "MSDASQL" for linked server "extra" reported an error. The provider reported an unexpected catastrophic failure. Msg 7343, Level 16, State 2, Line 1 … |
| | Hi all, There is a (I assume) simple query i cannot figure out (in a best practice way). Let's say I have three tables: [LIST] Users[/LIST] [LIST] AOI (Areas of Interest) [/LIST] [List]Users_AOI (Simply containing userId and AOIId for all interests for each user)[/List] So far so good. Now I …  |
 | I've been a member since February and this is the first thread I have created -- now I finally get to see where that solve button is! Anyway on a more serious -- who maintains the code templates for daniweb's programming forums? I post a lot in the C# and … |
| | hi, there, i am doing a and it needs login page. I have a 2 textboxes, one for user id and the other for password. Using this two textboxes, I need to identify the three roles that i am using. This includes manager, delivery boy and customer to redirect to … |
| | hi all, i have a simple problem with the reporting services. i have configured the reporting server and it is working fine when i browse the reports through the report server. i have another application in which i have made use of a report server. when i try to browse … |
| | Hi, All I encounter this problem when I am trying to insert some data manually for my project. Example: LA-R1, LA-R2 , LA-R5 , LA-R8 ….. [The Rs are Already in the Original Data] Simply put, my Goal is to fill in the gaps between the Rs. So, the result … |
| | The issue isn't how to use sp_send_dbmail, because i use it everywhere, for both querys and system mails. But i have one problem, and that is how do you send a mail with HTML and TEXT format? You probably wonder why i need this because all the mail readers now … |
| | I am trying to create Update trigger which should be invoked only if the ReturnedOn column is clicked. I have used the following code-snippet but it generates the error: CODING: [code] create TRIGGER trg_ForUpdateOnBookIssuedDetails on BOOKISSUEDDETAILS For update as begin declare @Rows1 int,@Rows2 int if(update(ReturnedOn) begin IF EXISTS(SELECT 1 FROM …  |
| | Hi all, I am creating a windows application. I have a column in the backend - MS sql server 2005 as ID which stores Patient Id. The values for this column should start with PT and contain the serial numbers in ascending order. Eg. PT001 PT002 PT003 I want to … |
| | Ok fellows. I've tried EVERYTHING!! System OS: Windows Vista SP2 IIS: version 7 MSSQL: 2008 express ASPX: .NET 3.5 framework my global.asax has sqlcachedependency.start and stop at application start and end i have enabled sqlnotifications on the database. The database has a table for tracking the changes and the track … |
| | (And before anyone points it out; I know they're not calling it DTS any more!) My problem is as follows: Whenever I go to import a flat file using the DTS import it's setting the default column sizes to be ludicrously small (50 characters) and it doesn't subsequently matter HOW …  |
| | Hey All, I am using MSSQL -2005 with VB6. I have created a master table tblCompany and detail Table tblDetail having foreign key relationship. When i try to insert a value within a TRANSACTION I am getting Error No. -2147217873 at Line No. 0 (The INSERT statement conflicted with the … |
| | Error message ”[Microsoft][ODBC SQL Server Driver][SQL Server]String or binary data would be truncated.” comes when you insert/update a larger value than the column is specified for. But is there a way to detect what column, or what value that is to large? I’m thinking about splitting up the INSERT string, … |
| | I have a table name Project(id,projectid,date) ----------------------------------------------------------- id | projectid | date 1 | 9 | 2009-02-03 2 | 9 | 2009-03-04 3 | 9 | 2009-04-05 i need a query which will return me the recent date of that project id. query will return: 3 | 9| 2009-04-05 |
| | Hello, i have face problem when i need to retrieve data from database (SQL 2000). Below my table : Column A | Column B 1 a 1 b 2 c 2 d i need the result is : Column A | Column B 1 a b 2 c d Can … |
| | Hy, you guys! I'm trying to implement in a trigger write by-me error handling with TRY...CATCH, but I'm loosing a lot of time without success. :'( Here there's a simple code write for test: [CODE]ALTER TRIGGER [dbo].[INS_AlarmsEvents] ON [dbo].[TEST] AFTER INSERT, UPDATE AS BEGIN TRY RAISERROR (N'This is message %s … |
| | I'd like to make a querry prom 2 tables that have the same information. Tables have only one column named "fish". I'd like to create a querry that will show me every combination from first table with the second table (in 2 separate columns). For example: My table contains: A,B,C. … |
| | Within the past week or so a few programs have been crashing at various points. For example, Steam was crashing on startup but has fixed itself somehow. MSN Messenger crashes with the "Send Error Report" thing after about 5 seconds whenever I sign in. Firefox and IE both crash with …  |
| | HI, I have in my database 50+ tables and getting slowly lost because it's looks like a bit messy up because of the long list in the Object Explorer (SQL Server Management Studio). Does anybody know a way how to organize this tables in subfolders like how the "system tables" … |
| | Hi all, I have created the Trigger for UPDATING to be invoked when Returnedon column is updated using the following code snnipet. [Code] CREATE TRIGGER trg_ForUpdateOnBookIssuedDetails on BOOKISSUEDDETAILS For update as begin declare @Rows1 int,@Rows2 int if(update(ReturnedOn)) begin begin tran update nur set nur.NumberOfBooksIssued = nur.NumberOfBooksIssued -1 from NewUserRegister nur … |
| | Hi all, I am creating a trigger which should be triggered on insert to BOOKISSUEDETAILS table. I want to alter the table LIBRARYBOOKDETAILS table only if the Inventory column value is greater than 1. Initially I have created the trigger in the following way. But now I want to alter … |
| | Hi evrybody, My sql SP takes around two to three minutes which is quite long time to execute the SP select data from three tables publicity(29000 row) publicitysubject(29000 row) & lookuptable(50 rows) all three tables have clustered index How can i reduce the time [code] USE [ReadWorthyPublication] GO /****** Object: … |
| | Hi, I have a dataset build at design time (vs 2008) with several tables of my DB (MSSQL 2005). I have a DataTable with its tableadapter... I need that the TableAdapter.Update function returns the key updated (always will be a single row updated at the time). I know, I passed … |
| | I have written a complex stored procedure which have a log table which keeps the track of success/failure of each and every query in the stored procedure. If there is any error in any of the query entire transaction is rollback . while rollingback, data in log table is also … |
| | Hi All, I have data like the following: Stuff Sizes ID pen s1 100001 pen s2 100002 pen s3 100003 pencil s1 100001 pencil s3 100004 pencil s5 100007 pencil s2 100006 ruler s7 100005 ruler s8 100008 .. .. where each size is coordinate with a unique ID number; … |
| | Ok; I have a table with a list of products, for example ProductID Name Price 1 Red 2 2 Blue 1 3 Green 3 4 Orange 3 5 White 4 6 Blue 5 I want to give people the option of "featuring" products, and also to be able to control … |
| | Hi all, I am trying to update Table[land] with the following data (simplified): [u]Scenarios:[/u] Num_1 like [A-Z], Num_1_Index like [1-9] Num_2 like [A-Z], Num_2_Index like [1-9] ..... Num_26 = [A-Z], Num_26_Index = [1-9] --------------------------------------------- Update land set Num_1_Index = case when Num_1 like 'A' then '1' when Num_1 like 'B' … |
| | Hi. I have strange problem with sql query results. I am joining two tables and displaing result with order by clause. But results on MS SQL and Sybase are different. After removing order by clause in both queries results are equal. I am using the same table so I do … |
| | Hi everyone, I am working on a project where i have encounter such problems: Data samples: LA-1-2, LA-1-2-33, LA-1-22-333-4444, LA-2-3, LA-12-34, LA-123-45-67 .. with upto 8 dashes Objective: I need to find the values behind each dashes into multiple columns in orders. [e.g LA-1-2-33 will have columnA = 1,columnB = …  |
| | everytime i log onto windows live messenger it logs me on fine, but as soon as someone opens a window and starts a conversation or i start a conversation everything freezes and a error message comes up saying 'send error message' here's my HJT log.... Logfile of Trend Micro HijackThis …  |
| | Hi everybody I have coded a LINQ SiteMapProvider for my ASP.NET site. The site pages info is stored in a MSSQL database. When I make changes to the SitePAges table, the SiteMap does not reset. Here is my code[CODE]Public Overrides Function BuildSiteMap() As System.Web.SiteMapNode If RootMapNode IsNot Nothing Then Return … |
| | Help! I am trying to get my computer clean, as I think I have a hijacked browser. I am not sure how or why, nor how dangerour this is. I have tried to run spybot, and uniblue registrybooster, but can't get them to complete the job. now when I boot … |
| | Hi, If I have a stored procedure that creates a table of 4 rows (recommended products for a given product). What's the best way to create a cached table of these 4 recommended products for EVERY product in a products table. (Cached table being 4 times bigger than product table) … |
| | I created a job site using my web masters, now I wanted to use the same script for my other job domains. I tried copying all my php web pages in to the server, and also changed the database configuration to match the new server password, I created tables in … |
| | I am REALLY new to SQL. Teaching myself C#; downloaded SQL Express 2008. (Not sure of the terminology either...) Successfully created several tables for my desktop customer database. I am not able to populate the database yet... Do I have to create my own application to add data to the … |
| | Dear All, I have developed C# application to import data from CSV to SQL Server using sqlBulkCopy. However I am facing couple of problems listed below 1. whole transfer fails when one record has column width issue (source column width is 30 and destination is 20) so how could I … |
| | hello everyone..I would be grateful if anybody could help me in performing subtraction from diffrent tables... My Database has a Asset table which has opening balance and balance left coloums in it.and i have one store table which has received/issued item and its quantity.Wat i want to do is if … |
| | Hi, I have hosted a website that has MSSQL Server 2005 database on different machine. I am using the following connection string [code]<add name="ConnectionString" connectionString="Server=mssql2005.ableos.com.au;Database=visualinventory_ableos_com_au;Uid=myuserid;Pwd=mypassword;Integrated Security=True;User Instance=True" providerName="System.Data.SqlClient" />[/code] I am getting the following error. [B]A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server … |
| | I'm relatively new to MSSQL, and I'm trying to improve the DB write performance. I have some legacy Java code that's generating about 1500 records every second. These 1400 records are generated by multiple Java threads. Right now, my approach is to create an SQL statement in each thread, to …  |
| | hey, first off I'd like to state that I am pretty new to ms sql and stored procedures tho I have worked with sql for quite some time. My employer would like me to write a script which takes html content from a mssql db (originally delivered dynamically) and create … |
| | Hi, As a requirement of one of my assignments, we have to upload images, videos and audio files in a column called fileContents. Earlier I had set the data type for the column as 'Image'. But my professor says that I wont be able to upload Audio or video to … |
| | I am more interested to know a site that got sample web access code -- to access SQL server / oracle database == could include any of the following language --- c# , vb.net, jsp --- asp, javascript -- ajax answer could be in form of the coolest CMS on …  |
| | |
| | can anyone tell me about sql transcation with example..what are the types are there ?  |
| | Hey all, I'm trying to insert a bunch of rows from an xml document into an SQL database. I have a stored procedure that I'm calling from my program after I generate the XML string and pass it into the SP. It runs with no (visible) errors, but when I … |
| | hi, how to get database records from mssql into excel sheet using vb.net. if i click on button and open the excel sheet enter the data and the data is stored in database in the form of records... |
 | Good day All I have a Challenge. I have the Following StoredProcedure that is doing the Following [code] IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[temp]')) drop table [temp] --Creation of Temp1 SELECT MTN.ID,S.DESCR,ISNULL(MTN.CYCLETEMPLATE,C.CYCLES) AS CYCLETEMPLATE into temp FROM TBL_STAFF S INNER JOIN MTM_ACTV_STAFF MTN ON S.ID = … |
| | |
| | Hai, Am Using SQL SERVER - 2000 Table Structure CARDEVENTDATE CARDEVENTTIME CARDNO 20090224 92007 485 20090224 92345 321 20090225 163932 168 20090225 164630 471 20090225 165027 488 20090225 165137 247 20090225 165147 519 20090225 165715 518 20090225 165749 331 20090303 162059 240 20090303 162723 518 20090303 155029 386 20090303 155707 … |
| | Hi all, I need a help regarding with the extraction of a single value from the specific field that contains the datatype [B]nvarchar(MAX).[/B] |
The End.