Topics
Started by
Posts
Last post
Hi All I was wondering what would be the easiest way run a UPDATE statement on a column where the c…
1 replies
For some reason I am getting the error "FOR UPDATE cannot be specified on a READ ONLY cursor." Doe…
23 replies
First off, apologies if this has already been asked, I can only get the search facility to return t…
10 replies
I've got a varchar variable of indeterminate length which I need to break up into chunks of no more…
3 replies
Hi, I am working on this select query for a report on website users. The resulting rows will be dis…
3 replies
Via T-SQL, how could I find the file name of the database (name.mdf). I am particularly inter…
4 replies
Can we drop a column from a table which is being referenced from another table(When cascade delete …
2 replies
Hello, I want to utilize a stored procedure that will accept a string variable that I will pass fro…
5 replies
I need to Rank the results of a query the same way I can Rank records in an Excel spreadsheet. In E…
17 replies
How to find the size of a table in a database? I have a huge size database and i would like to know…
3 replies
Hi I have a problem I need to read in an mail attachment with XP_mail I tried to bulk insert the at…
1 replies
Good day, I have a staging table, mc_staging, that has 6 columns (item, branch, month, source, inv_…
3 replies
Hey guys how can i use the "like" in a Case statement? thx much
6 replies
This is driving me crazy and makes no sense and wanted to see if anyone else has come across this a…
6 replies
Hi , i need help on that .i have a stored procedure which works fine,the only thing i …
6 replies
Viewing 15 topics - 4,576 through 4,590 (of 17,082 total)
You must be logged in to create new topics.