Topics
Started by
Posts
Last post
CREATE TABLE tblTestId ( id int, NAME VARCHAR(10) ); INSERT INTO tblTestId SELECT 1,'Empa' UNION AL…
5 replies
I have a data warehouse database which is set to simple recovery. The transaction log was original…
27 replies
I'm trying to write a trigger that will inform me via an email using sp_send_dbmail when a certain …
9 replies
I have a column in a table that has user names, user can appear in this table multiple time, but as…
3 replies
Hi, What happened if we run select statement i.e Select * from TableName; When we execute the above…
1 replies
Hi, I am getting the following error when I try to parse XML. declare @xml xml set @xml = '[Code]&l…
3 replies
I am converting embedded SQL (in Java code) to a stored procedure. They are building SQL WHERE clau…
16 replies
sql query to find a particular word in a field of table eg: in a field, gunapandian is a name, if i…
3 replies
I have searched the web and struggling to find the right answer to this. I think it is simple but …
4 replies
hi, i have a column that's treating dates in an odd way. select filldate, datediff(dd, filldate, g…
3 replies
hello, how i can verify the last date modify of a table or a stored procedure. thank you for your h…
3 replies
Hello - I created a Store Procedure to have Table A sync with Table B by doing an insert of the da…
1 replies
I got asked to not use a cursor for a loop that I'm working on so I grabbed the code here: http://w…
38 replies
I HAVE A TABLE WITH THREE FIELD COMCOD nchar(4) DUPLICATE ALLOWED FOREIGN KEY, ACTCODE nvarchar(6) …
3 replies
TABLE IS LIKE COMCOD ACTCODE ACTDESC 3306 180001 ADVANCE TO ST…
2 replies
Viewing 15 topics - 721 through 735 (of 12,234 total)
You must be logged in to create new topics.
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy