Topics
Started by
Posts
Last post
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
Hi, I have this query SELECT AIM.*FROM database1.dbo.vw_Customer C WITH(NOLOCK) &n…
3 replies
Hi,So first up this is not a 2017 issue but in fact is actually a 2019 CTP issue. I've been trying …
2 replies
Hi, We have Stored procedure to create the database using xp_cmpshell , it works fine i…
3 replies
Hello Everyone, I need help with the below. When I am trying to run the below query using CAS…
5 replies
In the documentation for CREATE TABLE (Transact-SQL), under check constraints, I see: A column ca…
23 replies
Hi,I wonder if there's a quick way to have the return value from an EXEC stored-procedure Stat…
3 replies
Viewing 15 topics - 1,156 through 1,170 (of 1,518 total)
You must be logged in to create new topics.