Topics
Started by
Posts
Last post
Hi, A while back I recall reading a post on here where a user needed to update a column with values…
25 replies
Hello, I have the following code and the result set is coming out as nvarchar. So, when I create a …
3 replies
I am using Server 2012 and very new to SQL. I have a request from a physician for a list of his pat…
1 replies
I wrote this query, which runs nicely (under 1 second) and returns 4490 rows: select distinct t1.i…
4 replies
Hello everyone XML is killing me. It is my weekest point. I have another file that I should get int…
2 replies
Hi, I know that if I have an nvarchar column I can use an equality like = N'supersqlstring' so it d…
8 replies
Hi Experts, In one of our requirement, I want all the query details for the SQL query batch that g…
7 replies
I backed-up database A and restored it as B. I just realized that all the new USPs that I have cre…
1 replies
I'am running this and getting an error. Help appreciated DECLARE @trace_ID int , @path_file nvarcha…
1 replies
I am trying to use xquery to get event data back from extended events. My xquery skills are horrib…
3 replies
One of our users said that our application has lost her data. It was from last week Thursday, 2/20/…
13 replies
I need the hex digits of a column, I had the code before but forgot it. EXAMPLE: SELECT COL1, COL1…
3 replies
Hello all, I am trying to update records based on the results of a query with a subquery. The res…
6 replies
I need to return multiple 'Start - End' dates in one row for company meetings. Example: [Company N…
7 replies
Been looking for more in-depth information on clustered-index views and how they work exactly. I kn…
4 replies
Viewing 15 topics - 4,261 through 4,275 (of 4,984 total)
You must be logged in to create new topics.