Topics
Started by
Posts
Last post
Hi!While ago, I had a lot of fun solving the sql-ex.ru queries. Moreover, seeing how other solved t…
7 replies
HeyI am trying to read JSON data into SQL.With a "flat" JSON file,no problem.SELECT * FROM OPENJSON…
1 replies
Hi Everyone! This one's a bit strange so bear with me: I'm seeing extreme insert performance degrad…
5 replies
The first block of code is from another website. Here the CHECK constraint is supposed t…
8 replies
Hi!! Here's the thing - I have the following scenario: Base points - Multiple teams work on the sam…
18 replies
Hi, I wanted to compare 3 variables and set a flag if any of the three differ .. i.e. including han…
17 replies
Hi, I have a table with column [CustomerID] [int] IDENTITY(1,1).I would like to create a fixed widt…
2 replies
I know I can get a list of indexes on a table by using SP_HELPINDEX orSYS.INDEXES. But suppos…
1 replies
I've been reading through the many "forecast" keyword articles and forum posts here to see if I can…
8 replies
I am adding a check constraint to the BuildingNumber column in a table called Departments as a tabl…
4 replies
I have seen developers or DBA' s using Cross apply operator?What case it needs to be used and when …
2 replies
https://docs.microsoft.com/en-us/sql/t-sql/statements/create-table-transact-sql?view=sql-server-201…
7 replies
Hey All,Hoping to draw on some of the expertise on here! Currently struggling to translate the foll…
1 replies
The website below says that @@TRANCOUNT is a function. But I read somewhere else that @…
3 replies
Hi Sir, How to Init-cap the characters in SQL server in SQL query without creating any function? cr…
21 replies
Viewing 15 topics - 1,171 through 1,185 (of 1,537 total)
You must be logged in to create new topics.