Search Results
| 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 |
| Code | code:"if (foo != bar)" |
| Sections |
title:apples body:"apples oranges" |
| URL | url:"*.example.com" |
| Saves | in:saves |
| 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 sql-server
Search options not deleted
user 746
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.
3
votes
3
answers
81
views
Listing Non-Record
I have two tables.
1st table:
called kimlik
id ad
---------------
1 ahmet
2 mehmet
3 ali
2nd table:
called siparis
id kimlikid tarih …
- 1,106
1
vote
1
answer
163
views
Sql DateDiff Question
Select distinct DATEDIFF(ww, GETDATE(), siparis_test) AS Hafta
The first day of week is sunday in the above function. How can I change it so that monday is the first day?
Thanks in advance.
- 1,106
2
votes
1
answer
15k
views
SQL query to convert columns into rows
I have a table as shown below.My question is:How can I convert columns into rows?BTW,I'm using Microsoft SQL Server 2005.
my input Data
ONAY_ID sip_RECno KULLANICI ONAY
1 1 …
- 1,106
1
vote
3
answers
25k
views
SQL Server - Login failed. The login is from an untrusted domain and cannot be used with Win... [duplicate]
I am getting below error while trying to connect SQL from remote server. Local login is working fine. Can anyone help on this. Thanks in advance.
"Login failed. The login is from an untrusted domain a …
- 1,106
4
votes
1
answer
2k
views
Sql 2000 attach Error 5172
When I attach a database file from SQL Server 2000 Standard Edition to SQL Server 2000 Database on another machine ,
I am receive the following error.
"Error 5172: The heather for file 'D:...' is n …
- 1,106
0
votes
1
answer
264
views
Grouping stock in 6 month ranges
I have been pulling the total stock within the first 6 months. How can I pull the total stock within the last 6 months in the same query?
Also I want the result of the query as shown below:
Stock …
- 1,106
2
votes
1
answer
113
views
Full Text Search in SQL 2008
When I attempt to search in the full-text catalog which is my created earlier, I haven't been finding any word within database.
For example:
My word: Where
CONTAINSTABLE(TABLO,*,' "*Where*" ')
H …
- 1,106
2
votes
1
answer
211
views
Is it require to fill all tables inside of the database?
Now,I created upper that table and in order to test I will give 3 textboxes values as below.
SqlCommand cmd = new SqlCommand
("Insert Into dbo.PrnInf(PrnName, PrnSurName, PrnEgn ) Values
('"+t …
- 1,106
0
votes
0
answers
36
views
SQL - AD Security Group name changing in AD, effects?
I have been granting the permissions within SQL Server to an AD Group(Server-Level). If I change an AD security group name from "companyA_SQL_Server_DBA_Users" to "companyB_SQL_Server_DBA_Users". Wil …
- 1,106
2
votes
1
answer
1k
views
Cartesian Product SQL / Inserts with multiple Values Clauses
I want to create cartesian product sql query.But,I'm getting the error.Where I wrong?
alter table #Personel
(
Ad varchar(100)
)
alter table #Masa
(
MasaAdi varchar(100)
)
insert into #Personel val …
- 1,106
2
votes
1
answer
170
views
Duplicate record problem
create table #Personel
(
Ad varchar(100)
)
create table #Masa
(
MasaAdi varchar(100)
)
insert into #Personel values('deneme1')
insert into #Personel values('deneme2')
insert into #Personel values('d …
- 1,106
0
votes
2
answers
13k
views
Hide column if any value is null or zero via proc sql or view [closed]
Given either of the two following datasets
Kağıt Cinsi Sarı Yeşil Mavi
Kalın 4 0 5
İnce null 0 3
or
Kağıt Cinsi …
- 1,106
0
votes
0
answers
34
views
Security Updates for Microsoft SQL Server OLE DB Driver
Actually I have silly question. If I install below update during working hours then is it occurring any interrupt ? Also I have checked release notes. But I couldn't find anything.
Security Updates fo …
- 1,106
1
vote
2
answers
13k
views
SQL Server 2019 Always On - Ensure that cluster name object (CNO) is granted permissions to ...
I have here a SQL Server 2019 Always On with a lot of errors like this one:
2 nodes configured in a cluster with file share witness.
Cluster name: SQLCLS
Listener name: SQLLSN
Event:
Cluster network …
- 1,106
20
votes
7
answers
118k
views
How to drop multiple tables with common prefix in one query?
I'm using Microsoft SQL Server 2008.My question is:How to drop multiple tables with common prefix in one query?
something like that table names:
LG_001_01_STLINE,
LG_001_02_STFICHE
- 1,106