Topics
Started by
Posts
Last post
I regularly have to import text files into a table. One problem that I have run into is the Name c…
9 replies
Greetings, I have a database that is locking when a batch of T-SQL runs. This sql batch has begin t…
3 replies
Hi all, I have created the following trigger. CREATE TRIGGER dbo.HRUpdate ON Employee FOR INSERT, U…
6 replies
Which of the commands below has better performance in Sql Server 2000 1) If Not Exists(Select Cli…
1 replies
I have a routine that uses datediff to return the number of seconds (ss) between the start and fini…
4 replies
SELECT MAX(month_end),sum(num_units) from active_Units_Static where month_end >= '1/1/2002' and …
8 replies
Hi, Is there any way to use T-SQl to change the column ORDER of a table. eg tblWronglyOrdered colum…
10 replies
I have a table that looks like this: SubID PubID SubjectText 1486281594714Domestic fiction. 1…
3 replies
I have to do backups of production database and restore them on the backup server. The database sh…
2 replies
I Have a concatenation Problem. I have a table That captures notes from users input. ID Field is a …
2 replies
Hi I wanted to link tow servers a and b.After linking the server I could access the objects of the …
2 replies
I am running the statement exec xp_cmdshell 'copy /Y \\servername\sharename\file d:\directoryname' …
3 replies
How can I use bcp to output multiple result sets to a csv file. That is running several select * fr…
4 replies
I have a table with a full text indexed column called txt. I am trying to develop a simple web sear…
4 replies
Supposed I have table as the following script : CREATE TABLE TCourseTaken ( Year smallint, Course…
8 replies
Viewing 15 topics - 14,011 through 14,025 (of 17,082 total)
You must be logged in to create new topics.