declare @pagesize int
set @pagesize =25
declare @pagenumber int
set @pagenumber =2
declare @from int
set @from = (@pagenumber-1)*@pagesize+1
declare @to int
set @to = @from+@pagesize-1
select @from ,@to
SELECT * FROM ( SELECT * from Employee_tbl ,ROW_NUMBER() OVER (ORDER BY EmployeeID) as rownum FROM Employee_tbl )
seq WHERE seq.rownum BETWEEN @from AND @to ORDER BY seq.rownum
TITLE: Microsoft SQL Server Management Studio
Create failed for Login ‘myNewLoginName’. (Microsoft.SqlServer.Smo)
The MUST_CHANGE option is not supported by this version of Microsoft Windows. (Microsoft SQL Server, Error: 15195)
Reason : The root cause of this problem in SQL Server 2008 is not installed on Windows Sever 200x. So it cannot enforce to change the password polity for this user.
Solution: Uncheck this option.
After reading a post from Pinal I am proposing another solution here to automate SQL backup infrastructure. The dditional advantage here in this approach is , the SQL objects are always created in a seperate file so this can be really helpful to compare your chages in DB from your last version.
1. Get file 0g_SqlExtract.vbs or from attachement to this post.
2. Create a small batch file to call this script. Its handy to call it via batch file I guess. Ofcourseyou can use it directly.
3. Pass the required parameter to the batch file
cscript 0g_sqlextract.vbs %SERVER% %DB% %OUTPUT_FOLDER% %LOGIN% %PASSWORD%
4. Execute your batch file .
Download scripts from here
Have a great day
In our database sometimes we have column names which are actually the database keywords . If we want to access such columns from Nhibernate session , it throws error message “Incorrect syntax near the word :’SOME DB KEYWORD’
Mapping :Before :
Keeping database base reserve keyword in “[ ]” brackets will fix the error message.
You can have look on all my previous Nhibernate posts
Many times we need to perform many repetitive actions on our sql server . Many of those are literaaly repetitve or many of them we really do not do every day but whenever it is , it a collection of steps .
Today we will see how easily we can automate our repetitive work by batch file so that we always donot have to open SQL Server Management Studio and conect to our DB etc….
You can also have a look how to create a log file from batch file in my previous post
Create a batch file :
1. Open your favourite text edidor and write below lines :
SET InvokeSQL=sqlcmd -S %SERVER% -d %DB% -E -b -i
echo %DATE% %TIME% %USERNAME% > %Logfile%
echo calling sql-scripts with: %InvokeSQL% %%scriptfile%% >> %Logfile%
echo. >> %Logfile%
REM START trace32.exe %Logfile%
CALL :RUNProgram 001.sql || GOTO :FAILED
CALL :RUNProgram 002.sql || GOTO :FAILED
echo no errors found – logfile = %Logfile%
echo running %1%
echo =================== running %1% % %TIME% =======================% %>> %Logfile%
%InvokeSQL% %1% %>> %Logfile% 2>&1
echo errors found – logfile = %Logfile%
2. Save file as batch file “myFirstSQLBatch.cmd”
3. Run it !!!!
Thats it !!!