Topics
Started by
Posts
Last post
I have a stored procedure that links 2 tables from separate databases (on the same server). When i …
2 replies
I want to have the following line set in a variable @s-2. select @table ='abc' like select @s-2 =…
5 replies
In Enterprise Manager 7.0 I know that you can see the size of the table when clicked on the databas…
5 replies
If i have a table A with X fields and i have an identical table B with the same fields, i wish to i…
7 replies
Hi, I have a table that contained about 1000 records. The table will use by VB application, and the…
1 replies
I tried using xp_sendmail to send an attachment and keep getting "attachment open failure" (not "no…
5 replies
I am trying to add a new column to every user table in my database. Does anyone know the script fo…
3 replies
The following query shows movements for each liability select t1.LiabilityID,t1.DateTimePassed,t1.P…
1 replies
I have a problem with text data type as a output parameter in stored procedures.Which data type can…
3 replies
I want to send an email to a user based on criteria in a table. Such as if TimeAcknow is greater th…
10 replies
I want to store the ouput of select * from <table> for xml auto,elements into a variable. Ac…
5 replies
Here is a port from the Oracle's TRANSLATE function to T-SQL. It gets three arguments: a string to …
6 replies
The log file for a database has grown to over 5 GB leaving less than 4 MB of hard disk space on my …
6 replies
Union works if the data type is compatible and the number and order of the field must be identical.…
4 replies
Hi, I am trying to figure out if a column exists in the system tables and if so to execute some cod…
6 replies
Viewing 15 topics - 16,966 through 16,980 (of 17,082 total)
You must be logged in to create new topics.