Windows Authentication mode allows a user to connect through a Microsoft Windows user account

and

Mixed Mode allows users to connect to an instance of SQL Server using either Windows Authentication or...

certainly by looking at your requirement it is not clear what you want and why? but anyway i think your problem can be either resolved with some smart logic using...

can you tell me how are you thinking of passing parameters to text file (.sql ext)? sql file is not an exe to which you can pass parameters but it...

if i am not wrong what i thought earlier is you are using sql variable in back-end but it seems that you want to format your query in the front-end...

hey what i think is you have variable type of data in your document. you definately need to select proper data type for data. if you have numeric value then...

hi frnd,

I think first n foremost thing u need is to have proper indexes in place.

I want to know which sql server u r using. it is a very expected...

most probably as i believe, there is either something wrong with the code or some problem with your network if you are accessing server over network. r u always getting...

Although i believe that dynamic query can be achieved by formatting query in the following way:

declare @col varchar(30)

set @col='empname'

exec('select '+@col+',empname from test')

declare @tab varchar(30)

set @tab='test'

exec('select empname...

hi frnd,

i dont think there is any option of setting column name to any variable and then later using that variable as column name.

becuase variables are used for column value...

Thanks for your interest,

Following is the example. hope it will help you for your problem.

Create Function [dbo].[fn_ParseDelimitedStrings]

(@String nvarchar(3500), @Delimiter char(1))

Returns @Values Table

(

RowId int Not Null Identity(1,1) Primary Key

,Value...

yes, this is the first thing you must always do when you migrate data from one source to another. you must always check your data consistency whether it is in...

unfortunately, sql server doesn't provide array since it is not a full fledge programming language. although the problem can be solved using concatenated string with some specific delimiter. for e.g....