Topics
Started by
Posts
Last post
I have a database with over 10,000 tables and about 200 of those tables have cascade deletes turned…
8 replies
Hi expert, I need to create a update trigger, when there's any update to the ta…
2 replies
Hello everyone, I am using xp_cmdshell and BCP to load a comma separated file containing 3 columns:…
2 replies
In SQL editor, what will be the result of this query Select 100/3 Will it be A)&nbs…
5 replies
Hello all, I haven't used the READ UNCOMMITTED transaction isolation level before, and I was wonder…
1 replies
I am a beginner in SQL sp's. I have a 'simple' question. The table: id …
8 replies
Hello all, I've been a lurker here for a while and have appreciated solutions found here. But…
2 replies
Hi there, I want to insert ~50,000 records (all in one go) using store proc and passing p…
4 replies
Hello folks. I've spent a few hours trying to suss this one out to no avail. There are lost of art…
13 replies
There is a view based on a single table. The table has a mixture of data types for the columns. The…
3 replies
I have an AS400 DB2 table with 3.6 million rows with an index setup on it. I have set it up a…
1 replies
Hi Friends, I m confused about whether to use IsNull() Function or wether I can simply use @va…
3 replies
Hello, I have made a view which I am selecting records from 9 tables, one of which is a DATETIME f…
6 replies
i have made this query: SELECT DISTINCT BID,Regnr,ANavn,GjelderFra,SiOppForsikringFra,Aktiv, CASE W…
44 replies
Hi All, I hope somebody can help me. I am trying to set a variable inside some dynamic sql. The fol…
8 replies
Viewing 15 topics - 11,746 through 11,760 (of 17,082 total)
You must be logged in to create new topics.