• iSeries SQL ISNULL Equivalent

    What is the equivalent of the function ISNULL in t-sql in AS/400 iSeries Navigator SQL? or the equivalent of the NZ function in Access?

    Jaggerdude60 pointsBadges:
  • T-SQL Programming Tutorials

    I am looking for a website that is free and where I can learn to write better T-SQL views and stored procedures.  Also, would like to find some good books to learn more about managing a SQL 2005 database.

    Luby10 pointsBadges:
  • T-SQL with Recursion – Display top ID on all levels below (To: Kent Milligan)

    Hell Kent, I read through "V5R4 SQL Packs a Punch" http://www-03.ibm.com/systems/resources/systems_i_software_db2_pdf_rcte_olap.pdf    I would need the query in figure 20 and the result in figure 21 which do not show up in the article.  I have a query similar to the example (parts of an iSeries...

    Cavallino30 pointsBadges:
  • Copy BLOB to BLOB using TSQL

    Is there a way I can copy a BLOB from one column to another using TSQL ?

    Prototyper5 pointsBadges:
  • iSeries accessibility to VB.NET, ASP 2.0/3.0 ,NET programmers in Visual Studio

    My shop does not have WebSphere but does have a sizeable VB.NET team using the MS Visual Studio. They need access to the iSeries files in DB2/UDB - real-time. We already thanks to me have a number of batch/DTS package type transfers. Do any of you know packages that can make the iSeries files...

    JohndeCoville0 pointsBadges:
  • tutorials

    hi all. i wanted to ask if anyone knows any sites where i can download free ebooks or free tutorials. thx.

    Mmm5550 pointsBadges:
  • SQL indexes

    hello, there are many indexes clustered an non clustered .so how can i see the result of each index, clustered and non clustered seperately through (T-SQL) pls guide me. RINO

    Fhhdjfhjdhfjhjdfh135 pointsBadges:
  • SQL Server schema

    Hi,    How can i get the user names assigned to the Schema through (T-SQL) Regards; Rino

    Fhhdjfhjdhfjhjdfh135 pointsBadges:
  • Multithreading T_SQL

    I have to pool data from 1000+ sites on different physical servers through a web service running on each server. What is the best way to do so using T-SQL so that the multiple threads/processes run in parallel

    Rajeevraina5 pointsBadges:
  • difference between t- and pl sql lang

    in both t-sql and pl/sql we can use if/else condition and jump into other statements..then actually what makes the difference between t- and pl sql lang?

    NidheeshPV5 pointsBadges:
  • passing data between two SQL Server databases

    I am having an issue to passing data between two SQL Server databases.  I can not simply use Import/Export functions or Data Transfer Functions from SSIS because I was asked to transfer “20%” data with more than 15 criteria among 200 related tables.  Also we are not allowed to use the...

    LL12325 pointsBadges:
  • Set identity to not for replication in T-SQL

    Hi, Does anyone know the TSQL to change the identity column on a table in SQL Server 2000. And also the TSQL to change trigger to not for replication. Thanks

    Db23290 pointsBadges:
  • SQL select loop list?

    Say I want to derive the following: Select ID, F1 from table Union Select ID, F2 from table Union Select ID, F3 from table Union … etc until F10. Is there smart and easy way so that I can just provide a list: F1,F2,F3,…,F10 and somehow be able to have the select statement loop through it? Also,...

    Vinical5 pointsBadges:
  • T-SQL query to ACESS 2007 database

    I need examples of T-SQL queries running on SQL Server 2005 that retrieve data from a MS ACCESS 2007 Table. Any explanations are appreciated. Thanks

    DamMan5 pointsBadges:
  • Variables in T-SQL

    Hi, I want to know y does the following script run in SQL and not in T-SQL DECLARE @tblName varchar(30) SET @tblName = CONVERT(VARCHAR(20),GETDATE(),112) + 'Table' DECLARE @sql nvarchar(4000) SELECT @sql = 'CREATE TABLE "' + @tblName + '" ( ID VARCHAR(15), Name VARCHAR(15) )' EXEC(@sql) go it gives...

    Babar198220 pointsBadges:
  • Capitalize First Character

    How can ensure that when certain columns in a row are INSERTed/UPDATEd, the first letter of the value is capitalized and the rest are lower case? For example "QUESTION" or "question" should be converted to "Question".

    VelameLaCosa110 pointsBadges:
  • Transact SQL stored executed from AS/400 CL program.

    How can I execute a Transact SQL stored procedure (actually in the database) on a SQL 2000 database from an AS/400 CL program.

    Jcorzine20 pointsBadges:
  • DBCC CHECKDB

    before runing DBCC CHECKDB WITH repair_allow_data_loss, How can i know what table and data that will be deleted

    Sreenu125 pointsBadges:
  • DATEDIFF – 1 year off

    I need to figure out age from a birthday. When I use the DATEDIFF function for year, the number of years is one year ahead if the birthday hasn't passed yet for this year. How can I get the accurate age based on the day and month of the birthday.

    Bananahead60 pointsBadges:
  • Drop Database Connections

    Hi,How can I drop all connections of a database through TSQL commands.(NOT SMO)

    Javad5 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