thanks.........

Please give me the steps or provide me the link....

hi,

Create a table.....

CREATE TABLE [dbo].[Employee](

[eid] [int] NULL,

[fname] [varchar](100) NULL,

[lname] [nvarchar](200) NULL

)

Insert some data

Then execute the following Query

Select * into tbl_test from employee where 1=0

The above query will copy only Table...

Thanks Toby.

It gives overall view......:-)

hi,

insert into a (b) values (1), (2), (3)

The above works fine...

The following statement gives error

insert into a (b) values 1,2, 3

please explain brief.....that what () means is :- as...

hi,

Declare @var int

EXEC Sp_myproc @candID = 12,@status = 1 ,@var=@var output

SELECT@var as N'@var'

hi,

There is no such datatype available......

To do like that plz go thru the forum "Select records with Alphanumeric Values" which will give good knowledge...

or click the link given below

Use Top 3 in SELECT statement

I got solution......... :-D:-D

ALTER Table Owners

ADD CONSTRAINT con_owname DEFAULT 'XXX' FOR owname

But Y dont we use Default in the Alter statement. Event the below link shows it in Syntax...by SET...

Please look into the following ones

If the varchar contains Day [Mon or tue..etc] or rd/nd/th [2nd ,12th,23rd] it doesnt allow to use cast ...

SELECT CAST ('02/25/2009' as DATETIME)

...

hi,

U can give permissions for single user to one or more objects. Please go through the wizard with the following steps.

Go To security folder under Databadse.

Right click on selected Use...

hi,

Please look into the following statements....

SELECT CONVERT(VARCHAR(12),GETDATE(),103) ---16/04/2010

SELECT CONVERT(VARCHAR(12),GETDATE(),101) ---04/16/2010

Convert the VARCHAR datatype to DATETIME and use 103 as in the above statements in the backend SP..

Sasidhar Chowdary

hi,

Look into the following links....The column collation list existed .....but not table...

http://www.databasejournal.com/features/mssql/article.php/10894_3302341_1/SQL-Server-and-Collation.htm

http://blog.sqlauthority.com/2008/12/16/sql-server-find-collation-of-database-and-table-column-using-t-sql/

Sasidhar Chowdary

hi ,

I didnt get Ur Problem .....& not good in SSIS....

As per Ur query use replace function .....

ex: Replace(strcolumn,'?',' ')

replace the unwanted chars with space or '' [without space]...

Eswar U r right....

Its not possible. I installed on my local machine...I installed SQL 2008 & then installed SQL 2005, SQL 2005 it installed as SQL express....

hi,

Its worked for me......

I dint get any error........

Execute the following code as it is....

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE function [dbo].[Test_GetOrderTable] (@string varchar(max))

returns @tblOrder Table(id int identity(1,1),strings varchar(100))

AS

begin

declare @LocalVar varchar(100)

declare @pos...