I have an SSIS package that has 27 steps, ranging from table truncating, 开发者_如何学Cto data importation,transformation, and a bunch of sql queries. My question is, is it better practice to keep the
I have the following stored procedure to retrieve a new datetime: CREATE PROCEDURE [dbo].[GetTransactionTime]
Closed. This question needs details or clarity. It is not currently accepting answers. Want to improve this question? Add details and clarify the problem by editing this post.
I am building a SQL Server 2005 Integration Services package to migrate data from a Sybase Adaptive Server Enterprise 12.5.4 database to a SQL Server 2005 Database.The Sybase Database is the backend f
Hi I have a adp/SQL project running with my db. Everything is ok but is there a way to customize error messages.
I am exploring a legacy database system and have very little knowledge of its internals. I would like to find all the stored procedures that invoke another stored proce开发者_开发技巧dure A.
I\'ve been trying, googling and hitting my head against the wall but can\'t figure our what the problem is or how to solve it.
because i\'ve recognized locks on tables that are queried simultaneously, i\'ve decided to enable ISOLATION LEVEL SNAPSHOT that was new to me.
I have altered the column datatype in one of my tables from int to decimal. I have a UDF referencing the columns of this table.
I want to capture Radio button values in db so i created table with datatype bit But the problem when am create stored Procedure as
加载中,请稍侯......