Search type Search syntax
Tags [tag]
Exact "words here"
Author user:1234
user:me (yours)
Score score:3 (3+)
score:0 (none)
Answers answers:3 (3+)
answers:0 (none)
isaccepted:yes
hasaccepted:no
inquestion:1234
Views views:250
Sections title:apples
body:"apples oranges"
URL url:"*.example.com"
Favorites infavorites:mine
infavorites:1234
Status closed:yes
duplicate:no
migrated:no
wiki:no
Types is:question
is:answer
Exclude -[tag]
-apples
For more details on advanced search visit our help page
Results tagged with Search options user 108119

All versions of Microsoft SQL Server (not MySQL). Please also add a version-specific tag, like sql-server-2016, since it is often relevant to the question.

0
votes
Try this: Remove a table/article from the subscription, go to Publisher properties. On the Articles tab, uncheck the tables (schema name are indicated there). Click OK then re-run the snapshot repli …
answered Jan 31 '18 by Edgar Allan Bayron
1
vote
2answers
On my understanding, regular run of DBCC CHECKDB is a best practice in order to check integrity of the database. If there comes a time where a corrupted page existed, and no good back up is available …
asked Aug 13 by Edgar Allan Bayron
0
votes
Just do this. Execute first the ALTER statement ALTER TABLE Intraday_Forecast_temp ADD IssueTimeUTC SMALLDATETIME Have it executed successfully then execute the UPDATE statement. UPDATE Intra …
answered Dec 14 '17 by Edgar Allan Bayron
2
votes
I need the result of the customers who did not buy in last month. That is from the order table Customer 3 and 4 have purchased in last month(November). The result should not include customer …
answered Dec 27 '17 by Edgar Allan Bayron
-1
votes
1answer
I used SELECT FILEPROPERTY('file_name', 'SpaceUsed'), and it returns NULL, what does it mean? I am correctly using it in the correct database. I cannot assume that NULL means empty since: I tried t …
asked Dec 29 '17 by Edgar Allan Bayron
0
votes
1answer
In my case wherein I have a file file_01.mdf and file_02.ndf under 1 filegroup, if ever file_01.mdf was already full (no autogrowth enabled), will it give me error on file_01.mdf if data is attempted …
asked Dec 29 '17 by Edgar Allan Bayron
1
vote
Replace CONVERT (VARCHAR(20), @Hoy1,108) fechaEntrada, CONVERT (VARCHAR(20), @Hoy2,108) fechaSalida, DATEDIFF(HOUR, fechaEntrada, fechaSalida) %24 AS horasAlDia with CONVERT (VARCHAR(20), Entra …
answered Jan 4 '18 by Edgar Allan Bayron
1
vote
1answer
This seems a simple question but is it still necessary to include a primary key with identity even if my columns are only a unique code and its description? CREATE TABLE table1 ( column1 INT NO …
asked Dec 7 '16 by Edgar Allan Bayron
0
votes
Node 2 needs to have SQL Server installed "with failover cluster" to be seen from node 1 configuration wizard.
answered Dec 22 '17 by Edgar Allan Bayron
8
votes
This is the only thing I could think of. You could try this as a basis: DECLARE @p1 DECIMAL(12, 9), @p2 DECIMAL(12, 9), @p3 DECIMAL(12, 9), @p4 DECIMAL(12, 9) ; SELECT @p1 = latitude …
answered Jan 19 '18 by Edgar Allan Bayron
0
votes
1answer
Have anyone experienced this? String or binary data would be truncated Raised during ALTER INDEX; even in CREATE TABLE. I'm not having this problem in other databases. I may have reconfigured so …
asked Mar 9 '18 by Edgar Allan Bayron
-1
votes
1answer
Is there a way to call a stored procedure with an input and output parameters? I tried to run one but it gives me different errors depending on the order of the parameters. See below: DECLARE @Linke …
asked Jun 4 '18 by Edgar Allan Bayron
3
votes
You can use table variables DECLARE @sqlq TABLE ( adc VARCHAR(100) ) INSERT INTO @sqlq VALUES (21); INSERT INTO @sqlq VALUES (23); SELECT * FROM TBL1 WHERE adc IN (SELECT adc FROM @sqlsq)
answered Oct 31 '16 by Edgar Allan Bayron
1
vote
1answer
I would like to achieve the following: Users log into a web app, using their credentials from the users table. After inserting a row into the inserttest table, a trigger activates in which it create …
asked Oct 15 '16 by Edgar Allan Bayron
2
votes
It is not possible to grant TRUNCATE without granting ALTER to the user. Though you can have a work around by granting DELETE to the user.
answered Dec 12 '17 by Edgar Allan Bayron

15 30 50 per page