Viewing 15 posts - 4,261 through 4,275 (of 13,855 total)
July 12, 2018 at 10:48 am
Instead of
Alter table [invoice.invoice]
try
Alter table invoice.invoice
Those square brackets around the schema.table might be the issue.
July 12, 2018 at 8:57 am
What is the result of running the GRANT statement on its own?
July 12, 2018 at 8:07 am
July 12, 2018 at 5:48 am
if not exists (select 1 from TableA)
return;
Should exit the proc at that point, if zero rows are found.
July 11, 2018 at 6:56 am
Need sql query help.
create table test
(
PropertyType varchar(100),
PropertyName varchar(100),
PropertyValue varchar(100),
)
insert into test...
July 11, 2018 at 5:28 am
In my table pp table is there.pp table having isactive field .
if i set isactive...
July 10, 2018 at 2:00 pm
July 10, 2018 at 12:56 pm
July 10, 2018 at 11:51 am
It would seem that you'd be able to get this working using SSIS (for example).
Here is a sample link showing how to access e-mail messages using C#....
July 10, 2018 at 11:24 am
This is strange syntax:
... convert(char(6), 112) = 201806
Shouldn't there be a column name in there somewhere?
Also, if you are converting to char, you should put quotes around...
July 10, 2018 at 8:12 am
July 10, 2018 at 6:28 am
Can you create INSERT statements for your sample data, please? Then people will be able to run your CREATE TABLE, then the INSERT and they'll have something which they can...
July 10, 2018 at 6:24 am
July 9, 2018 at 1:23 pm
Viewing 15 posts - 4,261 through 4,275 (of 13,855 total)