Topics
Started by
Posts
Last post
exec master.dbo.xp_getnetname returns computer name the db is on. How can I set the result to a lo…
10 replies
Does anyone know how to search multiple tables with the same column name. For example if I have tab…
5 replies
I am currently using this store proc to get columns information : SP_MsHelpColumns because with thi…
1 replies
Hi all I have a stored proc, create a temporary local table, and want to index it before attempting…
6 replies
Hi all, I have a strange issue in one st proc that I'll call "master". This procedure makes call…
2 replies
If a table T1 has 800 MB data with about 300,000 records. I need to purge this table without using …
3 replies
How can I drop a foreign key with T-SQL?
1 replies
I need to create and drop triggers on specified table as and when the user turns auditing on and of…
2 replies
I'm having an error with a procedure. There is a parameter with datatype int (@ethnicity int=null) …
1 replies
I know this a simple one, but I can't make to work. This is the case: I have a few tables in which …
5 replies
I'm certain this shouldn't be so difficult to find but, alas, I don't seem to be able to figure thi…
4 replies
I have a table in a SQL2K database. I want to keep a record of what user has run a SELECT query on…
6 replies
Hi, I have set up a trigger on a table for handling data versioning. I am trying to make it as gene…
2 replies
Which of the following SQL Statements is more efficient? A) SELECT * FROM PRODUCTS WHERE PRODUCT_DA…
1 replies
Are we able to declare global variables? I am building a dynamic SQL statement and I want to use t…
1 replies
Viewing 15 topics - 16,336 through 16,350 (of 17,082 total)
You must be logged in to create new topics.