Could Textbox1.text or textbox2.text be hacked in anyway to allow for sql injection in the example below or is this as safe as it gets? Many thanks. Shahriar mysql = "select * from mytable where username=@username and password=@password" da.SelectCommand = New SqlCommand(...more >>

hi I am keen to know the sql command to display picklist values rather than unique numbers. for example, title is 1=mr and 2 = mrs if i say select title from contact sql returns 1 and 2 but i want it to return mr and mrs..any advice on this please...more >>

This question is quite common in my query, but I still have no idea about that. For example, My client have a number of companies, each company has its own phone number. Each phone number is store in row(not fixed number of row). Let say, there are 4 phone number (row) as 852 3745 3844 8...more >>

Hi all, I'm facing the following problem. I should return the records from a table by using a store procedure. But each record should be repeated a number of time. The number of time the record should be repeated in the output is specified in a column in the table. For example, for the f...more >>

I have been struggling to run an OPENROWSET query against a SQL 2005 db. While attempting to query a SQL Server 2005 database from a SQL 2K database using OPENROWSET I set the following error: *******************************************************************************************************...more >>

WHAT ARE THE OPTIONS do i have to pass a table from from one sp to another? write the data into a table and then use it from the other won't do the job for me. thanks ken ...more >>

A table looks like this: create table #customer ( customerID int not null primary key, taxID char(9) not null, salesRep int null) insert #customer values (1, '111111111', 5) insert #customer values (2, '111111111', null) insert #customer values (3, '111111112', 7) insert #customer values (4, '...more >>

I know that each record in a table has an id internally. Can someoneshow me how to utilize it? thanks ken ...more >>

I have a stored procedure that does heavy query to get a dataset. That dataset is then used in several other queries and joined to other physical tables in the database. When I use a temp table to store the dataset, it is very slow when joining in the subsequent queries. I have determined that...more >>

Hi All I need a query help. How to display the record(only record) that has maximum occurrence of a particular value in a column? Say, I have a Table called Table1 with columns Col1, Col2, Col3 and Col4 and Col5. I want to display the record details that occurs maximum number of times, w...more >>

I am using a self-join to add amounts with different dates in the same table. CREATE TABLE #Testdata ( Account char(1), AmountDate datetime, Amount int ) INSERT INTO #Testdata (Account, AmountDate, Amount) VALUES ('A', '20060801',5) INSERT INTO #Testdata (Account, AmountDate, Amount) V...more >>

"[Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 4306: [Microsoft][ODBC SQL Server Driver][SQL Server]The preceding restore operation did not specify WITH NORECOVERY or WITH STANDBY. Restart the restore sequence, specifying WITH NORECOVERY or WITH STANDBY for all but the final step. [Microso...more >>

I am looking for a really good set of training CDs for SQL 2005. I dont want a set that teaches me how to pass the MCDBA tests. I want a set that teaches me tips and tricks and the how-to's of real programming with the 2005 model. Any ideas? Thanks Richard ...more >>

I have a table that has a trigger that loads data into other tables. When I run records into this table, there is one field in particular that sometimes loads and sometimes does not (@DstIndx ). It is a strange aberration because the same value in two different records may get loaded for one...more >>

We are using xp_cmdshell in a trigger to call a VB program and pass to it required parameters. The call with the parameters in the desired structure is below (code stripped down to bare essentials): declare @sDirectory varchar(200), @sBartender varchar(200), @sOutput varchar(200), @sFormat...more >>

I need help on two questions: 1. Is temp table the only way to pass recordsets from a nested stored procedure to a calling stored procedure? Can we avoid temp tables in this case? 2. Are operations in a stored procedure treated as a transaction? Any help will be greatly appreciated. Backgr...more >>

Hello all, Following is a sample script for sp: Create Procedure spTest @Flag Bit As If @Flag=0 Begin Select * Into #tmp From tblTable1 End Else Begin Select * Into #tmp From tblTable2 End Select * From #tmp Drop Table #tmp GO This scri...more >>

I have a table that has an ID column set as an int type with identity set to 'Yes', so that each number that is auto-generated in this column will be unique. However, now I need to add a second table to the database which will also need an ID column. My problem is that I have a requirement t...more >>

hey all, how do i get/set password for sql express? thanks, rodchar...more >>

Any simple example on internet to get started with SSIS slowly changing dimension object? I am getting an error and can't find any info on resolution: there must be at least one column of fixed, changing or historical type of input for slowly changing dimension transform. help appreciated...more >>

Hi I would like help with the following query. The table: CREATE TABLE [dbo].[MyTable] ( [ID] [char] (5) AS NOT NULL , [period_date] [datetime] NOT NULL , [value] [numeric](18, 6) NULL ) ON [PRIMARY] Sample Data: 0004N 9/30/1989 67.309 ...more >>

I have 2 tables in SQL Server 2000. Table1: ID Field1 Field2 Field3 111 Table2: ID Field Code 111 blue 1 111 red 2 111 yellow 3 I need to update Field1, Field2, and Field3 in table1 as follows joining on...more >>

Why would the following SQL return different rows??? SELECT CQTLOAN.LOAN_NUMBER, CQTLOAN.LOAN_CREATED_DATE FROM CQDS50.dbo.CQT_LOAN CQTLOAN WHERE MONTH(CQTLOAN.LOAN_CREATED_DATE) = '06' --WHERE CQTLOAN.LOAN_CREATED_DATE BETWEEN '06/01/2006' AND '06/30/2006' ORDER BY CQTLOAN.LOAN_CREATED_DA...more >>

I have almost got log shipping working (SS 2000) but have one last issue to go. First of all, all jobs that log shipping set up on my primary server are working. And on the secondary server all jobs are working except for the "Log Shipping Restore for PrimaryServer" but doesn't give any usef...more >>

Ultimate goal - find all addresses that are either all lowercase or all uppercase. Running SQL 2000, hotfix level between SP3 and SP4. Created a new table of address data that is case-sensitive. CREATE TABLE Address (Address_ID int , House_ID int , Address_1 varchar(50) NOT NULL COLLATE...more >>

what is wrong with my code here? I need to query from a remote sql server. thanks SELECT * FROM OPENROWSET('SQLOLEDB', '192.132.88.30'; 'loginName';'Password', 'SELECT * FROM MyDataBase.dbo.Mytable') ...more >>

I know that a user must have permissions to call a UDF directly, just like they must have permissions to EXEC a stored procedure. However, if a UDF is called from within a stored procedure, and the user has permissions to the SP, does the user also need direct permissions to the UDF as well...more >>

I need to return all rows from a table with 50K+ records. The computer that runs this program does not have sufficient resources to run such a large query, although it runs fine with 5K or 10K results. I know about "SELECT TOP <N> * from <TBL>" but is there a way to start from a row index othe...more >>

I have read that there will be SQL Server 2005 performance improvements in SP2 for Windows 2003. Does anyone know the specifics on what will be improved? Thanks ...more >>

i am trying to run the query tht only brings the date. In our database we have a date record like that (1999-05-18 00:00:00.000) Is there any way I run query and only bring date(1999-05-18) not time (00:00:00.000)? thanks Farrukh ...more >>

Hi all I have this table guid datecreated account dateremoved 5DC40536 1.8.2006 9574DAAD 30.8.2006 A89B5B69 17.7.2006 FD20B38C 17.7.2006 2B9FD838 30.5.2006 BEB49691 14.9.2006 6C2B8DFA 17.7.2006 FD20B38C 17.7.2006 C0BAB1A4 17.7.2006 FD20B38C ...more >>

[VS 2005 Pro, SQL 2000] Hi all, I've been using an SQL 2000 database for testing/debugging code. The code is ready for the real world however I would like to purge all content from the database and reset it to a 'new' state. Specifically, a few tables contain an auto-increment (Iden...more >>

I have a SQL 2000 instance and a SQL 2005 instance on a 32bit Win 2003 Servers. Both systems are using the same user id & password. Both instances use windows authentication mode. In the SQL Server Enterprise Manager on the SQL 2005 instance I created a linked server to the SQL 200...more >>

Hi all, I'm searching for a simple sql statistic solution. I have 2 tables: 1st table: website-visits | department ---------------------------------- 5 | A&B CD Z1 30 | A&B AD Z0 4 | B&B X1 2nd table: customer | department-searchstring --------------------------------...more >>

Hi All, As all the comp.database groups seam to be available for read only (and not post) I'm posting my question here, hopefully someone much better at SQL can help (which isn't saying much my SQL knowledge is rather limited). Anyway I have a table which has the properties Allocati...more >>

This post continues much of the work done in the thread: Subject: UDF that takes a UDT as a parameter (CLR) (Kent has been very helpful) but is a little different I have created a UDT that essentially represents an interval between two integers. (the code for the UDT can be found at the...more >>

Here is an interesting problem: Lets say I own some imaginary company. Like for all companies, my employees report their time to some time reporting application. Following table stores these time recording activities: EmpId Date Project No_of_hours 1 08/01 P1 ...more >>

Is Microsoft published example of SSIS package (or packages) for making adwentureWorksDW database from AdwentureWorks db? Where can I find it? Thanks ...more >>

In a sp I aggregate values in a union: SELECT O.operations_code, SUM(ISNULL(OL.operations_duration, 0)) AS Accum FROM dbo.dpr_report R INNER JOIN dbo.dpr_operations_report_line OL ON R.dpr_report_id = OL.dpr_report_id RIGHT OUTER JOIN dbo.vessel_operations_code O ON OL.operations_code_id =...more >>

Hi Friends, I have to transfer data from one database to another and some of tabels in both the databases are different in no. of columns and some new tables are added. Some tables are having 1,000,000 records. I have written INSERT INTO SELECT queries. for the tables having 1,000,000 ...more >>

I got a table created something like this: CREATE TABLE dbo.MyTable ( [ID] uniqueidentifier NOT NULL ROWGUIDCOL CONSTRAINT [PK_MyTable] PRIMARY KEY, [...] ) ON [PRIMARY] ALTER TABLE dbo.MyTable ADD CONSTRAINT [DF_MyTable_ID] DEFAULT (newid()) FOR [ID] Now I INSERT a new row, a...more >>

My table is defined as TABLE PERSON id, int Name varchar(500) Table PlacesOfTravel Personid(fk from table PERSON) Place sample data for PERSON 1 Manmohan singh 2 Sonia Gandhi sample data for PlacesOfTravel 1 New Delhi 1 New York 1 Bangalore 1 Hyderabad 1 Chennai 2 New Delhi 2 ...more >>

I'm trying to write a query to sort a table by a column containing both numerical and alphabetical values. The values are stored as strings. The problem is that I need to sort numerical values numerically and sort anything with alphabetical characters in it alphabetically. For instance the col...more >>

Greetings, I am looking for a way to implement UNDO in my database apps. We have several SQL 2005 Standard Ed and SQL Everywhere database apps. Some are connected to web forms and a few others connect to Windows forms. What I would like to do is give users a command to UNDO some number of ...more >>

Not sure whether this is a setup or a programming issue. I tried setup and got no response. I'll try programming. In SQL 2000, I could drop system extended stored procedures without any problem and replace them with my own extended stored procedures or stored procedures with the same name. On...more >>

Hi Group, I have been struggling this case for two days but still could not proceduce the desired result. I have student table: studentid studentname 001 student 1 002 student 2 003 student 3 subject: subid name presub postsub 02en english 03en e...more >>

--DDL create table systems ( sysid int primary key, sysnme varchar(30) not null, sysuser varchar(40) null, ) create table software ( swid int primary key, sysid int references systems(sysid), cmpny varchar(30), prod varchar(30) ) go --Data inserts insert systems values(1,'sys1','us...more >>

Hi all, I've been asked the question of one can peform a union with the results of two or more SP's Thanks Robert ...more >>

Hai, I want to convert from rows to columns. I have a table like this. col0 Day Task ----- ----- ------- 1 Mon Office 1 Mon work 1 Mon Client 2 Tue Office 2 Tue Client 2 Tue Holiday 3 Wed Tour I want out...more >>