Viewing 15 topics - 268,141 through 268,155 (of 283,876 total)
Topics
Started by
Posts
Last post
hi, i am writing a trigger CREATE TRIGGER Ztrig ON TZ FOR INSERT AS BEGIN INSERT TY VALUES (…
1 replies
Whenever I try to run the job through Database Maintenance Plan and it does not run at all. And If …
26 replies
Is there a way to DROP all my foreign key constraints and then to RE-CREATE them (as I cannot use t…
7 replies
Hi DBA's, I got an issue when website is supporting multiple collations. BA need to include UTF-8 f…
1 replies
We're buying a new server and EMC wants to make me a "deal we can't refuse". We are getting a 32G C…
3 replies
Hi, Setting Identity columns for a transaction table is correct? Thanks in advance Jag
4 replies
I have created a trigger using SQL Query Analyser. For modification I open SQL Enterprises Manager …
2 replies
I am trying to get the time value in a 'hh:mm:ss am/pm' format from the getdate() function, can any…
11 replies
Hi guys, I think it is a bad idea to set identity option for a column in a table(master table/trans…
1 replies
Dear friends, Let say i have 500 sales records with four salespersons, SP1= 100 sales records SP2= …
6 replies
SELECT x,y,z FROM A LEFT JOIN B AS b1 LEFT JOIN B AS b2 WHERE condition ORDER BY A.h this is a ske…
3 replies
According to BOL under DBCC CHECKIDENT: "If the value of new_reseed_value is less than the maximum …
3 replies
I would like to know a script that will generate random no of records based on a specified criteria
1 replies
Select * from information_schema.tables The above query is working fine, But when i describe the sa…
4 replies
I have a XML query that is returning a long XML formatted string that seems to exceed the byte size…
2 replies
Viewing 15 topics - 268,141 through 268,155 (of 283,876 total)