Topics
Started by
Posts
Last post
Hello experts, First - apologies if this post appears twice. I tried to the edit the SQL code sampl…
3 replies
Hi all I've got a stored procedure that runs on a schedule. It generates some dynamic SQL ba…
8 replies
For example if i run this: BEGIN TRY EXEC msdb.dbo.sp_help_job @job_name = 'foobar',@job_aspect = '…
3 replies
I have a situation whereas I need to include a column that is nonexistent in the table(s). The pri…
2 replies
Sorry just realised I didn't need to do this. moderator, please could you delete? Th…
1 replies
Right using t-sql 2016, in sql server management studio. I can change the fonts by picking options-…
2 replies
"Getting "Error converting data type varchar to numeric." in Table variable(@TableData) but not in …
3 replies
Hello Team, I am having a SQL view(having 600 columns). From last 5 years it is working fine but su…
2 replies
Hi DBAs, I have a performance issue with one hierarchy processing related query. Here is the scenar…
8 replies
Hi Team, my existing data like below: create table #test ( type1 varchar(100) ) insert into #test s…
5 replies
I have start_date, end_date and attended_day. I need to convert the attended_day e.g. "Wednesday" t…
6 replies
SQL Server 2014 Thought this may be useful to others so posting it in the fourm. I didnt find an op…
4 replies
Hi , I have a table where 10000+ pdf stored in table as varbinary(max) How to convert them with T …
1 replies
We have some TXT file imports into SQL tables. As a default, the columns are set to varchar(500) to…
6 replies
Is there a simple way to take the results of a query that have been converted to xml with FOR XML …
1 replies
Viewing 15 topics - 1,441 through 1,455 (of 3,093 total)
You must be logged in to create new topics.