Viewing 15 posts - 286 through 300 (of 506 total)
Take a look here.
HTH
February 21, 2018 at 9:46 am
Post create DDL statements for the objects involved with sample data in the form of insert statements and someone will likely give it a shot.
February 20, 2018 at 2:09 pm
take a look here.
February 20, 2018 at 11:28 am
No, you could create a staging table by using the import wizard, save the package to the file system tweak as necessary in SSDT to insert or update the columns you care...
February 14, 2018 at 10:54 am
You could do in in a merge however you may want to consider this: ALTER TABLE dbTable ADD DateCreated datetime CONSTRAINT DFdbTableDateCreated DEFAULT GetDate()
February 14, 2018 at 10:23 am
SELECT DataLength(textColumn) DLength
order by DataLength(textColumn) DESC;February 9, 2018 at 10:43 am
What is the data type of the column containing the large amount of text?
February 9, 2018 at 9:34 am
February 6, 2018 at 1:27 pm
February 5, 2018 at 1:40 pm
You need to run it under a domain account with adequate permissions to access the required share on the domain.
February 5, 2018 at 11:41 am
Try doing both in a single transaction:
begin tran
delete tbl1 where ...
delete tbl2 where...
commit;
February 1, 2018 at 3:16 pm
Please post a script that creates a table, temp table or table variable with insert statement(s) of sample data, what you've tried and desired output.
February 1, 2018 at 3:13 pm
Are you running on a Windows Domain?
February 1, 2018 at 2:33 pm
Viewing 15 posts - 286 through 300 (of 506 total)