2,935 Topics
 | |
| | i am new to this database. can i know where can i type the command?:'(  |
| | Hello ! As in my text book , the most effective means to export a database ( complet or few tables only ) is to use DTS . The only variables needed are destination and origin addresses . What happens , when we do not know the address of the … |
| | Hi , I need your help please. I am using OSQL statement to execute SQL database script From CMD Line. Basically our application Support Other than English 5 Foreign languages, so each foreign language contains their on character set so its in Unicode format (`* byte format`). In the sql … |
| | Suppose a table ABC have column XYZ containing data 3PSY0001-06-08-F 3PSY0001A-07-09-P 3PSY0001-02-09-P 3PSY0001-07-07-F 3PSY0002-09-08-P 3PSY0002A-01-03-P 3PSY0002-07-07-F How can i write a query so that the data ending with P without A can be updated with A. For example, with that query, data 3PSY0001-02-09-P AND 3PSY0002-09-08-P will be updated as 3PSY0001A-02-09-P … |
| | I have production data on one server and test data on another. I need to move one record from the production server into the test table on a different server. I setup the production server as a linked server one the test box. I can read/select fine, but when I … |
| | Allright. I have two queries, which provide the exact same result, yet the simpler one is roughly 100 times slower than the more complicated one. I have absolutely no idea what is going on here. And let me add, there is no recursion so this is no idiocyncracy of the … |
| | The following code coincides with an onClick event on my form to move to the next record in a file, but I keep getting the Error Code: 424, object required. I have (3) other buttons on my form: MoveFirst, MoveLast and MovePrevious, but they all work fine. What is different … |
| | I want to get two columns data from two tables which are not dependent to each other i.e. no key common in both they are not related to each other. I can't use JOIN because it needs where clause which uses a common field from both tables. I just want … |
| | Friends, I recently switched to SQL server 2005 from SQL server 2000. Well in SQL server 2000, I used to made databases manually and applied other SQL commands from Query Analyser menu. Where's the same functionality is provided in SQL Server 2005 . Where's the path to go there? Waiting … |
| | I want make a query to retrieve only those records from table which are unique on the basis of some coloumns |
| | I use pymmsql to access MSSQL 2000, with a table, I store Chinese Character in NVarchar field, Chinese Character display normally when I query them by MS SQL Query Analyzer under Windows or by unixODBC under Ubuntu. But when I query those data by pymssql or pyodbc, all Chinese Character … |
| | Im using visual studio 2005 asp.net, vb language. How can i compare minimum and maximum values in a gridview when all the values are different in every row? |
| | Hi, sorry for a newbie question but I was wondering if the following is possible: I have to select some information from a table which I have already created a query for. This information then has to be inserted into a new table but needs another column with another unique … |
| | Hi all, My server will have multiple databases and I want, for security purpose, to have one user per database. This user will only be able to access that one table and no other. This user will have all rights to this database only. I created my first database/user combo … |
| | Hi, I have two datadase one one local system and another on web Both of them are on SQL 2005 .Now I want to make a link server to have connection from both database to transfer data . plz give me some link or code. thanks |
| | --Que-4)Create a Query to pull all emails that contains --characters +,^,*,&,! [code=sql]create table mail3(email varchar(50)) insert into mail3 values('mansi.sharma@yahoo.co.in') insert into mail3 values('mansi.sharma+yahoo.co.in') insert into mail3 values('mansi.sharma^yahoo.co.in') insert into mail3 values('mansi.sharma*yahoo.co.in') insert into mail3 values('mansi.sharma&yahoo.co.in') insert into mail3 values('mansi.sharma!yahoo.co.in') insert into mail3 values('mansi&sharma!yahoo.co.in') select * from mail3[/code] [icode]select * from … |
| | I ran a query to find 1)the current distribution group and corresponding account id number and 2) the historical distribution group and corresponding account id number from checks written in contract year 2008. Here is the sql statement from my query: [code=sql]SELECT EMPLOYEE_MASTER.EMPLOYEE_NO, EMPLOYEE_DISTRIBUTIONS.DISTRIBUTION_GROUP, EMPLOYEE_DISTRIBUTIONS.ACCOUNT_ID, PAYS_HISTORY.DISTRIBUTION_GROUP, ACCOUNT_HISTORY.ACCOUNT_ID, ACCOUNT_HISTORY.CHECK_KEY FROM HRS.ACCOUNT_HISTORY …  |
| | Hi all, please help. I m trying to create an "empty" table from existing table for the audit trigger purpose. For now, i am trying to create an empty audit table for every table in a database named "pubs", and it's seem won't work. Please advise.. Thanks in advance. Here … |
| | Hey guys! I was wondering if anyone could help me. I am a student on my work placement year and I am developing a web based database. I have been asked to design it so users can if need be add a new table to the database or add a … |
| | Hi, I have a simple SQL query [CODE=sql]update testcourselog set grade='a' where statusid=4[/CODE] It updates 114 records I am trying to write a trigger that will change a flag to 1 for all record updated by the query. [CODE=sql]USE [online] GO /****** Object: Trigger [dbo].[gl_courselog_iscounted_update] Script Date: 12/10/2007 16:49:32 ******/ … |
| | [B]FIRST EXAMPLE--[/B]CREATE FUNCTION dbo.myFunction() RETURNS INT AS BEGIN DECLARE @myInt INT SET @myInt = 1 RETURN @myInt END select dbo.myFunction() as 'Simple Number' This Function is not returning any value,Error is coming [B]Cannot find either column "dbo" or the user-defined function or aggregate "dbo.myFunction", or the name is ambiguous.[/B] [B][COLOR="Red"] … |
| | HI I have this situation in excel i have many rows for import but some rows in last cell have many insert and in that situation i must have every insert in new row that look like this collumns 1 2 3 4 5 6 rows 465465 54654 645 46546 … |
 | i have a database called [B]"BILLING_SYSTEM"[/B] in sql server 7.0 and I'm using sql server authentication mode to connect to the database with my [B]username[/B] [B]"BS"[/B] and [B]password "BS"[/B]. where my front-end is a VB6.0 application. [B]now I want to create this security login "BS/BS" from vb6.0 code without opening … |
| | Can I query a SQL Server 2000 mydatabase.mdf file directly via SQL? If so, how? |
 | how to calculate rank in selected record set in sql server 2000 can u help me? |
| | hi i am using sql server 2003. can we get the position of record / row index in sql server while retrieving records? like in some case we fetch records as per our criteria. And if that time need to know the postion of particular record then? how to get … |
| | I have a table having columns like values, like this col1 col2 col3 1000 10 2 1000 20 3 1000 30 4 2000 10 5 2000 20 6 2000 30 7 3000 10 8 3000 20 9 3000 30 10 I want to fetch records like if i enter col2 … |
| | Hi, I am trying to install a database from a backup file of a now deleted database. What happened was that the data file was at D:\SQLData\DatabasesMyDatabase_data.mdf, instead of D:\SQLData\Databases\MyDatabase_data.mdf so we wanted to move it. The main DBA here showed me a ‘quick’ way to fix this was by …  |
| | hi all, Table 1: ID | COL1 1 | 1 1 | 13 1 | 64 Table 2: ID | COL1 1 | 14 1 | 13 Output needed: ID | COl 1 | 1 1 | 13 1 | 14 1 | 64 How will i accomplish this??? Thanks … |
| | Hi, I am a newbie for MSSQL. Previously, I was given a question regarding MSSQL. Although the interview had over, but I am curious to find out on how to solve the question below: There are 2 tables, NAMES (ID INT IDENTITY(1,1), NAME SYSNAME) and RELATIONSHIPS (NAMEID INT, PARENT_NAMEID INT) … |
The End.