@igaytwanb,

With so little claimed knowledge on your part, I'm going to direct you to a tool that has help many both with and without experience.  It's not a magic fix......

Hello everyone!

I am in dire need of some assistance or direction. I am by no means a expert at any of this stuff. Unfortunately for me the company I...

I work on sql server 2019 i have table have 20 milion rows .

i need to export data Exist on table to only one file by using sql server...

Just a few more tests on the function you posted.  Haven't done a deep dive on your code but, at first blush, it would appear that it doesn't like working...

You do realize that's not going to find any job that executes a stored procedure that executes xp_CmdShell, correct?

This sounds a bit...

Thank you for the kind feedback and the functions, Eirikur.

Perhaps I'm using the function incorrectly but try the following (and, if so, please let me know)...

 SELECT...

I would use an SSMS add-in like ApexSQL Refactor.

There is a free version of it here https://en.freedownloadmanager.org/Windows-PC/ApexSQL-Refactor-FREE.html

I think you only get a trial period with...

2. That kinda makes me want to build a query that recursively uses sys.sql_expression_dependencies joined sys.sql_modules to find all schema binding objects that are binding an object and...

Since the OP never came back on this, let me be a bit more succinct... it's STUPID to do this without knowing the ramifications it will have...

The key here is to realize the misnomer.  What you find in SSMS is NOT a full version of RegEx.  I'm not sure it even qualifies as a...

While there's likely no better way to do this, the trouble with something...

Since the OP never came back on this, let me be a bit more succinct... it's STUPID to do this without knowing the ramifications it will have for each...

You never came back with answers to my questions about the "autogrow" settings and version of SQL Server.   Did you ever get this issue figured out?

Fast Inserts Issue?

If it's still...

The key here is to realize the misnomer.  What you find in SSMS is NOT a full version of RegEx.  I'm not sure it even qualifies as a valid subset.

In the following snippet of your code, tell me why it won't just update the same 4999 rows forever?

--Update the BankName and BankBranch value in temp table
Declare...