• Creating stored procedures to execute tables at runtime on a SQL Server

    I’d like to execute different tables at runtime on my SQL Server by creating stored procedures. This is the syntax I am attempting to use: create procedure sp1(colname varchar(400), tab_name IN varchar2) AS BEGIN select * from '@TABLENAME' where CompanyName='@COLUMNNAME' end Is this syntax...

    SQL Server Ask the Experts2,585 pointsBadges:


    SQL Server Ask the Experts2,585 pointsBadges:
  • Restoring a SQL Server 2005 database from a public share backup

    Is it true that even in SQL Server 2005 you cannot restore a database from a backup on a public share, but ONLY from a local storage (DASD)drive?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Virtualizing a SQL Server cluster in a production environment

    What is Microsoft's official position in using virtualization (Virtual servers such as VMWare, etc.) for a SQL Server cluster (two node Active Passive) in a production environment? What are the best practices?

    SQL Server Ask the Experts2,585 pointsBadges:

    What is the difference between RAM and Cache Memory?

    SQL Server Ask the Experts2,585 pointsBadges:


    Beginner in IT5 pointsBadges:
  • Access rights in SQL Server 2005 users


    DetayMan5 pointsBadges:
  • Issues rebuilding system database on SQL Server Express 2005


    SQL Server Ask the Experts2,585 pointsBadges:
  • Read Excel from Sql Server 2005/2008 SQLEXPRESS

    How to read the excel data's from Sql Server 2005/2008 SQLEXPRESS

    Sridhar12350 pointsBadges:
  • shredding xml in sql server 2005

    In SQL Server 2005 one shreds XML via the nodes() method. When inserting into a table using this it preforms extremely slowly. If the "into #x" is removed the shredding is very fast. declare @x xml -- there are 1000 rows in the xml document set @xml = ' <rows> <row>...

    Skidancer5 pointsBadges:
  • SQL Server restore job fails


    TuftsDBA0 pointsBadges:
  • Upgrading from SQL Server 2000 SP3 to SQL Server 2000 SP4


    SQL Server Ask the Experts2,585 pointsBadges:
  • Mainframe access to SQL server data

    How can I access SQL server data from a mainframe COBOL program?

    Artisan5 pointsBadges:
  • What is the biggest way data centers can help with PCI?

    What is the biggest way data centers can help with PCI?

    Artsypal5 pointsBadges:
  • Changing the background color of a page in Microsoft Word 2010

    In Microsoft Word 2010, I can change the color of "all" my pages because of the Page Layout Tab. However, I'm looking to change the color of just a "single" page. Is there a way to do this?

    ITKE50,975 pointsBadges:
  • Invoice error


    jackie4610 pointsBadges:
  • How to build a career in IT if the person is from commerce field

    Hello, I'm from commerce but now I'm joining a course on software testing. Please suggest to me how I can build my knowledge in Software Testing and I'm also joined one software company as a trainee but I'm not fully knowledgeable yet. Please suggest to me on how to star my work. Thanks!

    seeds15 pointsBadges:
  • HTTP vs. http

    What is the difference between HTTP & http...or is there one? If there is no difference, why is it that one acronym is in lower case and the other in upper case? A very basic query, I realize.

    JanuaryGirl5 pointsBadges:
  • Update Data SQL Server From AS400


    JLH5 pointsBadges:
  • Looking to enter IT field


    Jackcarr205 pointsBadges:

Forgot Password


Your password has been sent to:

To follow this tag...


REGISTER or login:

Forgot Password?
