In case you need to use the designer, the time out settings are under the Designers, not SQL Server.

Is this what you are looking for?

--Test table

--Test table

DECLARE @sometable TABLE (ID INT IDENTITY(1,1), Value VARCHAR(10))

INSERT INTO @sometable(Value)VALUES

(NULL),('ValueB'),('ValueC'),('ValueD'),('ValueE')

--1st value is null

SELECT * FROM @sometable

--pick the top 1 which has a...

Not sure if this answers your question.

The Text values should be within quotes anyways, compared to integers or numeric fields for SQL. Your delimiter though should be distinct, you can...

I used the CAST to convert any Text or VARCHAR(MAX) data types, seems to work without errors for me.

DECLARE @TableName AS sysname;

DECLARE @ColName AS sysname;

DECLARE @sql AS NVARCHAR(4000);

DECLARE...

I agree Tim. For those who don't find use to a particular article, you may as well not rate it. For me, although I am not going to use this...

Can you try this?

CREATE PROCEDURE dbo.GetDetails ( @AccountID NVARCHAR(10) = '', @Name NVARCHAR(20) = '' )

AS

SELECT *

FROM StudentBankDetails SDB

...

Can you create a Temporary table and insert all the records into the temporary table and remove duplicates using the CTEs (Common Table Expressions)?

CREATE TABLE #employee (RowID INT IDENTITY(1,1), Country...

If there are no nulls in the data, your query will work fine.

However, if there are any nulls in the country field, it will ignore that in your results. Try...

Hi David

What is the DB recovery setting? Simple or Full? Although production databases are NOT meant to have this setting to simple, since you mention historical databases, this setting may...

Hi Steve

I did try that too, but the @@SERVERNAME returns the source server and the view created in the subscriber returns the subscription server. The view itself will fetch...

Not sure if you already looked at this article in MSDN.

https://msdn.microsoft.com/en-us/library/ms188038.aspx