Topics
Started by
Posts
Last post
Hi, I want to restrict users from adding duplicate rows. Is there a way to put one constraint on mu…
4 replies
Hi everyone! (My first post, so I hope it's the right board) So I got a bit of code for what I'm tr…
4 replies
I was wondering if someone could give me some good examples or explanations of why I would use the …
2 replies
The following code gives these results: SELECT * FROM tblEmployee; SELECT * FROM tblDepartment; &…
6 replies
Scenario 1 works just fine DECLARE @XMLT XML = '<Header> <ReportDate>10032017</Repor…
2 replies
Hi we have a test rig for proving our code can work on sql server 2019. It's legacy code and is too…
5 replies
Hi there I am re-writing some code which uses regular expressions Part of the code uses the …
1 replies
Hello All, Glad to have found this board. I have a VB Script that is exporting a query to an excel …
6 replies
When you run an inline or a multi-statement table-valued function, either type of function will ret…
3 replies
For a query that consists of two or more tables you can use UPDATE but not INSERT INTO or DELETE (p…
17 replies
Hi, I am having the following query to fetch day & year of a particular date. Need to fetch Qua…
10 replies
Hi all, Design question for you, if I may. If you had a SQL 2019 DB that was storing documents in a…
6 replies
Hi All, I have a ragged hierarchy table I need to flatten. So not every level have a child or paren…
8 replies
A friend of mine asked me a really interesting question... Imagine a flight path (I guess a linestr…
3 replies
I have a situation where SQL Server should throw an error but, instead, returns an incorrect result…
7 replies
Viewing 15 topics - 1,711 through 1,725 (of 1,790 total)
You must be logged in to create new topics.