Topics
Started by
Posts
Last post
Hi, we use XACT_ABORT to rolback if statements failed. I have a scenario where I have a stored proc…
1 replies
Hi My problem is I have a view named Forecast with data in that looks like this: RowID Register…
10 replies
One of our developers sprung this on me and I have been trying to rethink it...because that OR clau…
2 replies
Our webiste has several contact forms which all go into the same table. We therefore have to create…
3 replies
Hi guys, I have one object which present 26 columns and in that object there are almost 1000+ rows …
7 replies
I am trying to build my where section on the fly... going to place this inside of a stored proc tha…
6 replies
Can someone please help me with this stored procedure. SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER O…
7 replies
if exists (select * from tempdb.dbo.sysobjects o where o.xtype in ('U') and o.id = object_id(N'te…
20 replies
Hi all, My SQL 'Table1' needs an update to a single column 'STCount'. The update needs to be applie…
2 replies
Hi Everybody, In our envirnoment we had logshipping database which is in suspect mode. when i res…
1 replies
Hello everyone I have a table with an ntext field that contains many tags of different types. I w…
12 replies
A developer showed me a very small sql server t-sql script he wrote (5 SQL lines). It loads informa…
7 replies
Hi, In my case I want to delete those data from tables Orders and customers which is not selecting …
24 replies
Hello everyone, I am running a statement: INSERT INTO LinkedServer.DBName.dbo.TableName (col1, col2…
3 replies
I am currently having below table and sample rows. CREATE TABLE ORDERS (Year int, Month int, ORDER…
3 replies
Viewing 15 topics - 1,021 through 1,035 (of 12,234 total)
You must be logged in to create new topics.
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy