Viewing 15 posts - 976 through 990 (of 26,487 total)
You mean something like this?
DECLARE @SQLCommandTemplate NVARCHAR(MAX)
,@SQLCommand NVARCHAR(MAX)
,@inTable sysname
,@ObjectId INT
,@Table sysname
,@Schema sysname
,@Column sysname;
September 21, 2018 at 12:16 pm
I agree with Jonathon, this is a broad topic and not something that can be done in a forum thread. Once you start studying and you have specific questions or...
September 21, 2018 at 9:51 am
craig.jenkins - Friday, September 21, 2018 8:18 AMThanks guys much appreciated FORMAT(DateIn,N'MMM dd yyyy') works a treat
If you find this to be too...
September 21, 2018 at 9:42 am
September 21, 2018 at 8:10 am
Just a quick question.
Below I'm joining onto a table with a WHERE clause in...
September 20, 2018 at 3:05 pm
September 20, 2018 at 11:02 am
As it is a local temporary table and it is apparently created in the trigger (we don't have the code for the entire trigger so have to assume), once the...
September 20, 2018 at 10:24 am
September 20, 2018 at 10:20 am
September 20, 2018 at 10:09 am
The database has 895 tables, tables are queried...
September 20, 2018 at 10:02 am
Okay, not really sure where to post this so I think the water cooler is as good a place as any. My daughter needs ideas for a Big Data Project...
September 20, 2018 at 9:56 am
Of course, it may help to also see the update statement.
September 20, 2018 at 9:18 am
The best way is to have curated data that you use to test the procedure. These data sets would have a known set of values that you can use to...
September 20, 2018 at 9:14 am
Again, how many tables are being queried by one run of the script?
September 20, 2018 at 9:08 am
September 19, 2018 at 3:00 pm
Viewing 15 posts - 976 through 990 (of 26,487 total)