Topics
Started by
Posts
Last post
Hi All, Looking for assistance to develop T-SQL code Requirement is to delete old files from dire…
12 replies
Hi Friends, create table travel ( user_id varchar(10), from varchar(10), to varchar(10), Lodging va…
3 replies
I have some data coming in with leading 0s as well a +/-. You can see what I have tried so far. I d…
7 replies
Hello Everyone, I'm pretty sure that this is possible but I am stuck. I am trying to write a query …
5 replies
hi i want to make a query to list down all the tables used in stored procedure. plz suggest for exa…
6 replies
Hi All, I have written a T SQL statement and i estimate it will take 8 hours to complete, it has be…
6 replies
Hi, I have found one of the SQL blogs for tracing SP completed duration as below code In this code,…
1 replies
I created a stored procedure which produces xml test data from any table using [INFORMATION_SCHEMA.…
1 replies
I have one xml file with nested data when the xml is loaded with SSIS; it produces 3 tables. I crea…
3 replies
This gives me the location of the log file. How do I view it? SELECT name, physical_name AS current…
4 replies
How do you return the query, login name, and date when data was deleted?
1 replies
Hello all, I was wondering if someone can help me with an issue that I'm having. I'm trying to retr…
11 replies
This is more of a question to people who read code and understand exactly what it does. Like someon…
11 replies
hi i want to do batch and insert records from 1 table to another. code : declare @min-2 int declar…
4 replies
Hi All, I have a database called EmployeeDB and now in this database I have two tables (dbo.employe…
6 replies
Viewing 15 topics - 3,181 through 3,195 (of 10,636 total)
You must be logged in to create new topics.