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.