Viewing 15 posts - 4,741 through 4,755 (of 13,877 total)
February 5, 2018 at 2:48 pm
February 5, 2018 at 2:43 pm
While I am sure that there are good reasons for doing so on occasions, including DDL to modify your database schema within a stored procedure is not best practice. For...
February 5, 2018 at 10:39 am
February 5, 2018 at 9:12 am
February 5, 2018 at 9:08 am
Can you try changing the connections from project level to package level?
February 5, 2018 at 3:29 am
You posted in the SQL Server 2017 forum. In 2017, Lead is a true SQL function ?
January 31, 2018 at 3:09 pm
UniqueID
Sequence
BeforeStatus
AfterStatus
HistoryStatusDate
Sample data looks like :...
January 31, 2018 at 1:50 pm
This sort of thing should work:CREATE PROCEDURE pr_Prize_Winner
AS
SET NOCOUNT ON;
DECLARE @User_Id INT = (
SELECT TOP 1
u.User_ID
...
January 30, 2018 at 11:28 am
January 30, 2018 at 7:31 am
January 30, 2018 at 7:29 am
Before you go ahead with this, are you aware of possible issues with shrinking databases?
You may like to read here for more information.
January 30, 2018 at 7:13 am
I need some help with a project we are working on.
I have a table containing...
January 30, 2018 at 6:57 am
Does anyone know if the latest version of SSDT designer (15.5.1)supports 64 bit providers? ...
January 30, 2018 at 6:49 am
Viewing 15 posts - 4,741 through 4,755 (of 13,877 total)