SQL Server is a relational database management system from Microsoft. Use this tag for all SQL Server editions including Compact, Express, Azure, FastTrack and PDW.
0
votes
0answers
3 views
Selecting Data from a column where NULLs and strings exist
Hi i have a query that appears to be pulling in 'Not Set' twice:
Now after a few checks i know it is because the currentstage column has NULLS and the string 'Not Set'stored in the table. So below ...
2
votes
1answer
19 views
Checking availability of data in columns of table in SQL?
Iam having table TestTable where i have few columns say
C1 | C2 | C3 | c4
'ab'| 1 | 09 | //CASE1 [ must return 1]
| | | //CASE2 [ ...
2
votes
0answers
13 views
sql server- When does table get locked when updating with join
Suppose my update query looks like the following:
UPDATE a SET
a.colSomething= 1
FROM tableA a WITH (NOLOCK)
INNER JOIN tableB b WITH (NOLOCK)
ON a.colA= b.colB
INNER JOIN tableC c WITH ...
0
votes
0answers
6 views
How to send parameter of a report to another? SSRS
I have 3 reports, one general, one synthetic and one graph, they have the same paramentros and each has a link to another, how can I send the parameter chosen in a report and click the link to send ...
-5
votes
4answers
38 views
Delete a single record from Entity Framework?
How to delete a single record from employ table using Entity Framework?
0
votes
1answer
38 views
how to minimize multiple subqueries?
I have the following query that is a bit slow, as you can see there are a couple of nested queries in the where clause, can anyone come up with a better solution?
SELECT m.briefmedialist,
...
0
votes
1answer
10 views
How to Ignoring errors in Trigger and Perform respective operation in MS SQL Server
I have create AFTER INSERT TRIGGER
Now if any case if error occur while executing Trigger. It should not effect Insert Operation on Triggered table.
in One word if any ERROR occur in trigger it ...
-3
votes
0answers
18 views
tricky code and output for interview with answer
I want code related tricky questions for interview. where should i get that?
I want to set tricky questionshit for hiring. code with output or objective type also welcome
0
votes
0answers
17 views
How to import an XML file into SQL Server 2012
I have an XML file that I want to import into SQL Server 2012. I haven't done it before and I don't know a lot. After some research, I tried to open the xml file with the following command that was ...
0
votes
0answers
5 views
How to remove link navigation? SSRS
Caros,
Como posso remover o link de navegação de pasta no superior da pagina? Eu preciso remover por solicitação da minha gestao![enter image description here][1]
0
votes
1answer
12 views
Tools for migrating database from sqlserver to postgres
I am looking for some good tools for migrating database. Migrating from sqlserver to postgres database.
Any Help :)
2
votes
3answers
45 views
SQL Select only the words that are in Capital
I have for example an a column that starts with string values in capital letters and then continues in lower case:
THIS SENTENCE IS IN UPPERCASE and this in lower case
Is there any way to select ...
0
votes
0answers
5 views
SQL Server Replication
I need to perform replication on MS SQL Server 2005 Standard Edition. The goal is, that I have several databases (for example 4 instances of SQL Server) and each must act as publisher to other sites. ...
0
votes
1answer
11 views
DBCC CHECKDB to check errors in SQL Server database
Is it possible to run: DBCC CHECKDB on a specific table in SQL Server 2005 database?
I have the following syntax:
DBCC CHECKDB
[
[ ( database_name | database_id | 0
[ , NOINDEX
...
0
votes
0answers
13 views
How to do a aggregated lookup in a grouped columns
How do i aggregate the totals of the columns monthly. Please the example
June 30
name column1 column2 column..n AggregatedTotalPerMonth(columns..n)
john 10 ...
