3,481 Topics
 | |
| | 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 everyone, I am having problems opening certain websites recently, for instance I can't open hotmail and other websites requiring logins, however I am able to open googlemail... Anyway I am using firefox and I thought the problem was caused by my firewall (zonealarm), but after I deleted it I … |
| | 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? |
| | I obtained virusheat and potentially other problems from an activex. Help please! Logfile of Trend Micro HijackThis v2.0.2 Scan saved at 10:23:54 PM, on 3/28/2008 Platform: Windows XP SP2 (WinNT 5.01.2600) MSIE: Internet Explorer v6.00 SP2 (6.00.2900.2180) Boot mode: Normal Running processes: C:\WINDOWS\System32\smss.exe C:\WINDOWS\system32\winlogon.exe C:\WINDOWS\system32\services.exe C:\WINDOWS\system32\lsass.exe C:\WINDOWS\system32\Ati2evxx.exe C:\WINDOWS\system32\svchost.exe C:\WINDOWS\System32\svchost.exe C:\WINDOWS\system32\Ati2evxx.exe …  |
| | I am getting pop ups from symantec telling me that I am trying to send spam to addresses I don't even know. I have tried to fight this with Norton, Adware Alert, cwshredder, .... but nothing seems to work. I have seen similar threads but I am not sure 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) … |
| | Hi all. I have setup phpbb3 successfully in the past with MYSQL. Fast and easy. But my friend has a server that only supports MSSQL. The phpbb3 setup programs states only that "MSSQL Server 2000+ via ODBC is available." I have been spoiled using all the tolls Godaddy has to … |
 | Hi- Here is my question. People, where I work, friends of mine, other programmers, etc. are always talking about "best practices" in application design. Specifically, people are taught/told to minimize the number of SQL queries sent. Now, here is the thing, I am personally under the impression that it doesn't … |
 | |
| | Hi, If someone can help me with this I'd really appreciate it! I installed SQL Server 2000 Standard Edition on Windows Server 2003. This server is due to take over from our present Windows 2000 Server. It was my first time doing a SQL install, so I ended up calling … |
| | Hi, my computer has been running extremely slowly in the past couple of days. I have all the proper programs, but the errors they are deleting do not seem to be fixing the computer. Instead of a hardrive as my C drive, I have a red X. Many spybot errors … |
| | hi, I have a table with two columns. i want to insert into first column the values of 2nd column where it is between 7 and 10. the table is #temp as well. so i can not use views... i need to make a function. can you guys please help …  |
| | Hi, I have two table like this: [QUOTE][B][COLOR="Red"]quote_tb:[/COLOR][/B] [B][U]ID item vendor quote[/U][/B] 11 a v1 100 11 a v2 200 11 b v1 400 11 b v2 300 11 c v1 555 11 c v2 777 22 a v1 122 22 a v2 222 22 b v1 322 22 b … |
| | Hi, Wondering if anyone can help me overcome this curious problem... I suppose its both a maths problem and SQL problem... If anyone can help with the Maths OR the SQL would be very helpful! Synopsis: Capture the value of the current 'credit' of a user. Similar to that of … |
| | select myColumn from myTable1 union select myColumn from myTable2  |
| | I have two tables - products and productpropertyvalue I need to select multiple fields from the productpropertyvalue as it corresponds to the product id. The script I am using is select a.id, a.productname, a.siteprice, b.propertyvalue from product a, productpropertyvalue b where a.id = b.productid and propertyid=590 This allows me to … |
| | select CASE WHEN FirstColumn IS NULL THEN '' ELSE FirstColumn END + ' ' + CASE WHEN SecondColumn IS NULL THEN '' ELSE SecondColumn END as ResultColumn from myTable |
| | today i came across to an sql problem from one of the threads in the database forum : to solve the problem i created a table named "names" having these columns : PKID | name | lastname and i entered some rows having the same values for name and the … |
| | hi everyone, I need to know what are the services that sql server has. e.g. reporting etc. can you guys give me a list of these services. thanks  |
| | Here is data EnqSrNo 9 9 9 9 9 9 9 9 9 9 9 9 9 9 9 9 9 9 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 11 11 11 11 11 11 11 11 11 11 … |
| | Hi, Is it possible to install SQL 2000 and SQL 2005 server on a single server? If yes then will it create any problem? Thanks, Kailash |
| | In Turkey we use "." as thousand seperator and "," as decimal seperator. If you are working with currencies in sqlserver, and if the money columns is of type "money" then the problem occurs beause of the seperator issue since in its default mode sql server accepts "," as thousand … |
| | How to insert big html markup with white spaces(i.e. line breaks) and single and double quotation marks to sql server : To insert that big html markup to ms sql server, i tried to copy the markup and paste it to the sql server table cell first. It didnt work, … |
| | Hey guys, I know people are debating about whether or not this is a problem, but I'm stuck with FunWebProducts files that I just can't seem to get rid of. A few days ago it was just FunWebProducts and MyWebSearch, but now it's that AND some other things have appeared …  |
| | Hi I want to write a query which will return me Sum(MarkU) and also the avg. Which is something like (Sum(Sum(MarkU)))/5 in mathematically operation or TotMark = Sum(MarkU) AvgMark = TotMark / 5 I hope you get an idea what i need. How to write this type of query in … |
| | Hi there. i would like this procedure to delete all rows in 'sale' where date_modified < (getdate() +0.02) and all the related rows from 'sale_detail' and 'sale_address' i have written the code below, but ti think this might only delete one row from sale and its related rows in the …  |
| | Hi, currently I have a shared web hosting with MS SQL server 2000 database. I have already implemented the database, with all the data inside the database, on the server. Now I wish to copy the whole database (.mdf) down to my PC, in case I wanna change hosting or … |
| | Hello all. This is my first post. I'm a software engineer with a general knowledge of SQL, but am no where close to an expert, let alone an intermediate. My current issue is I'm working on a query which combines 2 tables: TableA UniqueID Auto Increment ProjectName String <Extra Data> … |
| | I'm dealing with queries that manages a lot of data consolidation and I'm having to repeat large blocks of code to get the desired result. I'm wondering if that is any way to make it simple. My queries looks like this: [CODE] SELECT (A + B) AS C, (D + … |
| | |
| | I am posting this log in hope someone can help me with my problem.I have followed several directions on how to rid my laptop of this nasty bug with no good results.It continue to invade my registry and system even after removing several things.It would be a great help if … |
| | Hi Guys, I was just wondering if there's a way of restricting access to the contents of a database by creating a list of users and their corresponding password. So when ever someone tries to open the database a form pops up asking for their user name and password. Thank … |
| | Hi, I'm a newbie in MSSQL. But i already tried using mysql. How can I create a database in mssql. I mean what would be the first step. I had installed Microsoft SQL Server 2005 along with Microsoft Visual C# Express Edition. The following are the tools found in Start>Program … |
| | Hello All, I'm new to the computer world in the sense that I have a new interrest in programming and developing. I was asked a few questions by someone I was chatting with on a website , who's name I wont mention, but it involves avatars; I was sooo lost. … |
| | hi there guys ,, im have just a idiot asking ,, i have sql server 2005 express but im confusing for data work , where can i install that , into server or client , or both>>.??? i know how to basic program in SQL but configuring its merely little … |
| | I am trying to work on a database with 3 tables. To make it easier I have created a couple of temp tables to work out the syntax. CREATE TABLE #owner ( [NameId] tinyint IDENTITY(1,1) NOT NULL, [Name] varchar(50) NOT NULL ) INSERT INTO #owner VALUES ('Thanatoid'); INSERT INTO #owner … |
The End.