SQL Server Journey with SQL Authority

Posted in Pinal Dave, SQL, SQL Authority, SQL Function, SQL Query, SQL Scripts, SQL Server, SQL String, SQL Tips and Tricks, T SQL, Technology | 9 Comments

9 Responses

1. on December 17, 2007 at 12:59 pm | Reply Arun

   whether there is any way to find the Creating Date of the Table in SQL 2005

   
   
   • on February 15, 2010 at 6:32 pm | Reply Madhivanan

     EXEC sp_help ‘your_table’

     or

     select create_date from sys.objects where name=’your_table’

     
     
2. on April 12, 2008 at 2:09 pm | Reply Dhanu Sahu

   I am new sqlserver i tried every query suggest by you but i cant remove my duplicate row likes Date,Day

   1 2 12-Apr-2008 9:00 AM 11:00 PM Saturday 14 4/12/2008 3:17:11 AM 04 Saturday 2008
   2 2 12-Apr-2008 7:00 AM 11:00 PM Saturday 16 4/12/2008 3:19:27 AM 04 Saturday 2008
   3 2 11-Apr-2008 9:00 AM 10:00 PM Friday 13 4/11/2008 3:24:32 AM 04 Friday 2008
   7 2 11-Apr-2008 8:00 AM 10:00 PM Friday 14 4/11/2008 3:28:18 AM 04 Friday 2008
   8 2 11-Apr-2008 5:00 AM 10:00 PM Friday 17 4/11/2008 3:29:20 AM 04 Friday 2008
   9 2 11-Apr-2008 10:30AM 11:30PM FriDay 12 fbggfb 4/12/2008 3:17:11 AM dfbdfbdfb 04 FriDay 2008

   
   
3. on June 18, 2008 at 4:54 pm | Reply anurag kulshrestha

   i have some problem ,

   i want to create a table name country (country list) and want to insert country name (500 country name )
   it is to difficult for me apply
   this “insert into country (country_name) (‘ INDIA’)”
   single name again an again

   so i want to know how will i insert large amount of data in single entity as in country _name

   With Regard
   Anurag Kulshrestha

   
   
   • on February 15, 2010 at 6:34 pm | Reply Madhivanan

     Have data in a text file and import them using BULK INSERT command

     
     
4. on June 20, 2008 at 3:50 pm | Reply Charanpreet Singh

   hello anurag kulshrestha,Solution for U

   set nocount on;
   declare @values nvarchar(4000);
   set @values=’India|Pakistan|Iran|USA|Australia|Greek|German|turkey|New Zealand|China|Brazil’
   declare @Del char(1);
   set @Del=’|';
   set @values=@values+@Del;
   declare @value nvarchar(100);
   WHILE charindex(@Del,@values,0) 0
   BEGIN
   select @value=rtrim(ltrim(substring(@values,1,charindex(@Del,@values,0)-1))),@values=rtrim (ltrim(substring(@values,charindex(@Del,@values,0)+1,len(@values))))
   if not exists(select @value from daybook where Title=@value)
   begin
   Insert into DayBook(Title) values(@value)
   end
   END

   
   
5. on July 14, 2008 at 5:30 pm | Reply Ganesh

   Hi ,pinal

   I just want to know the query which we can use to list all available servers in mssql 2000/2005.

   Regards..
   Ganesh

   
   
   • on February 15, 2010 at 6:37 pm | Reply Madhivanan

     select * from sys.servers

     
     
6. on September 26, 2010 at 10:59 pm | Reply Koteswarrao

   Hi,

   How to post the queries ?

   Thanks
   Koteswarrao

   
   

Leave a Reply Cancel reply

Enter your comment here...

Fill in your details below or click an icon to log in:

Email (required) (Address never made public)

Name (required)

Website

You are commenting using your WordPress.com account. ( Log Out / Change )

You are commenting using your Twitter account. ( Log Out / Change )

You are commenting using your Facebook account. ( Log Out / Change )

Cancel

Connecting to %s

Notify me of follow-up comments via email.

Notify me of new posts via email.