Topics
Started by
Posts
Last post
Hi, I just need a quick and dirty for dropping a foreign key constraint on a table. I don't want t…
4 replies
I have a table XXX with only 1 record and columns as col1 col2 col3 col4 col5 col6 col7 col…
14 replies
is it possible to add ON UPDATE CASCADE to existing table? I have tried a number of different combo…
1 replies
Colleagues; I have an interesting, multi-faceted challenge. Six months ago (as an IT contractor) I…
5 replies
Cany anyone explain to me why the query below does not work in SSMS 2005? Every time I run this I …
7 replies
How to export the results of the system stored procedure into text file. I tried bcp "xp_readerror…
4 replies
I was wondering if the datepart function could produce the format in yyyymmddhhnnss. Aslo, if not s…
4 replies
Hi, I need a query to list the Name, Sal and cumulative of the salary, in increasing order of Salar…
20 replies
I am working on someone else's code and came across a right outer join I am not familiar with. Basi…
4 replies
I have a stored procedure that is looping through a sequential tally table to grab date ranges DECL…
10 replies
I have a table Info with Name, address,Mob.No.,Designation as Columns. Some of the records in the t…
4 replies
SELECT O.ORDERID, c.FIRSTNAME, c.LASTNAME, '' AS CREDITCARDNUMBER, '' AS COUNTRY, 'Soundex' AS GR…
3 replies
exec master..xp_cmdshell 'bcp "SELECT au_fname, au_lname FROM pubs..authors ORDER BY au_lname" quer…
3 replies
I have exported data from a Sybase SQL Anywhere db table. Which I can successfully import into a S…
2 replies
I have two columns that have integer values. I would like to concatenate them as text and add them …
10 replies
Viewing 15 topics - 7,966 through 7,980 (of 12,234 total)
You must be logged in to create new topics.