• SQL or T-SQL

    This question related to this thread: http://itknowledgeexchange.techtarget.com/itanswers/difference-between-sql-and-t-sqlmicrosoft-sql-server-2000/ So if I want to study SQL server, should I first study SQL and then T-SQL or just dive right in to T-SQL.

    BJ20125 pointsBadges:
  • Can any one post IKM online test questions (SQL Server 2008) please?

    IKM online test questions SQL Server 2008.

    IKMsql1235 pointsBadges:
  • Concatonating year using date parameter with extract function

    I have a date parameter :ASOFDATE being entered as such: 01/01/2008. I would like the following to print out in my columns: 2008-09. The code I am using to attempt getting this is as follows: to_char(extract(year FROM to_date(:ASOFDATE, 'DD-MM-YYYY'))) || '-' || substr(extract(year FROM...

    tmbdnelson70 pointsBadges:
  • Sharepoint 3.0 website no longer working after Windows updates installed

    We have an Intranet site that was set up in SharePoint 3.0. Over the weekend windows updates were installed, specifically KB2687442. Now my Intranet site does not work. When I try and run the SharePoint Products and Technologies Configuration Wizard it fails at step 9 with the following error :...

    PPitcher85 pointsBadges:
  • mdm.udpValidateModel can be run twice with no side effect.

    I am new to MDS, client give me the mdm.udpValidateModel SP with @username etc. parameter. i don't know i parsed first time or executed. I again executed. will there will be any side effect . please guide me urgently. urgent. SET @User_ID = (SELECT ID FROM mdm.tblUser u WHERE u.UserName = @UserName...

    Manishkumar198010 pointsBadges:
  • SQL Select Stmt

    Need to create a sql stmt to find all the people who work on exactly the same projects and same hours as Smith.

    testaduro55 pointsBadges:
  • System i Navigator Run SQL Script block CL commands

    Hello. The run sql script in System i Navigator allows me to run CL commands. How can i block this? Thx in advance.

    MelGranja20 pointsBadges:
  • SQL Server TempDB

    How do I clear data from TempDB?

    wertq5 pointsBadges:
  • How to insert data from SQL procedure

    How can I insert data from SQL procedure. I am using cursor.

    97834441841,355 pointsBadges:
  • sql query of datediff between two columns

    i am having one table in sql 2000 that is called (personal), in that table i am having two columns name date of birth(dob) and date of enrollment(doe). i want to write a query to get the actual difference between two date i.e like 10 years 03 months 22 days. Can somebody help me out of this. An...

    vinayak44910 pointsBadges:
  • install sql server express 2008

    I am asked for the cd for sql server 2008 native client

    luttsy10 pointsBadges:
  • SQL SERVER

    The SQL Server mobile edition is supported on?

    siphesihle10 pointsBadges:
  • Database

    How to create a database of prison management system using SQL?

    abuhafsah25 pointsBadges:
  • A01 Extension File

    Hi, It is some kind of DB file which has extension .a01. But I can't read the file because it's not clear. When I open it in notepad, it displays ASCII (Encrypted Format) only.

    Rupees15 pointsBadges:
  • Sql Query

    I have save data with special character (Enter Mark) in DB. But when I query the table and copy & paste result in excel then (Enter Mark) character does not come. I have refreshed the DB server due to some technical problem. Before reset it was working properly. But not now. plz help.

    Mr. SEA130 pointsBadges:
  • How to connect Visual Basic 6.0 to wampserver using odbc

    Sir, please give me the proceedure in connecting visual basic 6.0 to wampserver using odbc. show me on how to configure odbc in order to connect wampserver. Give me an example code of edit, delete and save using visual basic 6.0. Your help is appreciated a lot.

    Dudz20105 pointsBadges:
  • CR 11 connection to sql 6.5

    I need too connect CR 11.5 to SQL 6.5. Which connection method do I use?

    creggFisher5 pointsBadges:
  • Trigger

    What is the use of the trigger?

    swamy00725 pointsBadges:
  • I am getting following error for SQL server 2005/2008

    Hi, I have SQL server 2005 and SQL server 2008, both are installed on the same machine. Now I want to pass the server name like mymachine\\mssql2008 to one of my own stored procedure. This procedure tries to get the fully qualified table name of a particular table of some database which is on SQL...

    Brijeshkumar5 pointsBadges:
  • What are the security risks of using hosted SQL

    B"H Where ever I look I see that no one recommends having your SQL Server available on the Internet (public ip). Everyone says that you should only have local machines access your sql. If you need to access your sql then you should VPN into your secure network and then have access. or you should...

    Mplotkin5 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.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

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

Following