Hi, If I want no one to be able to use then native select, delete, update etc.. and rather force the user to use stored procedure that I have included in the server. how to do that? Give: the database has 2- accounts...one limited privileges account for the users to use and one for me the o...more >>

Hi, I have a main table that references many tables (something like Orders table, referencing Customers,Employees...). As an example, there are many orders that have Null value for their CustomerID therefore I need an Outer Join from Orders table to retrieve all rows. Now a View that joins Cus...more >>

Hello, i have an application with own user management. The application users should be created as database users on sql server too. So i have a table for storing the application logins and if a new user is added then a trigger should add the same login name with database name as prefix as new ...more >>

Hi, I'm just starting w/ VB.NET and want to find out how to bind an image from a field in a SQL Server database table to a PictureBox control. I am able to get data from the database into text boxes, etc., and to navigate and query to different records, but coming from the Access world, I'...more >>

Hi, How do I drop all stored procedures with the prefix of "www_". Basically, I need to add all new dev DB sprocs to our prod DB, but on the prod DB there are a whole bunch of old sprocs that needs to be dropped. Thanks in advance Christian ...more >>

I must link from one table to either of two tables X & Y. I can store this link in columns: REF_X_ID NULLABLE REF_Y_ID NULLABLE plus a constraint to ensure only one REF_*_ID is set for a row OR in columns: REF_ID NOT NULL WHICH_TABLE i.e. store ID for both tables in only one colum...more >>

I have following table: CUSTOMERMASTER ACCOUNT_NUMBER char(10) PK ACCOUNT_NAME varchar(35) CUSTOMERDETAIL: ACCOUN_NUMBER char(10) PK UPDATEDATE datetime PK ADDRESS1 varchar(25) CITY varchar(10) ORDER ACCOUNT_NUMBER char(10) ...more >>

Hi everyone, I need to add some logic to this TSQL statement that will replace a value if not null between the UNION of the views, otherwise use the current value. The following statement works to union the four views: SELECT organizationid, organization_name, businessunitid, busines...more >>

Hello - I have a user form that when "submit" is pressed, a stored procedure inserts the info into a table. Thought I was done with this part of the app and when testing, came across the delightful possibility that a user could click the back button and submit info any number of times...more >>

SQL server uses single quote as string terminator. How can I write into my data? For example: "INSERT INTO MYTABLE SET COMMENTS = @MYCOMMENTS WHERE ACCOUNT_NUMBER = @MYACCOUNTNUMBER" When user has single quote in the comments the SQL fails. How can I avoid this situation? Any informat...more >>

Hi, I am using a DTS package to "Export Data" between two databases, but in fact I want to be able to create a copy of the first db.. I am obviously a newbie, but is there a better way to create a duplicate or "mirror" of the main database and use a DTS package to automate the process? th...more >>

I have a dropdown box to running a query filtering mt records. The dropdown has 4 option: ALL, Close, Open, Pause. which filter the status of records. When I change dropdown from all to others works fine, but when I change from the Close, Open or Pause to All then it takes more than 10 seco...more >>

I have a SQL server database application, I just wnated to know that may I maintain the system while user use the sysetm? Should I maintain the system while all user off line? Any information is great appreciated, ...more >>

I have a table with ntext and nvarchar(35) fileds. COMMENTS ntext ADDRESS nvarchar(35) I wanted to update at same time. Do I need in 2 UPDATE statements? I use "UPDATE MYTABLE SET COMMENT = @MYCOMMENT, ADDRESS = @MHYADDRESS WHERE ACCOUNT_NUMBER = @MYACCOUNTNUMBER" do...more >>

Hi All, I have a database that has not recieved any type of maintenance apart from daily backups. It has grown to over 30GB. I created some jobs to reindex tables that I thought were high activity. Query performance increased substantially but I believe it could be better. Database has ...more >>

Hello - is it possible to store a zipped file (group of files) in a BLOB fields? ...more >>

Hi, I'm a newbie on using cursor. My question is if I create an update trigger that loop through the Inserted rows by a cursor, and inside the cursor loop, a stored procedure is executed, which contains a cursor loop too, any problem about it?...more >>

Hi This query works but I wonder whether there is a more elegant way of constructing it: --PUBS database ----title(s) with max (sum( qty )) use pubs select * from titles t join ( select title_id , sum(qty) as som from sales group by title_id ) as somq on t.title_id=somq.title...more >>