2,736 Topics
 | |
| | Hi all, I need to build a application in which i have to test wheather sql server 2000 is connected or not.I cant be dependent on any query using master database as user might not have access to it. I used following code [COLOR=#0000ff]Try [/COLOR][COLOR=#0000ff]Dim[/COLOR] objIPHost [COLOR=#0000ff]As[/COLOR] [COLOR=#0000ff]New[/COLOR] System.Net.IPHostEntry objIPHost … |
 | [COLOR=#000000]For years I have been working with MS Access and enjoying the simplicity and ease of use. I am now making the move and converting all of my sites to MSSQL. Virtually everything works but in the process, I have found an oddity that I am not used to.[/COLOR] [COLOR=#000000]I … |
| | I usually use Access 2000 (adp) to connect to my SQL Server 2000 and work with records. I have been testing out MS SQL Server 2005 but can't seem to get it to work with Access adp. Does anyone know if you can no longer use access adp in SQL … |
| | Hi Friends, I have the following query, i am using the column alias by this way, select work_Code as "Work Code",work_nature as "Work Nature" from sb_cm_work_nature it works fine and i get this output. Work Code Work Nature 1 External 2 DE-Sales 3 DE-Miscellaneous 4 DE-Equipments &Transport But my requirement … |
| | [COLOR=#008000]I have a table with a primarykey ID and a unique key for ID_EMP and OSID When I insert I want to populate the OSID column whth the next int value related to id_emp My trigger works but is returning the error message: Warning: Null value is eliminated by an … |
| | In my database, I have two tables: Forum and Files Files have two fields. First one is [B]FileID[/B] and second one is [B]FileAddress[/B]. [B]FileId [/B]field is fine. but in [B]FileAddress [/B]field I have a lot of urls. I want to just change certain parts of url. For example, instead of … |
| | We are considering upgrading SQL 2000 to SQL 2005. I just love the idea of getting newer technology, But i'm hesitant to upgrade MS stuff, cause of bugs and licensing stuff... So here's what i'm wondering: 1. If we move to 2005, will we lose any databases/querys/dts packages/etc ?? or … |
| | |
| | Greetings. How are all of you? I'm new to Daniweb, but heard of you through Mauisun. Anyhow, I have a copy of SQL 2000 standard, but it's an old school copy without reporting services. I understand that 2000 now comes with RS for free... does anyone know where this "free" … |
 | Hi guys. Hope you can help me with my problem here.. It's quite complicated so I'll try to explain it in a very detailed manner.. I have these two databases which we may call dbaseA and dbaseB. I created another dbase which we call dbaseC. dbaseC is going to be … |
| | I'd like to split a full name field on a space into first name last and update my database, I would prefer to stick to TSQL/SQL if it can be done on SQL Server 2005, any ideas? table actors actor_id int Unchecked actor_name varchar(50) Checked rating smallint Checked actor_last_name varchar(50) … |
| | Hi Guys I've got a bit of problem with date. When I transfer data of a table to txt file the date column that appears in the table like "28/03/2001" changes to "28/3/2001 0:00:00" in the txt file. I've tried to change the format of date in the table but … |
| | Hi all - I am a newbie to this forum, but maybe someone there can help. I have a table using an Identity property. The purpose of it is to just have a unique id value... the problem is that the system automatically fills this table with lots of data, … |
| | Greetings all! To get to the point, I'm having issues accessing SQL databases. The specific error is as follows: Connection failed: SQL state: '28000' SQL Server Error:18452 [Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection. Here's the setup: The workstation(s) … |
| | Hi all, DECLARE @STA as char(50) SET @STA = 'TT' SELECT * FROM ABC_TBL where ABC_Filed in (@STA) if i have multivalue in parameter @STA, like 'TT', 'DD', 'AA' so how can i write my statement? i only need to pass one parameter with multilist, so do anybody know how … |
| | How can I find active users and UsersID online in MSSQL ? I cannot find it in Enterprise Manager ? Someone know a scripts that can do ? I need to find active users before I do some upgrade jobb on servers ! Thanks in advance.... |
| | I'm getting the error [inlinecode]Incorrect syntax near '='.[/inlinecode] when I use the following case statement in a view. Obviously I'm not an expert on MS SQL, but I'm curious as to why I am allowed to use the '=' sign in a preceeding statement but not in the THEN section. … |
| | I have a web site that I've set up, and has been running for several years. The client has MS SQL Server. When it comes to the administration side of SQL Server, admittedly I don't know enough. The web application has been running fine, but we've been getting errors with … |
| | Hi Guys, I'm having some problems in importing data from a file into a table. I created this file by exporting data from the same table. I've deleated all the records from the table and now I want to fill it up from the file I've created I'm importing data … |
| | [COLOR=#191970]The data table looks like this date num1 num2 num3 num4 num5 num6 1/1/06 1 45 32 21 15 48 SQL script 1 should be able to do the following show the Top 3 number pairs another words if the pair 45 and 15 shows up 98 times and 32 … |
| | Gentlemen: :?: Sorry to have posted twice, but I really messed up the title. Can anyone send me to the right contact for some SQL Topology assistance? I have posted on several SQL Forums and everyone seems to dance around this topic. I need to find out the proper way … |
| | hi , how do i migrate data from mysql to mssql.....i need some free convertor tools....can any body help me |
| | Hi Guys, I was just trying to transfer data from access tables to a txt file and then back from file into a table using following code [code] Private Sub Command0_Click() DoCmd.TransferText acExportDelim, "Db Export Specification", "AUTHENTICATION", "J:\Power Equipment\Common\SK\db.TXT" End Sub Private Sub Command1_Click() strSQL = "delete * from AUTHENTICATION_TEST" … |
| | Hi :) Im not an SQL n00b, but I'm no SQL guru... I'd like to work out the SQL code required to achieve the following goal in pseudocode: Grap a record Using info from that record, add (the width) to a running total. When the running total exceeds a certain … |
| | i have two questions? i made my window application in c# using standalone firebird database ,now i want to make my exsisting application database as emmbedded firebird database???? how can i,and also want to implement import feature in my application,which imports the database backup file(export is working fine). |
| | Hey, I've got a databae in which each record has seven dates associated with it, and I need to pull out each record's ID and its associated most recent date. Here's my first attempt, but Access doesn't like it at all. [code]SELECT id, MAX(initialCertDate, recertDate1, recertDate2, recertDate3, recertDate4, recertDate5, recertDate6) …  |
| | Hi all!! Is there a way to return 2 cells merged in one? For example take the followng table: | A | B | C | |abc | def| etc | and from this do a "SELECT A, B FROM table WHERE C='etc'" but instead of getting two values "abc" … |
| | hi, after I manually create maintenance plan using SQL server Maintenence Plan Wizard with SQL Server Management Studio 2005, is there any way to create a script for all these setting that I've done? So that I can just modify the database name and run it on another pc, the … |
| | Let's say I have a column within a table that contains codes {0,1,2,3}. These codes are for what color shirt are in stock. We can say 0 is for black, 1 is for white, 2 is for red, and 3 is for blue. Then I run a SELECT query on … |
| | Hey I am just starting to play with some SQL stuff after upsizing a old access database. What i would like to do is be-able to pull information out of the SQL database and display this on a web site. The query i want to use i have built using … |
The End.