• How to manipulate data or values in my tables SQL Server

    A question emailed to us i can now connect the database i made (in mssql server) but the problem is i do not know how to manipulate the data or values in my tables. for example, in my login program. i do not know how to declare that the input of the user must compare first to the login_table (in my...

    ITKE827,890 pointsBadges:
  • SQL Command

    I have created a stored procedure in SQL2000 like this : SELECT p.PO_code,p.Po_date, p.Supp_code + ' : '+ s.Sname as Supp_Nme,p.po_total,r.RC_code,r.Amount FROM PO_list p inner join RC_list r on r.PO_code = p.PO_code inner join Supplier s on s.supp_code = p.supp_code WHERE (p.Supp_code in...

    283036050 pointsBadges:
  • SQL Server 2005 Express issue…

    Hallo, we have a pc that has Visual Studio and Sql Server 2005 Express installed on it, lets name it SERVER. We did a small project/application on SERVER with Visual Studio that has to be installed on another pc(client pc, lets name it CLIENTPC) and make some sql queries. The Database is placed on...

    Sad5 pointsBadges:
  • Automating an application

    I am a beginner in VB. I was working on a project to upload data from one table to another. The tables are in different databases. Now I am supposed to automate it so that the update from one table to another can be done regularly. I guess it should be timer based but I do not know how to use it....

    Karibu5 pointsBadges:
  • using a local variable to build an sql-statement beyond datatype nvarchar(4000) and execute with sp_executesql

    I build a sql-statement and put it in a local variable so i can execute it using sp_executesql, but a local variable cannot be a text or ntext data type, and a varchar data type cannot be used by sp_executesql. So the maximum lenght of the statement cannot be more than nvarchar(4000)... is there...

    Aabbccddee25 pointsBadges:
  • Community Message: Answer these questions and earn Knowledge Points

    Hi all Here is a link to some questions that still need answers. Take a look a see if you can help out your peers and earn Knowledge Points with every answer. Remember the members that earn the most knowledge points have a chance to win some cool prizes in the contest we are having. You can find...

    ITKE827,890 pointsBadges:
  • Reverse engineering replication

    I would like an "automated" way to "script out" existing replication for SQL Server 2005. Does anyone have a method for this? Thanks.

    Lizward5 pointsBadges:
  • importing into Reporting Services 2005

    Can Excel SS or anything besides an Access.mdb be imported into Reporting Services 2005

    Clestes0 pointsBadges:
  • SQL

    How to find out if database are crypted

    Mike645410 pointsBadges:
  • SQL 2005 Replication

    hello, i have a replication which is done between 2 sql 2005. server AB which is on a cluster is the publication whereas there are multiple servers who are the subscriber. whenever reepliaction is done i have the error : error authenticating proxy domain\username. check that the username or...

    Nns5 pointsBadges:
  • case when issue

    I recently came across behavior of a "case when" conditional expression that really confuses me. In this case: -- CASE when isnumeric('-10.00%') > 0 then convert(numeric, '-10.00%') end ---- the behavior is as I expected - the isnumeric() function returns 0 (cuz it ain't no number) so the "then"...

    Zhoover5 pointsBadges:
  • Autu-update of FTI in local replca

    How do you ewnsure the automatic FTU update of a local replca after replcation with server (according to Admin Help, this is supposd to be automatic - has been working, but now has stopped, dont know why!). Thanks!

    Chicagocat5 pointsBadges:
  • Temp Tablespace in 10G

    have a Oracle 10g database that is with its temporary tablespace full. Is there any way to clean this tablespace? I tried to restart the database, but i've no effect

    DAC15 pointsBadges:
  • exchange configuration

    We have Windows 2003 Small Business Server R2 and Windows XP professional workstations. The director of the company would like to operate the following scenario He would like to send and receive his company emails as normal. He would like his PA to receive a copy of all of his emails He would also...

    Ncmsgf0 pointsBadges:
  • passing the records based on the division condtion

    a falt file containg 500 records so i need to pass the records based on the division condition to the 4 output files created i.e records divisible by 2 not by 4 means 2nd,6th,10th records must pass to file 2 and divisible by 4 pass to the file 4 and divisible by 3 passed to file 3 and remaining all...

    Satidoni5 pointsBadges:
  • DTS error after deleting xls file with script

    All, After I have deleted a xls file using an ActiveX script the DTS Package fails because the file is not there. I then have to go into the properties of the task and go to the destination tab and click the create button. The I have go to the Transformation tab and then run the package for it to...

    Gdckboyer20 pointsBadges:
  • Upper limit for numeric fields

    What is the maximum numeric field length for Visual Basic Applications running on SQL 2000

    Mozie10 pointsBadges:
  • Filegroup in SQL Server 2005

    I have very large tables (5,000,000 records each year) which are frequently joined to each other, should I put each of them on a different filegroup? what about their indexes which are used in join conditions?

    Gerayeli5 pointsBadges:
  • Need help with running an external SQL query from within VB.Net code.

    Hi all, I'm in a bit of a bind and new to SQL. I have built a DB using the SQL Manager and it works perfectly in my code. I have used SQL Manager to build the SQL to rebuild my DB as I want to use it in my VB.Net code. When I execute this SQL in the SQL management studio it works 100 %. When I...

    Comtrendz5 pointsBadges:
  • Internet Explorer 6 closes window every time I open a new one

    Hi, Anyone seen this before? Every time I open a new browser window in IE6 running Windows XP Home Edition, the one that's open at the time is closed by the system, so only one browser window can be open at any given time. Regular windows work as they're supposed to I can open as many as I want...

    Xixones0 pointsBadges:

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.

Following