SQL Server Tag Directory

Featured SQL Server Questions

Set up retention policy for deleted items folder on Exchange 2007
How to set up retention policy for deleted item folder on exchange 2007? I would like to run the policy to empty the folder based on item age. Thank you.

Answer Question   |  April 3, 2014  5:18 PM
Data Retention Policy, Deleted Items Retention Policy, Exchange 2007, Exchange policy management, Standard Edition
asked by:
X4y
10 pts.

Import data from Access into SQL Server 2005
Hello, I have a large database on ms access with more than 100 tables. I am planning to do migrate this database into MS SQL Server 2005. I am receiving info into database access on a daily basis. So I have to do an auto job to import data from access into SQL Server 2005....

Answer Question   |  March 29, 2014  10:30 AM
Migration, SQL Server 2005, Stored Procedures
asked by:
77
15 pts.

How can I pass tablename as a parameter in MySQL stored procedure?
my SQL stored procedure is like this…. ALTER PROCEDURE [dbo].[Sp_InsertDataMaster] @_ImageID int, @_Stat bit, @_tablename nvarchar(200) AS begin declare @strTemp nvarchar(max) set @strTemp = ‘Insert into ‘ + @_tablename + ‘(ImageID,Status) values (‘+ convert(nvarchar(5),@_ImageID) +’,'+ CONVERT(nvarchar(1),@_Stat) +’)’ –print @strTemp exec(@strTemp) end I want this stored procedure in MYSQL.

Answer Question   |  January 23, 2014  8:38 AM
Database programming, MySQL, MySQL Stored Procedures, SQL, SQL stored procedures, Stored Procedures
asked by:
45 pts.

Locating default library in AS/400 with iSeries
I’m having trouble figuring out how to boot to the default library while connecting to an AS/400 stored procedure layer using the IBM iSeries Access for Windows package. This set-up works through.NET DLL with classes similar to those in the System.Data namespace, and therefore uses its connect class and connection string implementation.  That’s where I...

Answer Question   |  December 18, 2013  2:28 PM
iSeries AS/400, libraries, Stored Procedures
asked by:
54,900 pts.

I need help creating a delimitted string in DB2
Over the past few days, I’ve been trying to create a delimited string from the results of a query in DB2 on iSeries. I was able to do it in T-SQL but am struggling here. Here’s the code I used in T-SQL. I’m basically looking for the equivalent in DB2. DECLARE @a VARCHAR(1000) SELECT @a...

Answer Question   |  December 17, 2013  4:02 AM
DB2, iSeries, T-SQL
asked by:
54,900 pts.

Debugging stored procedures for DB2
Is there a tool for IBM DB2 similar to PL/SQL Developer where I can develop a debug stored procedures?

Answer Question   |  December 15, 2013  7:04 PM
DB2, Stored Procedures
asked by:
54,900 pts.

import excel data into multiple table through ssis
Hi All, currently i have requirement as i have import button on my front end application. when client click on that button it will browse the path of excel file and then import the data into table.remember that excel data need to fill into multiple tables.example i have 25 column of excel sheet and that...

Answer Question   |  November 27, 2013  3:20 PM
SSIS Package 2008
asked by:
5 pts.

SSIS 2008
I have a package with 5 data flow tasks and want to run them parallel. If any task fails, should the others still be executed and the task that failed, an email should be sent out.

Answer Question   |  October 28, 2013  7:52 PM
SSIS, SSIS 2008, SSIS Testing
asked by:
5 pts.

Row by Row Stored Procedure in SQL Server 2008 R2
Hi all, Hopefully someone will be able to help me here – I’m nearly there but can’t get it right, I’m trying to create a stored procedure that when it runs, it will do a query and then send send an email out for each of the rows that it returns. e.g. If I have...

Answer Question   |  October 25, 2013  1:36 PM
SQL, SQL Server 2008, SQL Server 2008 R2, SQL stored procedures, Stored Procedures
asked by:
65 pts.

SQL server 2008 provide access to SSIS
Client needs access to SSIS sql server 2008   Thanks, Evgenia

Answer Question   |  October 23, 2013  2:36 AM
SQL Server, SQL Server 2008, SSIS, SSIS database
asked by:
5 pts.

Exporting stored procedure results into an XML file in SQL Server
I need to export the result from a stored procedure into an XML file directly in SQL Server. How would I go about doing this?

Answer Question   |  October 22, 2013  3:25 PM
SQL Server, Stored Procedures, XML
2,585 pts.

Calling an Oracle stored procedure from SQL Server
Is it possible to call an Oracle stored procedure from SQL Server?

Answer Question   |  October 22, 2013  3:59 PM
Oracle, SQL Server, Stored Procedures
2,585 pts.

Calling a stored procedure in a SELECT list on SQL Server 2000
I am using SQL Server 2000, and my question is: is there any way to call a stored procedure in a SELECT list?

Answer Question   |  October 21, 2013  8:16 PM
SELECT statement, SQL Server 2000, SQL stored procedures, Stored Procedures
2,585 pts.

Auto filter of distinct values on columns in SQL Server Reporting Services?
Is there a way to have an auto filter of distinct values on columns in SQL Server Reporting Services?

Answer Question   |  October 18, 2013  6:13 PM
SQL Server Reporting Services, SSRS
2,585 pts.

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 accurate, and if not, how could I create this stored procedure?

Answer Question   |  October 17, 2013  7:21 PM
SQL Server stored procedures, Stored Procedures
2,585 pts.

How can I write a stored procedure to copy data from one database to another database on the same SQL Server, every weekend?
How can I write a stored procedure to copy data from one database to another database on the same SQL Server, every weekend?

Answer Question   |  October 15, 2013  11:39 PM
SQL Server, Stored Procedures
2,585 pts.

how can make this SQL Server query faster
All, how can I make this query faster? Here is my code of stored procedure: ALTER procedure [dbo].[GetLMPReport] ( @typeId tinyint, @dataType varchar(2), @date date ) AS begin select distinct p.name, ISNULL (td24.price, 0) as '00', ISNULL (td1.price, 0) as '100', ISNULL (td2.price, 0) as '200', ISNULL (td3.price, 0) as '300', ISNULL (td4.price, 0) as...

Answer Question   |  October 14, 2013  6:10 PM
SQL Query, SQL Server 2008, SQL stored procedures, T-SQL
asked by:
20 pts.

SQL Server 2000/2005 – Creating Unique Constraints allowing multiple NULLs
Hi there! I’m having a problem maintaining data integrity on a database table in MS SQL-Server 2000. To ensure maintaining the integrity I need to implement a Unique Constraint on one of my coloumns. The problem however is, that this coloumn also has to allow multiple NULL-values – but for every value in the coloumn...

Answer Question   |  October 14, 2013  4:13 AM
Desktops, Management, Microsoft Windows, OS, Security, Servers, SQL Server, T-SQL
asked by:
0 pts.

Looking for detailed synchronization logging in SQL Server 2008
We are in the process of performing a side-by-side upgrade from SQL Server 2000 to 2008 (Standard Edition in both versions). A merge publication is included in the upgrade, and it appears to be working fine on the new server, so there is no functional issue. However, I have grown accustomed to the detailed, timestamped...

Answer Question   |  October 14, 2013  2:57 PM
SQL Server 2000, SQL Server 2008, SQL Server replication, SQL Server synchronization, SQL Server upgrades, Upgrade from SQL Server 2000 to SQL Server 2008
asked by:
415 pts.

Did the Database Designer change for Visual Studio 2012?
I’ve recently installed Visual Studio and SQL Server 2012 onto my machine. I’ve noticed the Database Designer isn’t as ‘friendly’ as the old version. Here are some of the changes I’ve noticed: It creates .SQL scripts instead of automatically saving my changes. I have to update different things in T-SQL window instead of the Properties...

Answer Question   |  October 3, 2013  3:53 PM
SQL Server 2012, T-SQL, Visual Studio
asked by:
54,900 pts.

SQL Server Tags - Yuk to Yuk

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: