Which is better VB Express or making a local web based application? If I choose to run a web based app from within our local network only, not out in the www, would i have to run another server to run the web app or will sql server 2005 accomodate that as well? Curious David W ...more >>

This might seem really simple or silly..... If I set up an UPDATE trigger against a table (eg. Table A) and the T-SQL code goes off to find some value from another table (eg. Table B), which is used to update a field in the original table (Table A), does the trigger get fired again when th...more >>

Hey all, Running into a first for me here..... I 'inherited' a SQL Server as part of my new job and there are some quirks happening that I have never encountered before. I am not a full fledged DBA, yet I thought myself at least fairly knowledgeable in SQL Server, but this has me stumped....more >>

I have a query that I need to return 478 rows, which is the number of records in one of the tables. The problem is that I have to join more than one table to the query, and I only get the rows that have data, whereas I would prefer to receive a NULL. Here is the query: select z.sponsor_id...more >>

This is a silly question but i must present it. I am creating a view between two tables. Both tables are identified by two pieces of data: User ID and Product Name fooshly those who created the tables did not create the Product name to be similar. Now i'm trying to join on dissimilar in...more >>

Howdy all. I have developers wanting to design a table that will hold not only client info, but what type of program they are eligible for. I have narrowed it down to 2 options, but was really looking for opinions. The current design is like this: Client Table: ClientId LName FName (Lots...more >>

I created view: CREATE VIEW dbo.v_test with schemabinding as select s.productID,sum(s.productQ)as quantity FROM dbo.invoice i INNER JOIN dbo.sell s ON i.invoiceID=s.invoiceID WHERE s.productID is not null AND i.status<3 GROUP BY s.productID Now, I would like to create index: CREATE UNIQ...more >>

Nothing I do changes the format of the date. declare @PubDate datetime set @PubDate = convert(varchar,getdate(),111) SELECT @PubDate,* FROM OPENquery(MySQL, 'SELECT * FROM articles WHERE Weight = 3 AND DateInserted >= DATE_SUB(@PubDate,INTERVAL 15 DAY) ') I need it to show...more >>

Hi, Could someone tell me how I might search for a newline character in a particular field? Many thanks, Craig...more >>

where did the import txt file wizard go in sql 2005 ?? i used to just right click on the data base / tables then sleect import / export. any ideas??? thanks!...more >>

Can I change DB Collation after it is created ?? ...more >>

HI all, is the only or perhaps the best way of executing a tables trigger via another trigger or SP by actually updating said table I have a calulation in table a update trigger. It is based on related values in table b But if those value in table b are change, table a's values need to be recal...more >>

HI all, How can I ensure that a row is updatable or not updatable based on a bit colum of that row. So that if the bit value is 0, then that row cannot be updated, and vice-versa THanks Robert ...more >>

Hello, I've got an insert trigger defined on a table. Everything seems to work perfectly excpet the body section of my e-mail message is delivered empty. Here the relavent code segment... Begin DECLARE @CaseCounter varchar(50) If (SELECT Count(*) FROM inserted WHERE PI_ID = '0000') >0...more >>

I am aware how symmetric and assymetric keys are used in sql. Can some one point me to good articles on what are symmetric and assymetric keys ?. thx ...more >>

Can someone help with a query to change the column names in a table Thanks Chris ...more >>

is there any reason why a sql command will execute in sql server and not in Vb.Net? It takes about 1.5 minutes to execute.. Would the timeout have anything to do with it? If so how do I increase it?...more >>

Hi. We've got a stored procedure on SQL Server 2000 with a Return statement, and sending back a number. Is there a way to view the Return value when executing this procedure in Query Analyzer? Right now, it's just displaying how many rows were affected. Thanks. ...more >>

I've got some tables that are growing very large and the vast majority of the space is unused space...take for instance: Table 1 rows = 161,000 reserved = 2,542,064 KB unused = 2,162,784 KB data = 357,952 KB index = 21,328 KB Because of this, my database is now 22G and 17G of that is unu...more >>

I searched and searched and didn't see what (i think) i need for a solution. Here's my situation. SQL 2k5 Stored Proc with set @XMLFile = ( SELECT 1 as Tag, NULL as Parent, cr.ID as [Resume!1!ID], cr.GUID as [Resume!1!GUID], cr.CandidateResumeTypeID as [Resume!1!ty...more >>

Hi , I have a doubt using xml in sql sever 2005. I found in many places while specifying Xpath ,the predicate contains '1' like /Inst:root/Inst:Location[1]/Inst:step . I tried with some other numbers in predicate like /Inst:root/Inst:Location[2]/Inst:step .i got null value. Can u plz expla...more >>

I would like to save an HTML doc in a column of a SQL 2005 database. However, in order to make it more legible, there are carriage returns -- </head> <body lang=EN-US> -- and all I can get using nvarchar or text is the part before the carriage return. How can I put the full fledged HTM...more >>

Hey guys I've something like this which is a reauirement. I dont want to use a dynamic SQL eg is create proc proc1 @ownername varchar(100), @IPaddress varchar(15) as select a,b,c from Table1 t1 join Table2 t2 on t1.col1=t2.col2 where ((t1.OwnerFirstName LIKE '%'+ISNULL(@ownername,...more >>

I have the following code to read the varchar in parameter. However, srv_convert function sound doesn't fill the temp variable. It remains the testing 'aaaaaaaa...' string. Any clue? Thanks. char* temp = new char[8000]; for (int i=0; i<7999; i++) temp[i] = 'a'; // For...more >>

Hello everyone, I would like to run a select statement every nine seconds 24 hours a day, 7 days a week, 365 days a year unless I physically stop the select statement myself. Currently I have a while loop that runs 89 or 90 times with a wait for command in it to select information into a table...more >>

I have a db containing 2 base tables and a view with an INSTEAD OF INSERT trigger that updates both tables. I want to prevent inserts on the base tables themselves with an INSTEAD OF INSERT trigger that would raise an error indicating that the appliation should insert against the view and the...more >>

Hi I can't quite decide which is more annoying, string manipulation in plain ANSI C without any helper libs, or in T-SQL. I've figured out the copy text from one to another table, now I have to conversion problem. Here's my query: declare @workcodestring varchar(100) select @workcodestring...more >>

Hello, Does anybody know how to compare the subsets of two columns on different tables? We have a column A in Table A that we want to compare any 10 characters to column B in Table B. Does anybody know the code to do this? Thanks...more >>

hi! all, i have a problem , i want to debug the stored procedure in sql server. help me thanks in advance shiva ...more >>

Hi all could anyone pleeeeeeeeeeease help I have big problems moving my database from Access to SQL 7.0... I had an Access database having queries, forms, and reports linked to another Access database having tables. Now, I'm moving my tables to SQL and I did thanks to Access wizard and everythi...more >>

Hi In MS Excel exists function TRANSPOSE. Is there any possibility to do the same in SELECT-query with T-SQL? Explanation: Table with 3 fields: Name / Age / Weight Carl / 15 / 172 Eva / 44 / 155 I want to show this data to user so: Carl Eva 15 44 172 155 ...more >>