2,935 Topics
 | |
| | how can I select one or more columns from a table by column-index and NOT by columnname? I got the columnIndices of table by using this query SELECT name, colid FROM sys.syscolumns WHERE (id = (SELECT id FROM sys.sysobjects WHERE (name = 'table_name'))) |
| | Hi there, I am creating reports in SQL server business intelligent studio and when I deploy it to the report server the report is shown in only on a half a page. How can I make the report height and the width for the report thanksssss |
| | Hi all, DANIWEB saved me a few months ago, and I'm hoping the community can save me again :) I've found myself in the position of needing to extract a very small portion of data from a vast SQL database. I've got the specific table in question, and have isolated … |
| | Need to insert byte array value in to a column using bcp bulk copy. Any way? |
| | Hi, I have to insert fields in a table. I am using VB.net & SQL Server database. The code is: Dim userid As Int32 = Me.classname.UserID Dim strSQLD As String = "Insert into table1 (userid) values (Me.classname.UserID)" userid is of type int While debugging, i can see that variable userid … |
| | Hi, I am working on a server which appears to have both MSSQL 2005 and 2008 installed. When I start the management studio, version 2008 opens. I am unable to debug triggers because I am told by the management studio that this feature is not available with MSSQL 2005. What … |
| | Hi I am trying to write a function in which I customize my select statement. But it is not working as i desire... It is as [CODE] declare @column_name nvarchar(10) set @column_name = 'original' select @column_name from data [/CODE] Here original is the name of one of the columns. I … |
| | Hi I would like to save one table's data to another table. The code that I have wrote is this: [code] con.Open(); string copyData = "INSERT INTO Changes(IP,ServerName,[Type of Server])SELECT IP,Server,Name FROM Server"; cmd = new SqlCommand(copyData, con); int returnValue = cmd.ExecuteNonQuery(); con.Close(); [/code] and it seemed working but when … |
| | Please Make For Us All Codes As File Text "*.txt" To Downloads or As Projects To Downloads Thank You For All Codes tarek-aec *** Thank You *** |
| | I am not able to establish remote connections to SQL Server 2008 enterprise edition. I have followed and implemented a lot of tutorials available. These are the things i have done: 1. enabled TCP/IP connections in SQL configuration manager. 2. added a rule to allow inbound connections at port 1433. … |
| | Hi, Im a sql novice and need some advise from all you gurus. My current environment has me running an application that uses Sql Express 2008. We have just moved into our second office and need this application to run in both offices (preferably off the same database). Old Office … |
| | Hello all Please help me as soon as possible i have one file named patients.ibd file of mysql and allready have table named patients in my schema Please hepl me how to upload data from patients.ibd to patients table please help ASAP thank you in advance  |
| | Dear all , i want to transfer the sqlserver2008 database to sap business one database/? It is possible? |
| | i m working on certain project ,i created some tables in database sql server 2005 .and it created smoothly. for examples users table .so it append it with dbo.users .till there there was no problem i can easily access its object (table,storeed procedure) .but after few days it appended table … |
| | Hi, I have two tables where both contain the ID number and Date. The first table will always have a date and the second table will never have a date. Basically I want the query to bring back a result set that if the ID is in table 1, then … |
| | I am trying to implement merge replication locally before using it for web synchronization. My question is "Is it necessary to have two separate instances to try merge replication?" I have been through many web pages and tutorials but couldnt find a definitive answer. and if it required then is … |
 | Hi geeks, I really need your help. I want to query in a table in MS SQL using a data in another table. This might give you an idea on what I am talking about. This is the query I've constructed : "SELECT TABLE1.FIELD1,TABLE1.FIELD2 FROM TABLE1, TABLE2 WHERE TABLE1.FIELD3 = … |
| | I have a table with one record per certification a user has. So, user SMITH can have multiple records, one for DMV another for CPT and another for ICD. SMITH has three certificates but can have up to 20. The desire is to have a second table with one record … |
 | Can anyone shed any light on my errors? I got these after transferring some data around what might cause these errors? [CODE]HDB:{call sp_logitemexchange_insert(179,24,0,0,255,6,37742,1,2,1,2,0,8,0,0,0,0,0,0,0,65535,65535,0,?)} DB:01000, NativeError:3621, [Microsoft][SQL Server Native Client 10.0][SQL Server]The statement has been terminated. DB:{call log_serverstate(2,150,0,0)} DB:01000, NativeError:3621, [Microsoft][SQL Server Native Client 10.0][SQL Server]The statement has been terminated.[/CODE] Thanks...  |
| | Hey there, I was wondering if I could get some guidance on how I could go about handling this problem. I'm creating a simple version control system database. The tables look like the following: [CODE]CREATE TABLE Users ( [UserID] INT IDENTITY(1,1) NOT NULL PRIMARY KEY, FirstName VARCHAR(32) NOT NULL, MiddleInitial … |
| | Hi, As i was experimenting stored procedure's TRY-CATCH with RAISERROR, came across this issue. Would like some opinion on this. Microsoft sites documented as follows: SQL Error 0 - 10: caught in the TRY-Block, i.e. will not reach CATCH-block. SQL Error 11 - 19: caught in CATCH-Block SQL Error 20 … |
 | Hi Guys I have an application that developed using ASP.net.There is cancel option,user can select number of item code and cancel it,but there is isssue.The issue is once user select more than 200 item code to cancel then it generate the error messsage.Error message is "Time Expird or server is …  |
| | hi.. i'm trying to retrieve the data from database using ssis package.. database name is employee which contains 48 tables and it is around 20GB of memory.. it is a production database.. now what i want is to retrieve the data for each four hours.. i.e i want to execute … |
| | Hello, I am trying to do the student evaluation and stuck in this problem. Each student evaluates himself and all his friends in the same class. I have a sample table below. On the query, I tried to join the table to itself to get a new column calls "StudentID-Change" … |
| | is there any function in PHP that can access my MsSQL Server...??? Note : All my Script was in Store Procedure |
| | For example, my query is something like: [CODE] SELECT fullName = firstName + ' ' + middleName + ' ' + lastName, streetAddress = address1 FROM Person [/CODE] How would I be able to reference fullName directly without having to type out first+middle+last again? If I just added "WHERE fullName … |
| | Hi there, I was really hoping I could find a person which could help me with my server setup to get it fully working for ASP.NET web applications under Win 7 Untimate (32bit). I'm trying hard to setup but I still can't get into the database file. I want to … |
| | I have a table with roughly 50,000 records. Each record has 25 or so columns. One of which is a phone number column. Some of these records, while most not not the same in any other way (a few are identical), have the same phone number. Id like to delte … |
| | Hello, I need help transforming a current script into on that can loop through some data for me. As you can see I currently have the ItemName and Address commented out "-- Set @ItemName = '95B046125' Set @Address = '195 WELLESLEY ST E'" and then I have to uncomment it … |
| | hi , i have a field in a table with the datatype as datetime. i wrote a query to get that feild but the thing is i want only the date to be displayed, how can i do that, currently the date and the time is being is displayed, how … |
The End.