back soft

Vote count: 0 I have two table with a PK ID but one table has a padding 13 digits. Table1 PK 1234567890000 Table2 PK 123456789 What's the best approach when joining? I have the below join but get an error The conversion of the varchar value '7324004373918' overflowed an int column. LEFT JOIN Summary C ON RIGHT('0000000000000',B.Id) = RIGHT('0000000000000',C.id ) asked 24 secs agoToby Let's block ads! بخوانید...

Vote count: 0 I have 2 tables 1 [dbo].[t_Olympic_Country] where i have all the county list but population and GDP is empty. Now i have second table which has most of the countries with population and GDP data but its it has not same number of data. I would like to enter value of GDP and population from 2nd temp table [dbo].[temptable1] to first [dbo].[t_Olympic_Country] in case the cuntry name matches with [dbo].[t_Olympic_Country]. I mean a conditional bulk update for [dbo].[t_Olympic_Country]. Can anybody help me? i tried following which gives error : INSERT INTO [dbo].[t_Olympic_Country]( [GDP] ) SELECT temp.[GDP] FROM [dbo].[temptable1] temp WHERE (temp.[Country_Name] IN (SELECT tl.[Coun...

Vote count: 0 I have three joined tables 'Student' , ‘StudentTransportOrder’ and 'Transport' in SQL server I have made a ‘StudentActivity’ view for this the 'Student' table each student record has a TransportOrderID however the table I have joined to has a 'VehicleID' this is recorded into the ‘StudentTransportOrder’ table if transport is used, even though the vehicle type may be different e.g. Train or Car Unfortunately the same transport id has been entered for the same date and time for a student records. The StudentActivity view already brings records based on where conditions, but I also need to remove the duplicate records, preferably keep the records where if a student has used transp...

Vote count: 0 I have MsSQL database which is created in MSSQL 2012 SQL server.On my local machine I have installed MSSQL 2008 SQL server.Will the 2012 database work in MSSQL 2008? asked 23 secs agovishal shah This entry passed through the Full-Text RSS service - if this is your content and you're reading it on someone else's site, please read the FAQ at fivefilters.org/content-only/faq.php#publishers.Recommended article from FiveFilters.org: Most Labour MPs in the UK Are Revolting....

Vote count: 0 I have an Excel workbook that will query a SQL Server 2012 database using VBA. Many users will temporarily use this workbook so I created a generic ID with SQL Server credentials only. Some of the users can execute the VBA and retrieve data without a problem. When other users try, the VBA ignores the provided coection string using the generic user and password and provides their windows credentials. Why are they sending their windows credentials instead of the credentials provided in the coection string? How do I force the coection to use the provided Uid and Pwd? The error message isCoection Failed:SQL State '28000'SQL Server Error 18456...Login failed for user 'DomainUserid' ...

Vote count: 0 So here's a scene, i have converted excel file into pdf. uploaded in my website. Now i want to store the DATA of pdf file into database. I need to read the data and store the data into database. Say, in my excel file, i have a column named Student Name, converted this file into pdf. So this header will stored as a Column in Database.. looked foe this problem on google. FileStream will do somewhat but not the all. P.S. I need to store pdf's Data. not pdf file. Database : Sql Server 2012 asked 44 secs agoDinav Ahire Let's block ads! بخوانید...

Vote count: 0 We have a native C++ COM application for controlling our production lines. The application is using ADO to access a MS SQL server. Server part of application is ruing on Windows Server 2003 and Clients XP. Recently we switched from SQL SERVER 2005 to SQL SERVER 2012 (but database remaining in 2005 compatibility modus). The migration was quite smooth (just 1/2 downtime). Old server and clients are in same domain, new server is in a different domain (of course trusted). Authentication is done by SQL Server authentication. However now i got complaints about a sporadic performance degration on a specific action on a packaging client station. By putting some debug output into the co...

Vote count: 0 Can anyone tell me the special features of a read only database compared to the database which we use. Is there are any advantages or disadvantages for read-only database.? asked 2 mins agoleeg4625 This entry passed through the Full-Text RSS service - if this is your content and you're reading it on someone else's site, please read the FAQ at fivefilters.org/content-only/faq.php#publishers....

Vote count: 0 i want to export data and schema from live Database to my local database, i tried "export data" option while right clicking on live db but it only exports data but not constraints on columns. kindly help me out? asked 1 min agoNoman Ahmad This entry passed through the Full-Text RSS service - if this is your content and you're reading it on someone else's site, please read the FAQ at fivefilters.org/content-only/faq.php#publishers....