Topics
Started by
Posts
Last post
I need to send the 'ORDER BY' expression in a variable. Basically here's what I'm trying to do, thi…
10 replies
Hi all!! I am writing simple test scripts to see if columns and constraints were created. I know t…
2 replies
I am having a few issues properly passing my parameters to sp_executesql. I have a loop that goes …
6 replies
given a sales table defined as: CREATE TABLE [dbo].[t_sales]( [sales_id] [int] IDENTITY(1,1) NOT N…
1 replies
Disclaimer: I still feel like a newbie so please go easy. I extracted the TSQL code out of our dat…
2 replies
How can i insert into Blob field which contains 15mb of data for each row, without locking the tabl…
3 replies
Hi All, I have a txt file with 106 columns and 34 mil rows....I want to import it into SQL server 2…
11 replies
We have a workflow management app, which tracks the status of insurance applications, and records t…
12 replies
Query 1 Update DIRXMLUSER SET JOBTITLE = (SELECT SHEET1$.[JOB TITLE] FROM SHEET1$) S WHER…
4 replies
I need a query where i can group by OfficeName and also a count of them. example: EMpid Empname …
2 replies
example value is 1195507770 which shows in the app as 11/19/2007 03:29 pm And how do I convert it t…
19 replies
how can i get only year from a datetiem datatype. I need only year from this 2003-01-13 00:00:00.000
2 replies
I need to use QA to format a field (char, 14) of phone numbers to insert brackets around the area c…
1 replies
Is something like this even possible? If my field is longer than 3 (varchar field), I want to use t…
2 replies
Hi, I have one senario. I have to merge more than one row into a single row. I also found a solutio…
2 replies
Viewing 15 topics - 2,716 through 2,730 (of 17,082 total)
You must be logged in to create new topics.