3,481 Topics
 | |
| | Hello I have a VB.NET application that needs to backup a database then restore to a new database in the same Server as I am upgrading an application and I want to retain the existing database. I create a blank database using the following: [code]cmdSA.CommandText = "CREATE DATABASE [newDatabase]" cmdSA.ExecuteNonQuery()[/code] … |
| | Hi. I tried dragged and dropped an SqlDataSource and then click "Configure Data Source". From there i start a new connection and select my server. Under "Select and enter a database name" listbox i can not see anything. So i try to attach a database file "NORTHWND.MDF". When i try … |
 | hi i want to create a trigger for update in mssql. in my trigger i want to know which row was updated how can i achieve this info ? |
| | I have a table in MS SQL DB, the data was recorded with redundancy, is there an easy way to remove all but keep only one, for example: [ICODE]id name age dept --------------------------- 1 alan 20 A 2 william 23 B 2 william 23 B 3 mike 30 C 3 … |
| | Hi all, I was thinking of using Triggers to take care of my history tables. Two questions remain: 1) Transaction Scope I handle complex Operations in my DataAccessLayer (C#,ASP.NET) with Transaction Scopes. For example: [code]private void InsertFamily(FamilyDTO) { using (TransactionScope scope = new TransactionScope()) { try { InsertFather(); InsertMother(); InsertBrother(); …  |
| | Hi I want to know how to write storedprocedure when search creiteria is Present. Here the query to give the list of "select ID, Salesmennummer , Salesname Commision, Areacode from sales_master Areacode Salesmennummer Salesname Commision 1 1000 Rams 200 2 2000 Johny 1000 I Want to search above list by … |
| | Hi All i have problem in insert statement in which one string returning me value as g's and because of that s is gets separated. and its giving me eroor as Incorrect syntax at s. [code]strSQL = "Insert into HeaderInfo(yAxisLabel , xAxisLabel , zAxisLabel , yAxisUnit , xAxisUnit , zAxisUnit)" … |
| | Hi guys, I need some help please. I am new to SSIS. I created a SSIS in BI and when I run it it works fine (All it does is to run a select statement to get data and save it into a flatfile. The server I'm accessing is on … |
| | hi i have a table which contains a datetime type column. i want to create a stored procedure that gets a surtain month and year as parameters and returns all the rows with the date column in the month and year range i sent as parameter. for example if i … |
| | hi i'm trying to edit gridview rows. the grid columns are template cplumns. i added the commandfield buttons for update. i wrote a rowupdating event: [CODE=asp]MonthTable.Rows[e.RowIndex]["FirstEnter"] = ((TextBox)(MonthGridView.Rows[e.RowIndex].Cells[6].Controls[0])).Text;[/CODE] on runtime i get this error: Unable to cast object of type 'System.Web.UI.LiteralControl' to type 'System.Web.UI.WebControls.TextBox'. what have i done wrong ? |
| | Hi, How to connect to remote server with storedProcesdure sp_addlinkedserver where the server has an instance SQL2005. suppose the servername as 'SrvName\SQL2005'. Also please provide the procedure how to delete a remote server from sysservers table. Thanks, Ukbasak |
| | I just finished a job interview/exam and I failed. I really don’t know how to implement this problem using an MS SQL. You could check the exact question/problem below: [I] There are two tables, NAMES (ID INT IDENTITY (1,1), NAME VARCHAR(255) ) and RELATIONSHIPS (NAMEID INT, PARENT_NAMEID INT) linked via … |
| | I recently inherited my father's old laptop (vaio, about three years old), and all has been going well so far... up until a few hours ago. I decided today to do a defrag since I figured it could need one. I downloaded AUSlogic defrag and performed a full defrag, which …  |
| | So, I've got a bit of a conundrum that I cannot for the life of me figure out. Here's what I need to do : In column PO_I, look for column ITEM with lowest # in column Seq_I. If column Ship_Q < Qty_Ordered, look for Ship_Qty within ITEM with next … |
| | I am currently using MS SQL 2000 server as backend database for web site (written in php), now plan to switch DB to MS SQL 2008 Express, I have questions about this conversion: 1) Will MSSQL2008 support all sql statement that was written in MSSQL 2000? 2) I know SQL2008 … |
| | Hi I have made a website where it is possible to see the days program on one page, it updates itself so it is only for that day. But now I wan't to be able to insert a picture that changes position according to what time it is. For example … |
 | I am a newbie to this forum. I have been experiencing a problem with explorer.exe at login. I have read through the other threads about a similar problem occurring in the Fall of 2007. What I am experiencing is similar to those threads, but the sloutions provided in those threads …  |
| | within the lsat week or two the compute rhas been slowing down everywhere and everything is loading a lot slower wether its in the computers own folders or the internet here the log =========== Logfile of Trend Micro HijackThis v2.0.2 Scan saved at 3:03:55 PM, on 2/4/2009 Platform: Windows XP … |
| | Example Database id master_id ref_id 1 p1 c1 2 p2 c1 3 c1 c3 4 c3 c1 5 p3 c4 6 p3 c5 Starting with "p1" I wish to return the recursive list of master_id:ref_id Here's the problem: p1:c1 c1:c3 c3:c1 (circular reference) c1:c3 ..... ..... etc How do I … |
| | hi i have an existing table . i'm working with sql management studio. how can i change columns properties ? set column as idenity true. set column as indexable. |
| | We are working on a project & finding an issue while accessing the data from SQL Server. Problem: Display of record in search console of application on number of times it has been processed. Consider we have a record which needs to be displayed 5 times a day in search … |
| | Hi, I have created DB applications using MS-SQL and VB. But, I am new for distributed database program development. Will you please help to design one? |
| | Hi all, I have a very simple query but this is driving me nuts. I have installed sql server 2008 on my system. Its working fine, but the main thing is that i am not able to configure the report server. Can anyone help me how to configure the report … |
| | Hi, Check the following description of my requirement. (This is in MS SQL 2005.) 1. Select a table in your DB. 2. Alt+F1 lists the structure and the details of the table. 3. In that, i could see a. Table Name and Owner b. Columns , data type , size … |
| | Hi, lets say I have the following 7 records in my database ID Model -- ------ 1 400 2 400FL 3 400 FL 4 ABC 5 SGH500 6 SGH-500 7 SGH 500 How is it possible if i could select out the rows which are of possible match to some … |
| | I could not find pubs database after installing mssql 2000. I dont know wat to do.. Help me |
| | Hello! I've beat my head crazy trying to figure out what the heck is wrong with this query. It is not my query, but one from a packaged software I need to customize. I've created a link to the sql db's in an access db (linked to all sql tables) … |
| | Help Please! I am trying to create a maintenance plan in sql 2005 server. I am getting an error Microsoft.SqlServer.Management.DatabaseMaintenance.TaskUIUtils..ctor()'. (Microsoft.SqlServer.MaintenancePlanTasksUI) I am unable to create maintenance plan. I am on sp2, and applied a critical hotfix from the microsoft website. I thought maybe it was client tools, but isn't … |
| | |
| | I have created two table valued multi-statement functions using SQL Server 2000 and am now trying to develop a VB.NET front end application where I run the functions and pass string parameters to them. Below is a code fragment for one of the functions. [code="SQL"] CREATE FUNCTION ViewCustomers(@Region varchar(6)) returns … |
| | Hello, What SQL query should I use, in order to copy records from one table to another, both of the same schemas, in such way that only records that don’t already exist in the destination table will be copied? For example: Table A – Destination table ****** Col1 Col2 Col3 … |
| | We have a Log table which logs the events of a request. When any error event occurs, I need a query to see the row with errorevent and the previous row to this row which contains the actual data which caused the error. Here is the table structure: LOGID (int), … |
| | Require help I had 2 question 1) What is the script when I select Option 1 click command button will go to form 2 and select option 2 click button command will go to Form 2? 2) What is the script connection within vb6 to mssql? |
| | In SQL Server Profiler you see that a transaction starts and one line below it fails but I have no clue why the transaction fails. The transaction was initiated by a C# program using a table adapter and LINQ. In Visual Studio you see that the transcation fails but not … |
 | Hello all, Are UDFs written only on SQL Analyser in within the SQL? Can we use them in programming code?How to use them in the code? What are the actual benefits of UDFs? We can write the method in the code and connect to the database and execute which yeilds … |
| | I have a program that uses a Stored Procedure to create a report. Unfortunatly the SP has a problem in the VB6 code. The program could pull the information perfectly until 2 days ago. Now the program times out after 60 seconds after sending the params to the sp. I … |
| | Hi All, I've a table name Countries with two fields as ID, and CountryName. Where ID is foreign key(ie., may have duplications) and the country name can be repeated as many times as it needed. for example the scenario is ID CountryName 1 India 1 US 1 UK 1 Japan … |
| | Hey all, I need help from all you genuises out here. I have 3 tables [CODE]CREATE TABLE IF NOT EXISTS `tags` ( `id` int(11) NOT NULL AUTO_INCREMENT, `tag_name` varchar(255) NOT NULL DEFAULT '', PRIMARY KEY (`tag_id`) ) CREATE TABLE IF NOT EXISTS `video_posts` ( `id` int(11) NOT NULL AUTO_INCREMENT, `title` … |
| | Urgent help Please! I have a table exist in two database on two different server. I want to get the data of table from one table and another. When I am using OPENROWSET command it through error. I don't know what it mean. Is there any way to migrate the … |
| | trying to extract fulladdress to individual column such as address1 address2 City State Zip, and each of the fulladdress has a [B][U]comma[/U] [/B] so that why I am trying to create a function that count the comma and put the fulladdress ito individual column. hear is the script that I … |
| | Hello, I hope my question falls in the right forum. I have a content web 2.0 website with ms sql database. As most content websites, every file has Title, description and tags added by uploaders. I would like to know if there is any standard algorithm for SQL search based … |
| | Hi, I don't know why the server I recently get to manage, has the SQL Server 2005 installed but with the Management Studio Express!... I need to upgrade it with the Dev version, but when I put the DVD of the SQL Server installer, It won't show my actual installation … |
| | Hi, I have 2 instances of SQL Server running on one machine (One 2K -default- and one 2K5), I have no problem connecting from a PC on LAN to the 2K5 instance, but when I try to connect to the 2K instance, it fails (it gives me an error: "Named … |
| | I have a SP (sp_test_procedure) created from a SQL Server Project in my SQL Server 2005 database, inside this SP I have a call to another SP which inside calls to a SP in another Database Server (SQL 2000) through a cross-linked connection. When I execute it from the Management … |
| | Hi all, I have a Stored Procedure without an output parameter but it returns one row always, this SP is called by another SP, so I need to store some of those columns in a variables of the first SP. How can I do that? Please help. P.D.: I have … |
| | Hi everybody, I've got a big pb, and I need help..... I have to use MS SQL Server 2005 SP2 Enterprise Edition instead of MSSQL Server 2000 Enterprise Edution and I don't know how to use the old SQL 2000 db. Any sugestions? Thanks for your time. Eddysonys |
| | Hello! I'd like to ask for some help. I'm using Visual Web Developer to create a web site, in which members can log in. It has the default aspnetdb.mdf database, in the app_data folder to store the member's data. This works quite good offline. My only problem is that I'd … |
| | Hi everyone, my name is toritereju Ejegi, you can call me toju. I presently work as an IT manager at my company being in charge of IT procument, content management of for the company,s website, LAN administration and application software administration. i have done a little programming with java , … |
| | --query of a very large table SELECT abc AS 'productname', xyz AS 'quantity' INTO #tmptable FROM dfg WHERE blah -- --content of #tmptable: --productname quantity --product1 5 --product2 3 --product1 2 --product2 8 --product1 5 -- how does a query on #tmptable look like, if I want to receive the … |
| | I'm using SQL Server 2008, the SQL Server Management Studio. I'm trying to import from a flat text file into my mssql database, but it inevitably fails, resulting in the error: The column "Column 2" cannot be processed because more than one code page (65001 and 1252) are specified for … |
The End.